Have you ever needed to show data in a form after it has been submitted?
This is a common challenge when working with Yeeflow forms. Recently, one of our users wanted to display data from a datalist table after a form submission. Initially, they tried using a calculation with the listlookup function, but encountered an issue: the form didn’t have the value in the datalist at the time it was first created, and calculations don’t run after a form is submitted.
Here’s how we solved it:
Instead of using a calculation, we used a “Query data” action. This action allows you to pull the data you need from the datalist and display it, even after the form has been submitted. By setting up the action to run when the page loads, you can save the queried data to a variable that can be used in the form.
This way, every time you revisit the form after it’s been submitted, the latest data will be queried and displayed as needed.
Steps to achieve this:
- Add a “Query data” Action: Configure an action in the form to query the data you need from the datalist.
- Set Action to Trigger on Page Load: Ensure the action is set to trigger whenever the page loads, so it runs every time the form is accessed after submission.
- Store the Data in a Variable: Save the queried data to a variable in your form. You can use this variable in calculation fields or other controls within the form.
This solution provides a dynamic way to keep your forms updated with the latest information, even after submission. It ensures that users always see the most current data when revisiting a form, making workflows smoother and more efficient.
We hope this helps others facing similar challenges! If you’ve got questions or have found your own solutions, we’d love to hear them in the comments below.