Hi Gliders
I was wondering how do you handle scenarios like this as far as design and structure goes:
For a CRM, I have a table for contacts, another for phone numbers and another for emails.
I would like the user to be able to add a contact via a form, and while adding the contact, be able to add multiple phone numbers or email addresses.
Easiest way is to add the contact first, and then add phone numbers or emails but I find this approach a bit clunky.
I thought about having a form inside the contact form and setting up a helper table to temporarily log the phone numbers and emails and then add these via a a workflow or api call when submitted. But then I would need a recurring workflow like once a month that goes trough the helper table to check and delete unprocessed rows that were abandoned if a user stopped filling the form before submitting it.
I also thought about trying an AI component that could create a temporary json with an array of phone numbers or emails and then process that JSON via a workflow to add these numbers to the created contact.
What are your workarounds for this type of situation?