Me again, still working on same database as Going mad trying to avoid duplicates with ARRAYUNIQUE.
I’m trying to create a field that shows a date-ordered list of unique dates on which the items on the table are listed in a linked table.
The rollup (o...
Hi all, please help put me out of my misery.
I have a database to organise film shoots.
I have three tables: scenes, dates and kit
Each entry in the scenes table links to an entry in the dates table (the date we’ll shoot that scene), and may or may n...
Incredibly new to scripting here but trying out your fabulous work… I’m getting the error:
TypeError: output.markdown is not a function
at main on line 151
Do you have a sec to point me where I might be going wrong?
EDIT: Okay I changed output.markdo...
Yeah I was trying all sorts of nested ARRAYUNIQUE(ARRAYFLATTEN(values)) etc etc to no effect. There’s a lot that’s rather elegant about Airtable but occasionally around the edges a little fraying is apparent - this is perhaps one of those.
Somewhat r...
W_Vann_Hall:
Filmshoot Demo
Thank you SO much! It would have taken me many hours more fiddling to even think of creating a “sorting out the data” field in the SCENES table, I was trying endless combinations of formula fields in the shoot dates...
