Filter for deleting first record

[Ryan Kafoor]

I want to delete the first entry when a second entry is created. I have tried using the filter "!createdBy:[entry._user]" in an IFTTT rule; as the second entry will always be created by a new person. But it doesn't seem to be working so far. What should I be doing here instead?  

[Alex Medved _ConfiForms_ · Accepted solution]

Do you want to delete all "other" (earlier) entries in the form and keep just one latest record?

!id:[entry.id]

Alex

[Ryan Kafoor]

Yes deleting all other previous entries would also have the intended effect. But !id:[entry.id] doesn't also seem to work. 

[Alex Medved _ConfiForms_]

What does not work for you?

Here is a very simplified demo, hope it helps to see what you are doing differently

https://recordit.co/GPSkx9TLcC

With a storage format for the reference

<ac:structured-macro ac:macro-id="41504f13-d5ba-4828-963c-3d64d02602a3" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">myform</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="4a351cf4-c4c4-4bf9-ad54-ed43a60b1d76" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">t</ac:parameter>
<ac:parameter ac:name="fieldLabel">t</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="b7ffb202-1dc6-4bfb-a99e-fc9690fabaa7" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">delAll</ac:parameter>
<ac:parameter ac:name="fieldLabel">Delete all other records but this?</ac:parameter>
<ac:parameter ac:name="type">checkbox</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="98d05411-c5d3-443d-830a-394384e59861" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="condition">delAll:true</ac:parameter>
<ac:parameter ac:name="action">Delete ConfiForms Entry</ac:parameter>
<ac:parameter ac:name="event">onCreated</ac:parameter>
<ac:parameter ac:name="title">!id:[entry.id]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="59c5375f-fcb5-4738-999f-9efe8d68f4ee" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="condition">delAll:true</ac:parameter>
<ac:parameter ac:name="action">Delete ConfiForms Entry</ac:parameter>
<ac:parameter ac:name="event">onModified</ac:parameter>
<ac:parameter ac:name="title">!id:[entry.id]</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="905de818-6823-4c61-8f4e-2885e8111318" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">myform</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="394afb0e-4a75-413c-8e88-9b80a07ff852" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">myform</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>

Alex

[Ryan Kafoor]

Thanks for the recording, but I still cannot figure out why the IFTTT is not working, even without a condition. 

