needs some help to work out a probably common challenge for noobs like me.
Create a form view to add a product where user can add multiple tags. Both tables need to be updated upon submission, and it’s fields linked.
Show in the form a multiselect showing existing tags and allow to create new ones, upon submission new ones will be added to Tags table linked to the corresponding Product.
Is it possible to create something like this?
Thank you all
Hey Carlos, if I were you I would:
Producttable and have the field from point 1 be in the form
Productlinked to the
Tagsrecords the user selected
Producttable called “New Tags” or something, and have that included in the form. In the form, tell users that they can key in comma separated tags into this field and they’ll be created and attached to this product
New Tagsfield is not empty, and make its action to add the values of the
New Tagsfield to the current values of the linked field
This should accomplish everything you’ve outlined above I think
Actually struggling with the automation to:
When New Tags not empty
The automation seems to be a bit limited on what you can do, other than basic modifers (capitalize, trim…) I guess you can’t do everything within just one automation.
It probably needs a bit more of work, the only solution I can think of seems quite cumbersome:
Is there a short cut or more elegant way to solve this?
I’m on the free tier btw, maybe that’s the problem
Your advanced needs to go down the prefilled / portal / user interface / advanced on2air forms route)
For tour basic case an idea of data structure would help
Is the relationship between tags and products a many to many relationship (ie product 1 and 2 could have Tag 1 and Product 1 could also have tag 2) or is it a case where a tag needs to have a specific product (called a master detail relationship) …
Are “tags” predefined (ie you have a list already) or are they created new for each product
Same question for products
Do you have a maximum number of tags per product or per submission in mind …
With the answer to these there may well be far simpler solutions to what you are looking to do
If not possible, I’ll just give up and try to live without them. Way too many subscriptions already…
If you have budget then I think On2air forms may be where your best solution is
Otherwise it feels like you want to create a third table - a junction table (often thought of as a detail or line items) which is a combination of products and tags - let’s call this ProductTags
1: put the form in products & create 3 text fields one for each tag
2: in the producttags table create 2 linked record fields - one for tags and one for products
3: then create an automation with three conditional actions as follows
The trigger form submission
Action 1 conditional on the tag 1 field being not empty to be
Create new record in recordtags with the product name in the product linked record field and the tag name in the tag linked record field. (This will then link to existing or create new tags as appropriate)
Then you have your products linked to your tags via your producttags table
Action 2 and 3 (and more) are replicas for the other fields
Then you can use lookup fields via the junction table to show the relationships you want …
Hope that helps …