Announcements
Hello, I haven't used Forms before but understand the basics. I'm using a SQL Database and have a table (the Form) where I use references to other tables (an ID but not the primary key of a record, because its multilingual). I could just make alle Inputs myself and use the patch function but guessed it would be faster to just use a Form. my question is: Can I show values like "due", "overdue" as a selection in a form but submit 1, 2 to the table instead of the strings? The user sees the referenced word in his language -> the table only saves the referenced ID.
in your dropdown or combobox which your user is interacting with you have items property where you can provide a Table like this
further on in your patching function you would then use
Yes I know this. My question is, if I can achieve this by only using a Form and SubmitForm(), but I tried it and it looks like it doesn't work. So I'm gonna create my on inputs and just Patch().
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 207 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2
