A form "DoRPMReview" will update the roster form, field "scheduled" with DONE, when value in "DoRPMReview" invPro column matches the value in field "uname" in form "roster"

 

 

 

Rows in roster form

 

 

 

 

 

Rows in doRPMReview form

 

Storage format

<ac:structured-macro ac:macro-id="dce50aaf-71aa-440d-a5e6-998489f7ba20" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">roster1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="8113f091-986c-4b97-a739-d81cf74d39d4" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">uname</ac:parameter>
        <ac:parameter ac:name="fieldLabel">User name (pretending this to be a username lookup)</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="5c9f7ef2-d9be-470a-ad68-7bd438fbe7c4" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">scheduled</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Scheduled</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="8818d636-05dc-415e-b2e3-754891f0d0f3" ac:name="confiform-field-definition-rules" ac:schema-version="1">
        <ac:parameter ac:name="condition">id:[empty]</ac:parameter>
        <ac:parameter ac:name="fieldName">scheduled</ac:parameter>
        <ac:parameter ac:name="action">Hide field</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="3d14e1ec-fead-4abd-b24c-94608bbd4a74" ac:name="confiform-entry-register" ac:schema-version="1">
      <ac:rich-text-body>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Rows in roster form</p>
<ac:structured-macro ac:macro-id="c8cf0545-8f41-43c9-8e6e-5190c6f4e792" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="formName">roster1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="57eed379-6e63-43d3-846b-36f46cbca4bb" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">uname</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="b6809586-bb8d-4ac4-8ea5-f32fd039fbaf" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">scheduled</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p> </p>
<p> </p>
<p> </p>
<ac:structured-macro ac:macro-id="c1365415-e3cf-4ccf-8fc7-8a87e55bde4e" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">DoRPMReview1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="0bfd2d8d-0807-4f15-9cfe-4c4f9204b5c3" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">invPro</ac:parameter>
        <ac:parameter ac:name="fieldLabel">User name (inv. Pro)</ac:parameter>
        <ac:parameter ac:name="fieldDescription">(when matches the one in roster, it will update the field scheduled)</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="855ea17f-bdea-4293-89ce-1adf0c1aec5f" ac:name="confiform-ifttt" ac:schema-version="1">
      <ac:parameter ac:name="action">Update ConfiForms entries by filter</ac:parameter>
      <ac:parameter ac:name="event">onCreated</ac:parameter>
      <ac:parameter ac:name="title">scheduled=DONE</ac:parameter>
      <ac:parameter ac:name="extras2">uname:[entry.invPro]</ac:parameter>
      <ac:parameter ac:name="who">roster1:12223039</ac:parameter>
      <ac:rich-text-body>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="ea39b47d-8cb8-42ca-b0ff-f44c825eebd1" ac:name="confiform-entry-register" ac:schema-version="1">
      <ac:rich-text-body>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Rows in doRPMReview form</p>
<ac:structured-macro ac:macro-id="9bf33287-9954-4a6d-8dfe-e5002d5d390b" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="formName">DoRPMReview1</ac:parameter>
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="e0a0dcac-61a1-45de-914e-0834db1c61b7" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">invPro</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>