I am creating a base to keep track of a collection for insurance purposes. I have the list of items in one table and then I have a checklist of what I need for each item in another table all in the same base. I want to copy the items that are in the ...
I have a situation where I need to display the linked records in a field like this (including the double “” on either end):
[““recFMVIujI5jqSiSD””,““recf8rGUjcM0li5f4"”,”“recztuGU7Tl4GSSYU”"]
Is this possible?
I have this code to format it, I just ne...
Is there a way to format the items in the rollup field to look like this (including brackets on either side):
[“Choice1”,“Choice2”,“Choice3”,“Choice4”,“Choice5”]
I have this formula but it does not work in a rollup field:
'["' &
SUBSTITUTE(
Choi...
I have a multi-select field that has a large number of choices. I have decided it would be better to separate them into different categories (fields). Is there a way to do this?
I have a master list of choices in a separate table (if that helps). The...
So I have a multi-select field that has about 50 or so options. I want to take those options and surround them with quotation marks, separated by a comma. I tried using the SUBSTITUTE, but I couldn’t get it to work the way I wanted without duplicatin...
I actually can’t get it to work. I have “create record”, which it definitely does…but a blank one. I guess Airtable just creates the record immediately without waiting for the information to be input.
So I tried adding an “update record” too, but I a...
Because you can’t add them automatically, can you? If I create a record in the main table, I want it to also add that record name to the checklist table.