Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 28, 2022 03:17 AM
Hi everyone,
needs some help to work out a probably common challenge for noobs like me.
Base setup
Challenges
Basic:
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.
Advanced:
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
Jul 28, 2022 04:30 AM
Hey Carlos, if I were you I would:
Product
and Tags
tableProduct
table and have the field from point 1 be in the form
Product
linked to the Tags
records the user selectedProduct
table 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 productNew Tags
field is not empty, and make its action to add the values of the New Tags
field to the current values of the linked fieldThis should accomplish everything you’ve outlined above I think
Jul 28, 2022 05:42 AM
wattt? man you’re good, thanks a lot :tada:
Jul 28, 2022 07:58 AM
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
Jul 28, 2022 10:08 AM
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
Jul 28, 2022 10:44 AM
thanks @Russell_Findlay,
If not possible, I’ll just give up and try to live without them. Way too many subscriptions already…
Jul 28, 2022 11:22 AM
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
Then
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 …
Jul 28, 2022 12:56 PM
It does, I’ll give it a try and let you know, thanks a lot.
Sep 10, 2022 03:40 PM
Another way to achieve this is by using a 3rd party extension. Our Advanced Form for Airtable allows you to create new linked records on different tables.