Once again it appears airtable haven't realised that maybe it's useful if dates and times can actually be used in reporting - from what I can see when using a list record source in a send email automation step there is no way to get dates and times t...
HelloI am putting together an automation which will email our staff their rota, I would like to do this from a view in the base, rather than an interface as I am yet to find interfaces particularly usefulI don't see any way to do this - unless I do s...
Hello
I have a base structure of:
EVENT → VENUE SLOTS → STAFF ALLOCATIONS
Whee an event can have a number of venue slots (ie each day’s activity) and each slot has a number of staff allocated to it
I would like to be able to produce a report which sh...
Hello
I think there is a bug with how duplicating records works:
I have a two tables linked together as many:1 - let’s say an “staff” table and a “role” record - where each staff member can only have one role, but the role can have many staff member...
Hello
I like Interface Designer but a particular problem for me is that it appears I can’t add a field from a linked (to single record) table without first creating a new linked field. This means that my table gets massively overloaded with unnecessa...
It is crazy how airtable does some basic things so terribly. I think there is a way to solve this with a formula field which looks up the data - or with the script I noted above. But it’s pretty terrible
You would think that would work but sadly not - the automation section seems to ignore time zones, and also won't display the result of calculated date-time fields (they just appear blank or garbled). Very frustrating!
Ah thanks - and I assume this gives you the record that was selected as input to the script? I did a fix which uses a webhook (and I pass some data in the body) but your suggestion seems better!
Thanks - it's just madness how airtable don't seem to get the importance of being able to use dates/times reliably. I have worked out a dirty solution that works - I take the HTML generated by the grid view and edit it with a script action to update ...
