In my use case, I’m using the choice component to select my existing customer. If it’s a new customer , I’d have to add their record in the database tab first before adding their order in the sales tab. It’d be nice if we don’t have to go back and forth between tabs to add new record.
It looks like you can add a form inside a form - I just slapped this together to try it. I haven’t really played with it, but I did notice if you open the form IN the form, you lose everything you entered earlier. You have to completed the internal form, then complete the first form.
I’d likely use the choice at the top to check for existing customers - if I didn’t find one, add them using the form button, then finish filling it in.
You could always add a text entry above the choice component and point it to the same column. If an option is not in the choice component, then the user can manually type it in. After the form is submitted, then the new entry can become part of your choices for the next time.
Thanks a lot for the ideas. Both are brilliant! I’ll probably use @Jeff_Hager’s solution and add a radio button to toggle the visibility as it is more straightforward Thanks again guys!