The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.
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 ...