Well, after going back and forth with Omni for quite a while, I think I've finally reached the point where I need to ask about this specific scenario.
I have a table where each record generates a unique 6-character code, something like X8MMA3.
Now I'd like to create a public Form where the first field is simply a text input for the user to enter the code they've received separately (for example, by email). This code corresponds to a value in that table. The user doesn't see any other codes—it's not a dropdown or a linked record selector. It's just a plain text field where they type the code they were given.
If the code exists, the user should be able to continue filling out the form and submit it. Submitting the form would create a new record in another table containing the user's inputs along with the code they entered.
The key requirement is this: if the user enters a code that doesn't exist in the table, the form should immediately display a message informing them that the code is invalid and prevent the form from being submitted.
What have I managed to achieve so far? After wrestling with Omni, I've managed to get the code validation working in Interfaces, but not in Forms. I specifically need it to work in Forms.
I've tried prompting Omni to build the form in Forms with this validation, but it never performs any real-time validation. I don't know whether my prompt is wrong, whether this simply isn't supported, or whether Omni is just ignoring that part of the request. It always tells me it has implemented it, but in reality nothing happens.
I think @Mike_AutomaticN mentioned something along these lines in a post a while back, but I only skimmed it at the time and now I can't find it. I seem to remember it being a very similar use case.
If anyone has any experience with this, I'd really appreciate any pointers or information.
P.S. I know. I know. I could do this with Fillout (or similar tools), but I'd rather not introduce another platform into the mix if I can avoid it.
