You are viewing limited content. For full access, please sign in.

Question

Question

Save Form Data to a CSV on Submit

asked on July 31, 2023

Hi - I have a Form in LF Cloud. An ID number is entered, then a Lookup Table Query runs to fill part of the form with the data that matches the lookup table ID. Including a hidden field called "Number of Times Your Information Has Been Updated"

Then the user fills out a few more fields and radio buttons on the form and submits it:

My Question is - How do I, on submission presumably, then update that "Number of Times Your Information Has Been Updated" field IN THE RECORD on the Lookup Table I used to originally populate the form?

So, if when the form was first populated, the Number of Times the Form has been updated is "5", then when the form is saved, that table cell should then be updated with the number "6" so that when someone returns to that form the Number of updates reads "6" and autopopulates into the form as such.

 

I'm trying lookup query's with an insert statement but I just cant seem to get it.

0 0

Answer

SELECTED ANSWER
replied on August 1, 2023

Hi Steve, you have to use the Update action instead. Your "where" statement would be the ID used, and the "set" statement would be the new Number of Times. You can use the token calculator activity to increment 1 to the old field if needed.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.