<ac:structured-macro ac:name="info" ac:schema-version="1" ac:macro-id="4dcc0f62-70c3-425d-b795-50108938917b"><ac:rich-text-body>
<p>Make sure that all the information entered is correct and enter submit</p></ac:rich-text-body></ac:structured-macro>
<p><br /></p><ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="edbaebb2-e65c-41bb-b885-91fb5b576c70"><ac:parameter ac:name="anonymousInput">true</ac:parameter><ac:parameter ac:name="autocomplete">true</ac:parameter><ac:parameter ac:name="formName">regform</ac:parameter><ac:parameter ac:name="autoDelete">true</ac:parameter><ac:parameter ac:name="maxCapacity">2</ac:parameter><ac:parameter ac:name="saveButtonLabel">Submit</ac:parameter><ac:parameter ac:name="uniqueByUser">true</ac:parameter><ac:parameter ac:name="maxCapacityMessage">You have already submitted. Multiple submissions are not possible.</ac:parameter><ac:parameter ac:name="uniqueByUserMessage">You have already submitted. The form is now in a new workflow state.</ac:parameter><ac:parameter ac:name="registrationFormTitle">Guest registration form</ac:parameter><ac:rich-text-body>
<p><br /></p>
<p>**Rule to send an email to the guest after the host has entered submit</p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="6a207220-c25d-49b3-857e-aae03579ba87"><ac:parameter ac:name="condition">!dummy:true</ac:parameter><ac:parameter ac:name="silent">true</ac:parameter><ac:parameter ac:name="action">Send Email</ac:parameter><ac:parameter ac:name="event">onCreated</ac:parameter><ac:parameter ac:name="title">Guest registration</ac:parameter><ac:parameter ac:name="who">[entry.guestemail]</ac:parameter><ac:rich-text-body>
<p>Here is the link to the form. Please register yourself as a guest</p>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="ba974845-91d9-47eb-a519-e2f49eae0b2c"><ac:parameter ac:name="fieldName">pagelink</ac:parameter></ac:structured-macro></p>
<p>Regards</p>
<p>{*Formatting needed*}</p></ac:rich-text-body></ac:structured-macro><br />
<p><br /></p>
<p>**Rule to update the dummy field to true after submit by the host</p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="a1e4ef85-bbab-46c9-86e7-a0ce3c54abf9"><ac:parameter ac:name="extras5">true</ac:parameter><ac:parameter ac:name="condition">!dummy:true</ac:parameter><ac:parameter ac:name="silent">true</ac:parameter><ac:parameter ac:name="action">Create ConfiForms Entry</ac:parameter><ac:parameter ac:name="event">onCreated</ac:parameter><ac:parameter ac:name="title">entryId=[entry.id]&amp;dummy=true</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p><br /></p>
<p>**Rule to delete the first entry after the guest submits the form</p><ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="1979367c-2fb2-4037-a0d0-0e257644fbb2"><ac:parameter ac:name="condition">dummy2:true</ac:parameter><ac:parameter ac:name="action">Delete ConfiForms Entry</ac:parameter><ac:parameter ac:name="event">onCreated</ac:parameter><ac:parameter ac:name="title">!id:[entry.id]</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p><span style="letter-spacing: 0.0px;"> </span></p>
<h5>Field definitions</h5>
<p>**Fields to be filled by host</p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="ef0bc351-53f9-4713-980b-f617ae407c7a"><ac:parameter ac:name="fieldPlaceholder">Institute/Chair hosting the guest</ac:parameter><ac:parameter ac:name="fieldName">hostunit</ac:parameter><ac:parameter ac:name="fieldLabel">Hosting research unit</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="06fdf2ac-654a-4078-b5e1-16998e5fbb2e"><ac:parameter ac:name="fieldPlaceholder">Person responsible for the guest</ac:parameter><ac:parameter ac:name="fieldName">supervisor</ac:parameter><ac:parameter ac:name="fieldLabel">Supervisor</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="4420bd7d-e2db-4263-8b77-23c548823199"><ac:parameter ac:name="fieldPlaceholder">Contact e-mail address of the Professor / Supervisor</ac:parameter><ac:parameter ac:name="fieldName">hostemail</ac:parameter><ac:parameter ac:name="fieldLabel">Email address of the supervisor</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="bf1c2e08-473e-404c-a6cf-f53b6569259d"><ac:parameter ac:name="fieldPlaceholder">Contact telephone number of the Professor / Supervisor</ac:parameter><ac:parameter ac:name="fieldName">hosttel</ac:parameter><ac:parameter ac:name="fieldLabel">Supervisor Telephone/Mobile No.</ac:parameter><ac:parameter ac:name="type">number</ac:parameter><ac:parameter ac:name="separator">false</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="c7cf1ff0-70f9-40a0-9b25-3b64e51ea3e2"><ac:parameter ac:name="fieldPlaceholder">Additional contact person at chair/institution</ac:parameter><ac:parameter ac:name="fieldName">hostaddcontact</ac:parameter><ac:parameter ac:name="fieldLabel">Additional contact person</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="c2e8a44b-2e7e-4c85-ad34-627f246aaa1c"><ac:parameter ac:name="fieldName">hostaddemail</ac:parameter><ac:parameter ac:name="fieldLabel">Additional email</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="deb539b1-2931-45ef-8ccf-b664fffdcfb6"><ac:parameter ac:name="fieldName">hostaddtel</ac:parameter><ac:parameter ac:name="fieldLabel">Additional Telephone/Mobile No.</ac:parameter><ac:parameter ac:name="type">number</ac:parameter><ac:parameter ac:name="separator">false</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="46ecc101-2eda-4375-b598-76dd92259a3e"><ac:parameter ac:name="fieldPlaceholder">Please select a type</ac:parameter><ac:parameter ac:name="fieldName">guesttype</ac:parameter><ac:parameter ac:name="fieldLabel">Type of guest</ac:parameter><ac:parameter ac:name="values">false[1=Guest professor|2=Guest researcher|3=Employee of contract partner|4=External Phd Student|5=Cooperative Phd Student|6=External scholarship-holder|7=Retired professor|8=School student|9=External students|10=Other|]</ac:parameter><ac:parameter ac:name="type">select</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="3c1bc38b-53b7-4d1e-8cb7-85765a1e48be"><ac:parameter ac:name="fieldPlaceholder">Please describe the type</ac:parameter><ac:parameter ac:name="fieldName">otherguesttype</ac:parameter><ac:parameter ac:name="fieldLabel">Other guest type</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="eb8c8e81-6763-4f1a-99c4-300ee6900a0b"><ac:parameter ac:name="fieldName">theme</ac:parameter><ac:parameter ac:name="fieldLabel">Theme of scientific collabaration</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="96e4f792-636d-4411-853c-cffaaf771457"><ac:parameter ac:name="fieldPlaceholder">Please choose a specification</ac:parameter><ac:parameter ac:name="fieldName">spec</ac:parameter><ac:parameter ac:name="fieldLabel">Specification</ac:parameter><ac:parameter ac:name="values">false[0=Joint research and publication|1=Joint funding proposal|2=Teaching|3=Other|]</ac:parameter><ac:parameter ac:name="type">select</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="991b068b-d69d-4141-8775-b175b5e759b5"><ac:parameter ac:name="fieldPlaceholder">Please mention if other</ac:parameter><ac:parameter ac:name="fieldName">otherspec</ac:parameter><ac:parameter ac:name="fieldLabel">Other spec</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="091fa428-319b-41c8-8f4c-cdb64baea983"><ac:parameter ac:name="fieldName">goal</ac:parameter><ac:parameter ac:name="fieldLabel">What is the goal of the stay at TUM? (e.g., paper, talk, summer school, etc.)</ac:parameter><ac:parameter ac:name="type">textarea</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="d0a0da28-98ad-4cfc-b0a7-9f9a211c360f"><ac:parameter ac:name="fieldName">guestemail</ac:parameter><ac:parameter ac:name="fieldLabel">Guest Email address</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="33ffa6e1-b9dd-431f-a15b-d64a7013a332"><ac:parameter ac:name="fieldName">publicevent</ac:parameter><ac:parameter ac:name="fieldLabel">Do you plan to hold a public event at TUM (e.g., Lecture, Talk, etc.)?</ac:parameter><ac:parameter ac:name="values">Yes</ac:parameter><ac:parameter ac:name="extras">No</ac:parameter><ac:parameter ac:name="type">checkbox</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Fields to be filled by guest</p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="9db16420-a7d0-480f-a223-02da9e4b9377"><ac:parameter ac:name="fieldName">guesttitle</ac:parameter><ac:parameter ac:name="fieldLabel">Academic title of guest</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="d26a5bff-74c2-4184-8bb4-57cebd3c6238"><ac:parameter ac:name="fieldName">guestsurname</ac:parameter><ac:parameter ac:name="fieldLabel">Surname</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="d2c2e312-f6cd-4e59-9e65-49cb04a1c748"><ac:parameter ac:name="fieldName">guestname</ac:parameter><ac:parameter ac:name="fieldLabel">First name</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="3ddd48a8-f09e-483c-8457-ec94df8dcaca"><ac:parameter ac:name="fieldName">guestgender</ac:parameter><ac:parameter ac:name="fieldLabel">Gender</ac:parameter><ac:parameter ac:name="values">false[0=Male|1=Female|2=Other|]</ac:parameter><ac:parameter ac:name="type">select</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="4cadc2a6-0fbf-46f2-9094-7ec0799d7b37"><ac:parameter ac:name="fieldName">guestnationality</ac:parameter><ac:parameter ac:name="fieldLabel">Nationality</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="a6131a38-0416-42f2-a51e-69b762df4c79"><ac:parameter ac:name="fieldPlaceholder">Address line 1</ac:parameter><ac:parameter ac:name="fieldName">addressline1</ac:parameter><ac:parameter ac:name="fieldLabel">Address line 1</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="f9d22654-31ca-4604-9808-3123d4bb3ccb"><ac:parameter ac:name="fieldPlaceholder">Address line 2</ac:parameter><ac:parameter ac:name="fieldName">addressline2</ac:parameter><ac:parameter ac:name="fieldLabel">Address line 2</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="65e83b97-ea9c-4c47-a594-0fcdbfcdbd33"><ac:parameter ac:name="fieldPlaceholder">City</ac:parameter><ac:parameter ac:name="fieldName">city</ac:parameter><ac:parameter ac:name="fieldLabel">City</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="a52fef00-a0b2-4d68-b17f-ce606b41582e"><ac:parameter ac:name="fieldPlaceholder">Postal/zip code</ac:parameter><ac:parameter ac:name="fieldName">postalcode</ac:parameter><ac:parameter ac:name="fieldLabel">Postal code</ac:parameter><ac:parameter ac:name="type">number</ac:parameter><ac:parameter ac:name="separator">false</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="35de1362-bd51-4f81-ba2e-75a267faf7ce"><ac:parameter ac:name="fieldPlaceholder">Country</ac:parameter><ac:parameter ac:name="fieldName">country</ac:parameter><ac:parameter ac:name="fieldLabel">Country</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="dd039c21-c7c9-4ee2-80e8-fc335d5c39ef"><ac:parameter ac:name="fieldName">guesttel</ac:parameter><ac:parameter ac:name="fieldLabel">Telephone/Mobile No.</ac:parameter><ac:parameter ac:name="type">number</ac:parameter><ac:parameter ac:name="separator">false</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Helper field for form functionality (dummy)</p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="4839d3a2-951d-48e9-87a3-4c80ed693cae"><ac:parameter ac:name="fieldName">dummy</ac:parameter><ac:parameter ac:name="fieldLabel">dummy label</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p>**2nd helper field due to unrecognized bug with the rule for making guest fields mandatory</p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="d3205a20-1c85-4fb9-bb38-eefa46fa3480"><ac:parameter ac:name="fieldName">dummy2</ac:parameter><ac:parameter ac:name="fieldLabel">dummy2 label</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p>
<p>**Link pointing to the form page which is used in the email sent to the guest</p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="ee12fe59-dd0e-4a41-9195-117c7ee3cb58"><ac:parameter ac:name="fieldName">pagelink</ac:parameter><ac:parameter ac:name="fieldLabel">Link to page</ac:parameter><ac:parameter ac:name="values">https://collab.dvb.bayern/pages/viewpage.action?pageId=[entry._storagePage]</ac:parameter><ac:parameter ac:name="type">autolink</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<h5>Rules for fields</h5>
<p><br /></p>
<p>**Rule to always hide dummy (and dummy2)</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="ff743710-4e01-4d0d-858f-ddcf2e7d3a32"><ac:parameter ac:name="fieldName">dummy</ac:parameter><ac:parameter ac:name="action">Hide field</ac:parameter><ac:parameter ac:name="actionFieldName">dummy</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="d85a5231-a8a5-49d4-9a82-005897870302"><ac:parameter ac:name="fieldName">dummy2</ac:parameter><ac:parameter ac:name="action">Hide field</ac:parameter><ac:parameter ac:name="actionFieldName">dummy2</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rule to lookup and set</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="59744db4-7cd8-402d-afdd-e5890a48fbf0"><ac:parameter ac:name="fieldName">dummy=[entry.dummy]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">dummy</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="48cf81f0-d25b-4724-bfed-008d1638d9eb"><ac:parameter ac:name="fieldName">hostunit=[entry.hostunit]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">hostunit</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="03e74b12-4d9e-457c-a59d-ab0f88d9dee9"><ac:parameter ac:name="fieldName">supervisor=[entry.supervisor]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">supervisor</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="1f92ce84-e67f-48b8-8efe-7ac61a065673"><ac:parameter ac:name="fieldName">hostemail=[entry.hostemail]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">hostemail</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="3d94bd60-3b9a-41c4-9518-0067af8d0437"><ac:parameter ac:name="fieldName">hosttel=[entry.hosttel]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">hosttel</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="42ea592c-3e2e-4563-80e9-fe72ff4587a3"><ac:parameter ac:name="fieldName">hostaddcontact=[entry.hostaddcontact]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">hostaddcontact</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="b092abf4-0b3c-4ed5-a17e-054431578360"><ac:parameter ac:name="fieldName">hostaddemail=[entry.hostaddemail]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">hostaddemail</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="c74e76d2-37e6-450c-9d5c-f57539863c62"><ac:parameter ac:name="fieldName">hostaddtel=[entry.hostaddtel]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">hostaddtel</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="b4863445-566b-49be-83f7-dac84e199efb"><ac:parameter ac:name="fieldName">guesttype=[entry.guesttype]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">guesttype</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="609a1aab-c1ca-420e-aeac-09c118b2410a"><ac:parameter ac:name="fieldName">otherguesttype=[entry.otherguesttype]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">otherguesttype</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="f895a628-2307-4c9c-af0c-ad9e37ce13d7"><ac:parameter ac:name="fieldName">theme=[entry.theme]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">theme</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="fbd3ec47-c302-4953-ba2e-7d765fee39f8"><ac:parameter ac:name="fieldName">spec=[entry.spec]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">spec</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="8ffc4187-414d-4dc2-8163-5c01f4328ed6"><ac:parameter ac:name="fieldName">otherspec=[entry.otherspec]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">otherspec</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="1b147572-bd7a-4c6b-ae85-324029ec39b4"><ac:parameter ac:name="fieldName">goal=[entry.goal]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">goal</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="d691da6e-a0b2-4485-9c3f-fbb19c55ee07"><ac:parameter ac:name="fieldName">publicevent=[entry.publicevent]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">publicevent</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="cf1d482a-e8a0-4296-aac8-5318e72b7631"><ac:parameter ac:name="fieldName">guestemail=[entry.guestemail]</ac:parameter><ac:parameter ac:name="action">Lookup and set value</ac:parameter><ac:parameter ac:name="actionFieldName">guestemail</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rule to set value for dummy2 once dummy is set to true</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="4a68926b-e91a-47e2-90b1-a62821b31c68"><ac:parameter ac:name="condition">dummy:true</ac:parameter><ac:parameter ac:name="values">dummy2=true</ac:parameter><ac:parameter ac:name="action">Set value</ac:parameter><ac:parameter ac:name="actionFieldName">dummy</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rules to show/hide fields when other is chosen and make them required(guesttype, spec)</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="5f4525c8-a333-4176-aad4-095e3fdd5e90"><ac:parameter ac:name="condition">!dummy:true AND guesttype:10</ac:parameter><ac:parameter ac:name="fieldName">otherguesttype</ac:parameter><ac:parameter ac:name="action">Show field</ac:parameter><ac:parameter ac:name="actionFieldName">guesttype</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="cfe73e44-f463-4c19-9795-cc2b45647de5"><ac:parameter ac:name="condition">!dummy:true AND spec:3</ac:parameter><ac:parameter ac:name="fieldName">otherspec</ac:parameter><ac:parameter ac:name="action">Show field</ac:parameter><ac:parameter ac:name="actionFieldName">spec</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="2d13c79b-04b0-4f8d-902c-bc5ce821e231"><ac:parameter ac:name="condition">guesttype:10 AND otherguesttype:[empty]</ac:parameter><ac:parameter ac:name="fieldName">Please mention the guest type</ac:parameter><ac:parameter ac:name="action">Validation rule</ac:parameter><ac:parameter ac:name="actionFieldName">guesttype</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="08a5dae2-13a1-4ec6-b417-2bcf1f92eb5e"><ac:parameter ac:name="condition">spec:3 AND otherspec:[empty]</ac:parameter><ac:parameter ac:name="fieldName">Please mention the specification</ac:parameter><ac:parameter ac:name="action">Validation rule</ac:parameter><ac:parameter ac:name="actionFieldName">spec</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rule to hide guest fields when the form is first loaded</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="bd712aed-d5f0-448e-9cbf-d1bdadebc9b2"><ac:parameter ac:name="condition">dummy:[empty]</ac:parameter><ac:parameter ac:name="fieldName">guestname,guesttitle,guestsurname,guestgender,guestnationality,addressline1,addressline2,city,postalcode,country,guesttel</ac:parameter><ac:parameter ac:name="action">Hide field</ac:parameter><ac:parameter ac:name="actionFieldName">dummy</ac:parameter><ac:parameter ac:name="withReverseRule">true</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rule to hide host fields when the form is submitted</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="f54f0631-ca9f-43de-8779-dfdbd53d34ee"><ac:parameter ac:name="condition">!dummy:[empty]</ac:parameter><ac:parameter ac:name="fieldName">hostunit,supervisor,hostemail,hosttel,hostaddcontact,hostaddemail,hostaddtel,guesttype,spec,guestemail,theme,goal,publicevent</ac:parameter><ac:parameter ac:name="action">Hide field</ac:parameter><ac:parameter ac:name="actionFieldName">dummy</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rule to make host fields required</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="3277a095-6e45-4084-9d97-59556f627db3"><ac:parameter ac:name="condition">!dummy:true AND (hostunit:[empty] OR supervisor:[empty] OR hostemail:[empty] OR hosttel:[empty] OR guesttype:[empty] OR theme:[empty] OR spec:[empty] OR guestemail:[empty])</ac:parameter><ac:parameter ac:name="fieldName">Error submitting. Required fields not filled.</ac:parameter><ac:parameter ac:name="action">Validation rule</ac:parameter></ac:structured-macro></p>
<p><br /></p>
<p>**Rule to make guest fields required when shown</p>
<p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="7d41603b-bddb-4cb3-a8ec-a9ebd8e72631"><ac:parameter ac:name="condition">dummy2:true AND (guesttitle:[empty] OR guestname:[empty] OR guestsurname:[empty] OR guestgender:[empty] OR guestnationality:[empty] OR addressline1:[empty] OR city:[empty] OR country:[empty] OR postalcode:[empty]))</ac:parameter><ac:parameter ac:name="fieldName">Required fields not filled</ac:parameter><ac:parameter ac:name="action">Validation rule</ac:parameter></ac:structured-macro></p><br /><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="9dba0fdb-28d3-4c2a-9cdd-dc1cc1198988"><ac:parameter ac:name="hideMetadata">true</ac:parameter><ac:parameter ac:name="overrideSaveButtonLabel">Submit</ac:parameter><ac:parameter ac:name="reportFieldErrors">true</ac:parameter><ac:parameter ac:name="formName">regform</ac:parameter><ac:parameter ac:name="registrationMessage">The form has been successfully submitted. You may now close this page.</ac:parameter><ac:parameter ac:name="registrationButtonLabel">Data</ac:parameter><ac:parameter ac:name="autoAlign">true</ac:parameter><ac:parameter ac:name="type">Embedded</ac:parameter><ac:parameter ac:name="confirmationMessage">Are you sure that you want to submit? Once submitted the data cannot be edited.</ac:parameter><ac:parameter ac:name="regControlLayout">true</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p><br /></p>
<p><br /></p>
<p><br /></p 

[Ryan Kafoor]

Thanks for the recording. I do not do anything differently but It still doesn't seem to work. Could other IFTTTs be interfering with this somehow?

[Alex Medved _ConfiForms_]

Hard to tell - I dont know what other IFTTTs you may have and what they do.

But you can see my demo and see how it is configured to implement the same in your form

Alex

[Ryan Kafoor]

Okay I think I found out the reason. It doesn't work only when the form submission is from an anonymous user. However they do not get an IFTTT error while submitting. Is this something a confluence administrator can control? How do I workaround this?

[Alex Medved _ConfiForms_]

Well, of course it will not work for users who have no permissions to edit/delete records (that is anonymous users, or the ones who are not admins and deleting not own records is not allowed)

You can set up the IFTTT rule to bypass such permissions

Alex

[Ryan Kafoor]

Ohhh yes, thank you very much.