nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update Confiforms entries by filter on modified is not working

dvillacorte

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!

Accepted answers

Alex Medved _ConfiForms_

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

All comments

dvillacorte

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>

<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>

<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>

<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>
 </ac:rich-text-body></ac:structured-macro>

-- update booking if archived is true

<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>
 </ac:rich-text-body></ac:structured-macro>

-- create booking for FOCUS training --

<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>
 </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="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>
<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>
<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>
 <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>
 </ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
 
 
 
<hr />

<h2>Employee Bookings</h2>

<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>

<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>

<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>

<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> <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>
 </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>
<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>
<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>
<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>

<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>
 </ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>

Alex Medved _ConfiForms_

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

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!