Populate some fields of the form based on input and get data from another table

I am creating an app for our non-profit retirement home, which serves around 100 residents. I need to capture basic data such as Apartment Number, Names, Telephone Numbers, and Email IDs. To start, I created a sample Jotform Table with 12 rows. My plan is to use this data to automatically fill fields in various forms, such as those for Breakfast, Lunch, Dinner, Absence, and Guests. These forms will be used daily, weekly, or monthly to record food choices and other details.

For example, when a form is opened in the app, the user should be able to enter or select their Apartment Number, and then the other fields like Names and Telephone Numbers should auto-populate. After that, the user can make their selections for the day, week, or month.

I am currently stuck on how to populate the form fields with specific data from the table. How can I solve this issue?

Hi Ninan,

Thanks for reaching out to JotForm Support. I see that you also asked this question on another thread. You can check out our answer to that here.

Reach out again if you need any more help.