Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 12, 2024 05:58 AM
Hi,
I'm very new to Airtable, but I couldn't find a solution for my issue. Maybe there is one that would make my life so much sweeter :))
Let's say we have a product and this product has 2 options: Machine 1 or 2
which machine to choose depends on another single select field in another record, with options 1 or 2.
now want to use an automation if 1 is 1 create new record with 1.
but somehow string arrays can't be accessed in automations. I'm trying to solve everything no-code, maybe thats the issue.
thank you so much for your help.
Kind regards
Sep 12, 2024 06:15 AM
Could you provide screenshots of your tables, automation setup, and an example of you want the automation to create please?
Sep 16, 2024 12:10 AM - edited Sep 16, 2024 12:10 AM
Hi,
thank for your reply.
Yes, please see below. At the moment I do a workaround by using a formula that converts the single select output to a string in each table and compares these in the automation, my goal would be to compare the single select field directly.
Rather than changing the 1. single select to so it would plaine numbers, we would prefer to be able to extract info from the single select field like here where the options are "1HKL" in the "product" table / "specifier I" column should be matched with "1" in the "detailed planning" table / "ZZ:Anzahl XYZ" column.
Sep 16, 2024 01:52 AM
Thanks for the details! Perhaps you could replace "Cube NR" with a formula field that extracts the first letter from the single select field? Could you provide a screenshot of how you're using those fields in the automation as well? So sorry, I don't really understand what we're trying to do
Sep 16, 2024 06:05 AM
yes so thats basically what im doing, "Cube NR" & "Anzahl Heizkreise" do convert the single select fields to strings via formula field. Im looking for a way to extract data from that field without using an extra formula field, like a way to treat the single select field as a string. (maybe not possible)
Sep 18, 2024 03:20 AM
Ahhh, I see! I don't think that's possible at this point I'm afraid