I have 2 forms, an employees register form and a bookings form. Both have user field and checkbox field called "archived".
When a new user is created in the first form, a booking record is added to the second form. This IFTTT rule onCreated works.
When an existing user is archived in the first form by ticking the "archived" checkbox, the booking records of the same user in the second form should update the "archived" field to true. This IFTTT rule onModified doesn't work.
@Alex Medved _ConfiForms_ your assistance will be much appreciated. Thanks!
Hi
Your condition in IFTTT is incorrect and... as it something like
true:true
after evaluating [entry.archived] field value
If you want to trigger this when "archived" field gets a true value then you need to put something like
archived:true
If you want to track the moment (transition) when "archived" field gets this value then you put something like
hasChanged(archived):true AND archived:true
See more on filters
https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Filters
and on functions (such as hasChanged) here: https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions
Alex
I corrected the filter [entry.archived]:true to archived:true and it is now working. Silly me! Thank you for spotting my mistake, @Alex Medved _ConfiForms_ . You're a rock star!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No problem. Glad to help.
This is actually quite a common mistake by ConfiForms users. And it looks like we need to do a better job at clarifying the filters/conditions
will take this as an action point
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here is the storage format:
<ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="a3010665-19f6-4f36-a2d6-7e02b41fc781"><ac:parameter ac:name="formName">eRegister</ac:parameter><ac:parameter ac:name="export">true</ac:parameter><ac:parameter ac:name="registrationFormTitle">Employees Register</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="ad22338e-eddc-4988-9707-72766921acd9"><ac:parameter ac:name="fieldName">nameEmployee</ac:parameter><ac:parameter ac:name="fieldLabel">Employee Name</ac:parameter><ac:parameter ac:name="values">false[]</ac:parameter><ac:parameter ac:name="extracontext">true</ac:parameter><ac:parameter ac:name="type">user</ac:parameter><ac:parameter ac:name="separator">, </ac:parameter><ac:parameter ac:name="required">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="f95b8dd0-ad74-47d3-89fa-4a1d443f0e39"><ac:parameter ac:name="fieldName">archived</ac:parameter><ac:parameter ac:name="fieldLabel">Archived</ac:parameter><ac:parameter ac:name="restrictions">dvillacorte</ac:parameter><ac:parameter ac:name="fieldDescription">Mark as archived</ac:parameter><ac:parameter ac:name="extracontext">true</ac:parameter><ac:parameter ac:name="type">checkbox</ac:parameter><ac:parameter ac:name="separator">, </ac:parameter></ac:structured-macro></p>
<p><br /></p>
<ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="d134e460-eb52-4cf2-b835-67fcd9b18dce"><ac:parameter ac:name="restrictions">dvillacorte</ac:parameter><ac:parameter ac:name="registrationButtonLabel">Add new employee</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><br /></p>
<p>-- update booking if archived is true</p>
<ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="02dece71-b2b6-41b9-8fca-1a1cd0f3a557"><ac:parameter ac:name="condition">[entry.archived]:true</ac:parameter><ac:parameter ac:name="extras3">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">archived=true</ac:parameter><ac:parameter ac:name="extras2">nameEmployee:[entry.nameEmployee]</ac:parameter><ac:parameter ac:name="who">eBookings:158761431</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p>-- create booking for FOCUS training --</p>
<ac:structured-macro ac:name="confiform-ifttt" ac:schema-version="1" ac:macro-id="6b6bbdbc-7f78-4272-8e31-8bc803c1d815"><ac:parameter ac:name="extras3">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">nameEmployee=[entry.nameEmployee]&bookSession=CRM Training</ac:parameter><ac:parameter ac:name="who">eBookings:158761431</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p><br /><br /></p></ac:rich-text-body></ac:structured-macro>
<ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="f73d0499-da1c-499f-98de-3bc13652c6a3"><ac:parameter ac:name="messageToShowWhenEmpty">No completed orientation for new employees</ac:parameter><ac:parameter ac:name="formName">eRegister</ac:parameter><ac:parameter ac:name="export">true</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="ae661716-d699-4ab0-b695-a2449252e3dd"><ac:parameter ac:name="fieldName">nameEmployee</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="0ecd23fa-ed14-4f3c-a157-069bf7c52210"><ac:parameter ac:name="fieldName">archived</ac:parameter></ac:structured-macro></p>
<p><br /></p><ac:structured-macro ac:name="confiform-entry-edit" ac:schema-version="1" ac:macro-id="4b2ae0fc-bdf7-4c5f-84c0-413ed8ee5b5d"><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>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<hr />
<h2>Employee Bookings</h2>
<p><br /></p>
<ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="6f98cda6-4252-482d-a3dd-041d986084cf"><ac:parameter ac:name="formName">eBookings</ac:parameter><ac:parameter ac:name="export">true</ac:parameter><ac:parameter ac:name="registrationFormTitle">Employee Bookings</ac:parameter><ac:rich-text-body>
<p><br /></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="dfcb4531-4492-45a2-bb35-300d61dd97fe"><ac:parameter ac:name="fieldName">nameEmployee</ac:parameter><ac:parameter ac:name="fieldLabel">Employee Name</ac:parameter><ac:parameter ac:name="values">Book a session</ac:parameter><ac:parameter ac:name="extras">yyyy-MM-dd</ac:parameter><ac:parameter ac:name="extracontext">true</ac:parameter><ac:parameter ac:name="type">user</ac:parameter><ac:parameter ac:name="required">true</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="eeba9484-8a48-4614-b2d8-1de56098d67f"><ac:parameter ac:name="editRestrictions">dvillacorte</ac:parameter><ac:parameter ac:name="fieldName">bookSession</ac:parameter><ac:parameter ac:name="fieldLabel">Link to book session</ac:parameter><ac:parameter ac:name="values">Yes</ac:parameter><ac:parameter ac:name="extras">No</ac:parameter><ac:parameter ac:name="fieldDescription">Click link to book session</ac:parameter><ac:parameter ac:name="extracontext">true</ac:parameter><ac:parameter ac:name="type">link</ac:parameter><ac:parameter ac:name="separator">, </ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="e16ecd4e-955b-4a5b-8c4b-0f6ec8b46fea"><ac:parameter ac:name="fieldName">archived</ac:parameter><ac:parameter ac:name="fieldLabel">Archived</ac:parameter><ac:parameter ac:name="extracontext">true</ac:parameter><ac:parameter ac:name="type">checkbox</ac:parameter><ac:parameter ac:name="separator">, </ac:parameter></ac:structured-macro></p>
p><br /></p><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="88e4d4af-41d7-43e4-a91c-18d441e5d35d"><ac:parameter ac:name="registrationButtonLabel">Create booking</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>
<ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="c9a4b507-c53d-4798-80dc-ef77a4c47594"><ac:parameter ac:name="formName">eBookings</ac:parameter><ac:parameter ac:name="enableSearch">true</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="724200d6-647b-4b27-aaa5-3d4bba4c704f"><ac:parameter ac:name="fieldName">nameEmployee</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="1d57caac-a758-424f-b341-8b4cb518865b"><ac:parameter ac:name="fieldName">bookSession</ac:parameter></ac:structured-macro></p>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="38457bbe-09d7-41c5-89a5-07bfda0958e6"><ac:parameter ac:name="fieldName">archived</ac:parameter></ac:structured-macro></p>
<p><br /></p><ac:structured-macro ac:name="confiform-entry-edit" ac:schema-version="1" ac:macro-id="6153490e-efe9-4117-b67f-97da5ee982a5"><ac:parameter ac:name="inline">true</ac:parameter><ac:parameter ac:name="showCopy">true</ac:parameter><ac:parameter ac:name="updateMessage">Saved</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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is it possible to define a filter where the text value IS NOT something?
For example, a field called somefield. The filter would apply if the text value of this field IS NOT sometext.
Something like this...
somefield.label<>sometext
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
!somefield.label:sometext
https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Filters
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Works great- thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.