Update Confiforms entries by filter on modified is not working

dvillacorte
Contributor
September 16, 2021

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.

 

iftt-rule.pngifttt-rule-parameter.pngifttt-rule-filter.png

 

@Alex Medved _ConfiForms_ your assistance will be much appreciated. Thanks!

2 answers

1 accepted

1 vote
Answer accepted
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 17, 2021

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

dvillacorte
Contributor
September 18, 2021

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!

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 18, 2021

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

0 votes
dvillacorte
Contributor
September 16, 2021

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]&amp;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>

Gray Siegel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 2, 2024

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

 

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 2, 2024
Gray Siegel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 2, 2024

Works great- thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events