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"
ConfiForms Form Definition | ||
---|---|---|
| ||
|
Rows in roster form
ConfiForms Form Definition | ||
---|---|---|
| ||
ConfiForms Form Definition | ||
---|---|---|
| ||
|
Rows in doRPMReview form
ConfiForms TableView | ||
---|---|---|
| ||
Storage format
Code Block |
---|
<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>
|