How to Update one Confiform entry with another Confiform Entry

[Erin Smith]

I am currently building a form that has a smart dropdown linked to another form. What I want to do is update the second form with a notation any time the selection is made in the first form. If the first form is asking users to select from a list of options that are generated from a smart dropdown referencing form 2, I want to mark the option in form 2 as having been used so the next person can't see that option (basically making a notation that can be filtered on so the list shrinks every time someone makes a selection).

Example:

Form 1 has a smart dropdown referencing option in form 2

First person sees options 1, 2, 3, 4, 5, 6 on form 1

They choose option 3

The first form updates option 3 in the second form to reflect that choice

Person 2 would then only see options 1, 2, 4, 5, 6

I know you can update an entry in the same confiform using the IFTTT macro and the code entryId=[entry.id]&(whatever field you want to update in that entry), but I don't know how to tell the IFTTT to update a different form.

Any and all help would be appreciated.

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

You can use Update by Filter IFTTT - https://wiki.vertuna.com/display/CONFIFORMS/Configuring+ConfiForms+IFTTT+actions+and+rules#ConfiguringConfiFormsIFTTTactionsandrules-UpdateConfiFormsEntriesbyFilter

The filter would be then something like

id:[entry.smartfield_name_here]

Alex

[Travis R]

Hi Alex. I created a similar solution as Erin and your answer worked for me too.  However I am curious as to how this works. My understanding is that an id is like "93f7401f-0684-423d-bbc4-9e0630c9b1fe". So how is it that the "id" will match the smartfield_name on the other form?

[Alex Medved _ConfiForms_]

Smart fields hold the IDs of the records they reference

[Erin Smith]

Hi Alex,

This has been working wonderfully for over a year, but has suddenly stopped updating the secondary form. 

My code is as follows:

entryId=[entry.id]&FieldNametobeUpdated=UpdateValue

FormName:this (where "this" represents the page the form is on as they are both on the same page)

id:[entry.SmartDropdownField]

Any idea why this would suddenly stop working?

Thanks

[Alex Medved _ConfiForms_]

Hi

Please look at the changes done to your form's configurations.

This could not "suddenly stop", there must be a change being made

However, I dont quite get why do you have this

entryId=[entry.id]&FieldNametobeUpdated=UpdateValue

When you actually attempt to update ANOTHER form

Alex

[Erin Smith]

Hi Alex,

The entryID=[entry.id] line is the "Parameters to set on the entry"

Where the [entry.id] is set in the "Filter to apply before update" which is id:[entry.SmartDropdownField]

Nothing has changed on the form. The only thing I can think of is that our version of Confluence has been recently updated but our version of Confiforms has not. I know there are changes in newer versions of Confiforms to allow Confiforms to work with older versions of Confluence, but is it possible that older versions of Confiforms would break with newer versions of Confluence?

(I'm guessing the answer is yes, but I'm not the system admin, so I need confirmation before I beg them to update things)

[Alex Medved _ConfiForms_]

It is just impossible for me to advise anything, without knowing the exact configuration 

But, what I was trying to tell is that the entryId=[entry.id] doesn’t make much sense there. 

Alex