You're welcome!

Hello easysessionnotes, The feature you're looking for isn't currently possible. The data from the Tables can't be used as dropdown options. The Tables can be used to prefill the fields instead. Guide: www.jotform.com/help/1805-what-is-jotform-prefill-and-how-does-it-work/. Anyway, we escalated this as a feature request to our Developer Team. You can check the request ticket on this link: www.jotform.com/answers/3971179. When or if it's developed depends on their workload, how viable it is, and how many other users request it but once this is implemented, we'll let you know. With regards to the other features you mentioned, please provide us more details by contacting us at www.jotform.com/contact/ so we can further assist you.

Heyy, I also thought it was a full integration between forms, they made it seem like that's what it was in their promotiom videos of this feauture. Anyway, I have the same issue as you, were you able to solve this with the prefill options as recommended?

@@smallypuppy22 No, the recommended option is too static, it will not work for me, I'm doing the database part manually, I hope we get someday that whole interaction. There is a lack of this feature on the market, at least I can't find software to do that, Airtable and Jotform are the closest to what I need, but Airtable is not user-friendly. I just need a User Interface to handle web the interaction with tables, add new records, read from records and show it as a dropdown, texts and do all the formulas in the excel available on excel of course in the background. The closest I'm using is a software spreadsheetconverter is a plug-in for Excel, so you can do all you want in excel and then compile it to HTML, it is expensive but amazing, but still lacks the functionality to add new records

@@easysessionnotes3647 thanks for answering. I also have been working through this but have not been able to come up with a complete solution, sadly. I would be very grateful if you could share with me the name of that plug-in, sounds pretty good.

Hi Chariz, It is not currently possible to fill the dropdown field options with data from the table automatically. However, if you mean to prefill a dropdown field with data from the table, that's possible through Prefill. Guide: www.jotform.com/help/1805-what-is-jotform-prefill-and-how-does-it-work/. Please contact us in our Support System via our Support Contact Form here www.jotform.com/contact/ if you have more questions so we can help.

Hello Natasha, It is possible to achieve that in the Tables using the formula column. Here's a video we created for your case: link.jotform.com/A8zkAZHkKM. The formula in string is =IF({5}="","Unpaid","Paid"), replace the field variable {5} with your payment method field variable. If you need further assistance, please contact us through our support contact form at www.jotform.com/contact/ and we would be happy to assist you.

@@Jotform thank you so much for your support I tried the formula and it worked. Am still working on improving my skills in using formulas. Your video was very helpful and greatly appreciated. You guys should do more videos on using formulas giving different examples of each, am sure the community will appreciate it I know I definitely will. Thanks again for your support keep up the great job.

Hello smallypuppy22, Thanks for sharing your thoughts, we really appreciate it. If you're going to assign a person to a project as shown in this video, I think it is a matter of manual choice. However, once you're done, you can use Lookup function to automatically prefill other columns associated with the assigned data. If you need further assistance or if you have any suggestions that would help improve the Table functions, please share it with us via our Support Contact Form www.jotform.com/contact/ so we can assist you further.

@@Jotform Thank you for answering. I do not have any suggestions, I am actually using the prefill option to pass some data from form 1 to form 2 and will use Google Sheets to connect everything. However it would be wonderful if this was all connected in jotform by some unique id that appears in both tables (from each form) without having anyone assign it manually. Also I have tried all day to find out if prefilling my form will only work if the user goes inmediately to the next form, and what happens if the user doesn't, which will mean that none of the data that I'm gonna use as keys are going to be passed on, which would make all my progress futile.

Hello smallypuppy22, we recommend using a Unique ID widget if you want to pass a unique value from form 1 to form 2 so you can easily compare the submissions on Tables later on. The Unique ID can be found on the Widgets tab in the form builder or you can get it here www.jotform.com/widgets/unique-id. With regards to your other question, you can add a condition on your second form that if a certain field, maybe a hidden field is field (which means already prefilled), then show all the fields in your form so if ever the user skips form 1 and goes to form 2 directly, they will not be able to see any fields unless they submits the form 1. Here's how to show/hide multiple fields at once www.jotform.com/help/196-hide-or-show-multiple-fields-at-once/. Please contact us in our Support System via our Support Contact Form here www.jotform.com/contact/ should you need further assistance so we can assist you further.

We believe it is and here's our side-by-side comparison with Airtable www.jotform.com/jotform-tables-vs-airtable/. If you have any other questions, let us know at www.jotform.com/contact/ so we can help. Regards!

Hello, its possible create a column call "Project status" and udpate automatically to starting, in progress, finished? How do you this?