I’d like a form that allows my user to choose from a list of contacts which is stored in my contacts table, but if they do not find a current contact allow them to add a new record.
I tried using the AI component and I could get it to present the way I want, and it looks exactly as I expect, but I cannot get it to pull the current list of contacts, it just places random names in that space. This is connected to the table Contacts.
It does not have to be embedding in the list, but the way the AI returned it (obviously with the wrong list) is perfectly how I’d do it in a third party form so it’s a nice comfortable way to do it. Just wish it could find my list easily!
Is this the right code? I’m getting an output about license plates, not fed ex or shipping related something.
Truthfully about to lose my brain over not being able to figure out something that is so completely simple in even JotForms. Look at a list, select from list and use the field to connect the relation, but if the relation doesn’t exist open a form to add it. Why is this so hard for me? I’ve watched too many videos and read too many vague posts to figure it out so I’m just to the point of confusion now.
If you look at @ThinhDinh’s code, it’s specifically for license plates, but it’s the same concept. You can either adjust the code for your use or just ask the AI to change what you want to be different.
I’m only getting a list separated by commas when I use this code. I’m not super familiar with using code for this type of thing and that’s obviously a limitation to my skillset. I pasted the code exactly as ThinhDinh posted and then I changed the fields, not names. I still only get a comma separated list from the joined list I created.
That’s a good observation. I did try to follow your video on building a beastly choice component in my form a couple of days ago, I could get the component to build and look how I wanted it to look, but I could not get it to accept any data or populate any of my tables. I gave up on it, but the use case I have seems to be something many businesses need. One location with multiple and possibly changing contacts - in my case, its often GM’s who are moving around to different restaurants or stores.