Hello,I want to compare the values of a Rollup field with a Linked Record field.Field A is a rollup that contains the following text:"Value 1, Value 2"Field B is a Linked Record that contains the following records:Value 1 Value 2I want a formula that...
I have built an automation that will:
Step 1: Trigger when a record is created in Table A
Step 2: Find matching records based on a condition in Table B
Step 3: Update a linked field on all matching records from Step 2 with the ID of the new...
Lets say hypothetically that I have 40 separate Linked Record Fields (Field 1, 2, 3 etc) that make the same connection between Table A and Table B.
For each row only one of these fields will be updated. I want to therefore create a master f...
I have a rollup field - Field A - which displays items in an array using a comma separator. I retrieve the items using ARRAYUNIQUE(values).
When I try and call this field in another field - Field B, this formula keeps the comma separator:
Let’s say I have a formula field - Field A - that produces a decimal value (e.g., 0.5).
I use the formatting option within the formula field to display this value as a percentage.
However when I call that field in another formula - Field B ...
I prefer the current format. It’s all a little cleaner.
However, I’m not moving between bases - we keep everything all in one, so for my use case, I feel the current format is nicer :slightly_smiling_face:
This would be really useful. It seems to be a feature with the Chart App in the “Main” Airtable.
Is there any chance this feature could be expanded to cover the Chart App in Interfaces as well?
Otherwise there is no suitable alternative to properly d...
Thanks guys. I think I’ve worked out the problem.
It seems the script is triggering too quickly. It is set to trigger when a new record is created, but sometimes a user might create a record and then spent 5-10 seconds filling out the fields that thi...
I’ve opted for Scott’s approach as I still need to be able to count items in the array.
I didn’t realise we could use ARRAYJOIN outside of a Rollup field. The documentation seems a little unclear: https://support.airtable.com/hc/en-us/ar...