Question

Lookups from previously submitted forms

Forms

Updated December 18, 2023

asked on December 15, 2023

Can you do lookups from a previously submitted form to show the data that was entered when filling out a new form? So, if we do a yearly form and we want to see what we entered last year on a specific question, can we do a lookup for that? If so, how is that done. Has anyone done this yet?

Thanks

Robin

0 0

Replies

replied on December 18, 2023

The only I can think to do this is to query the Forms database and retrieve the variable data. You may need to re-query the data if it isn't saved on the form. Another thing to consider is how long forms keeps your data, so check what you have that set to in case it is less than a year. You can also ask this question to the main Answers forum. You're sure to get more responses.

1 0

replied on December 18, 2023

The form I'm wanting to do this with will only have less than 10 forms submitted each year. Do I need to save every field in the metadata for the template or can I pull the fields from the forms database without having to do this. It is a very lengthy report with 7-8 pages. Most questions are radio buttons with comment fields. The question posed to me was, "For next year, can the user pull up what they entered last year to see how they might want to answer the question for this year?" I'm saving the Instance ID as a field to help with a lookup for next year. Any other suggestions?

0 0

replied on December 18, 2023

ya, save what you need into a table. What Blake said below lol

1 0

replied on December 18, 2023

Robin, I would create a SQL database table that you can insert into each time one of these 10 forms is submitted each year and then configure it as a data source within Forms to pull from.

1 0

replied on December 18, 2023

Thanks, Blake, I'll get with you on how to send the data to the SQL database. That sounds like a good idea.

1 0

You are not allowed to follow up in this post.

Question

Question

Lookups from previously submitted forms

Replies

Sign in to reply to this post.