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")
| Warning |
|---|
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 |
| ConfiForms Form Definition |
|---|
| formName | myform |
|---|
| debugMode | true |
|---|
|
| trueINLINE
keykeytexttrue startstartdate endenddate followTaskKeyfollowTaskKeytext hasChanged(end):truetrueUpdate ConfiForms entries by filteronModifiedstart=[entry.end]key:[entry.followTaskKey]
|
| ConfiForms TableView |
|---|
|
| trueINLINE
|
Storage format for the demo
| Code Block |
|---|
<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> |
