Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confiform IFTTT error:Record in a multi-row field sets the current time for all records' date fields

Dhiraj Kr_ Gupta
Contributor
November 14, 2024

There is a Confiform smart multi-row field called MultiRowfield, which has multiple fields within it, such as datefield. I am getting an error while using an IFTTT macro:

 

entryId=[entry.id]&MultiRowField.datefield=[entry._now]

 

There are multiple records within MultiRowfield, and if one record is modified, the datefield for all records should get the current time as per the formula. However, I am encountering an error."

1 answer

0 votes
Alex Medved _ConfiForms_
Community Champion
November 14, 2024

What is the point of setting a timestamp as a value for the smart multi-row field?

Dhiraj Kr_ Gupta
Contributor
November 14, 2024

"My row is document, and the rows on smart multi row are sections of the document.

 

I Want a normal date column that shows when the document as a whole was last modified, and i want the date field in the smart multi row that shows when each individual section was last updated.

The update of a section does not mean update of the whole, but update of whole means update of all sections."

Dhiraj Kr_ Gupta
Contributor
November 14, 2024

Or simply, we want a value to the datefield within Smart multi row field OnModified

Alex Medved _ConfiForms_
Community Champion
November 14, 2024

Sorry, what?

if you want to track an extra field, a date, in your other form (where you have your smart rows linked to) then you need yo have that field there and have also ConfiForms IFTTT rule that updates that field in that form)

Dhiraj Kr_ Gupta
Contributor
November 15, 2024

Let’s say i am trying to make a catalogue of books in a library.

 

For this i have created 2 separate forms and dashboards. 

1st one is for individual books in the library - this is being done through a confiform, i have IFTTT defined there to get the last issued date (on modified). So, whenever a book is issued to someone the admin can come and edit the details and the issued date is automatically changed to the current time.

 

2nd one if for collection of same books – If there are 30 of a particular book, I am using the 2nd confiforms to have all of them connected together. Where the “smart multi row” contain the individual book data from the 1st form. Now, at the end of every week, a check needs to be performed to see if no discrepancy is present, so to make that process easier, I want to provide an option on 2nd form table view where I have the action button “Attest” which changes the Status field, which triggers a IFTTT (“on modified” “Create/update confiforms entry”) to update a date last attested. This date field I want to be showcased on the 1st dashboard. 

 

A additional thing is if the attestation is done through 2nd dashboard all books in the multi row should have the new date showcased, and if the attest is done through 1st dashboard then only that one book record should have the new date (Provide the feature to attest multi books altogether or individual books one at a time).

 

Please tell if my approach and be improved.

 

The problem I am facing is that the IFTTT in the 2nd dashboard is unable to make changes to the smart row fields. For the “Parameters to set on the entry” I am using the following “entryId=[entry.id] & MultiRowField.datefield=[entry._now]”. I am assuming the multirow fields cant be assessed through this syntax, so can you help me figure out the correct way to do it.

Alex Medved _ConfiForms_
Community Champion
November 15, 2024

You need to set up the IFTTT rule in the form where your MultiRowField is connected to (where it creates/updates records)

Do you understand that? This is where you put the ConfiForms IFTTT that updates the datefield... not in the form that HAS the MultiRowField

Alex

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events