View Source

This is a quick demo on how to use the update by filter action in ConfiForms to update the start date of a record when the connected record's end date has been changed (we have a field to link the records called "followTaskKey")

Please note that this will not work for the anonymous users as editing of records is not allowed by anonymous users here, on this page

Storage format for the demo

<ac:structured-macro ac:macro-id="80ceed3c-d290-4f7b-a9b5-0fb7889bea85" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:parameter ac:name="debugMode">true</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="65b43ec0-68a4-42c7-8d76-12047f59c34f" ac:name="confiform-entry-register" ac:schema-version="1">
      <ac:parameter ac:name="embedded">true</ac:parameter>
      <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <ac:structured-macro ac:macro-id="b73979b0-d005-49c4-8754-9a99fbad3a48" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">key</ac:parameter>
        <ac:parameter ac:name="fieldLabel">key</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
        <ac:parameter ac:name="required">true</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="deff7e36-ff3a-4c4c-910c-40700732b03b" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">start</ac:parameter>
        <ac:parameter ac:name="fieldLabel">start</ac:parameter>
        <ac:parameter ac:name="type">date</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="aff6a98a-87a6-4695-a0ae-1103f06268b0" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">end</ac:parameter>
        <ac:parameter ac:name="fieldLabel">end</ac:parameter>
        <ac:parameter ac:name="type">date</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="35dc6c64-2e45-4bbc-ade7-ce214ac4f44d" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">followTaskKey</ac:parameter>
        <ac:parameter ac:name="fieldLabel">followTaskKey</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="141c26e9-8e0f-48c0-a99f-37356a1a1968" ac:name="confiform-ifttt" ac:schema-version="1">
      <ac:parameter ac:name="condition">hasChanged(end):true</ac:parameter>
      <ac:parameter ac:name="extras4">true</ac:parameter>
      <ac:parameter ac:name="action">Update ConfiForms entries by filter</ac:parameter>
      <ac:parameter ac:name="event">onModified</ac:parameter>
      <ac:parameter ac:name="title">start=[entry.end]</ac:parameter>
      <ac:parameter ac:name="extras2">key:[entry.followTaskKey]</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="b5cdcc8e-b044-4fb2-8c3f-212ddcbf0ff0" ac:name="confiform-table" ac:schema-version="1">
  <ac:parameter ac:name="formName">myform1</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="f2990560-e668-492a-95a7-0387b007b094" ac:name="confiform-entry-edit" ac:schema-version="1">
      <ac:parameter ac:name="compactMode">true</ac:parameter>
      <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>