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
User name (pretending this to be a username lookup) |
Scheduled |
---|---|
testman | DONE |
mietze | |
Doej2 | |
sdfsdfsdfsdf | |
testman | |
DoRPMReview | |
JMeister | |
bloop | |
bloop | |
jumbo | |
test | |
DONE | |
ddd | |
pants | |
karl | |
aaa | |
test4u | |
bloop | |
test | |
bpglen | |
tester | |
testman | |
Yasharah | |
zz | |
Jack | |
beep | |
Lilly | |
mietze | |
abc | |
ddd | |
someone else | |
bloop | |
test | |
ddd | |
test | |
uname | |
bloop | |
bob | |
1qz2wsx | |
sdfs | |
sylvland | |
Michael Jordan | |
snoop | |
hier | |
Krister | |
berg | |
mietze | |
testman | |
,mnkjn | |
Banana | |
mietze |
Rows in doRPMReview form
User name (inv. Pro) |
---|
testman |
someone else |
mietze |
testman |
mietze |
Doej2 |
Doej2 |
uiowouiwehf89 |
mietze |
JMeister |
JMeister |
bloop |
bloop |
Doej2 |
test |
ddd |
test4u |
bloop |
test |
bpglen |
bpglen |
test4u |
mietze |
Yasharah |
zz |
beep |
Lilly |
Lilly |
Lilly |
aaa |
abc |
someone else |
def |
test |
ddd |
test |
1qaz2wsx |
Doej2 |
mietze |
sylv.land |
sylvland |
ddd |
ddd |
Michael Jordan |
snoop |
karl |
hier |
Krister |
berg |
testman |
,mnkjn |
Banana |
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>