Hi everyone!I am trying to have an automated Slack message sent every Friday to notify about the leaves planned for the coming week.However, my current automation (trigger: at scheduled time + action: find record + Slack: send a message) uses the Lis...
Hello!Let me first paint the picture of what I am working with:1 base, 4 tabs: "留♀️People", "️ Absence Management", "️ Leave types" and " Public holidays"Relevant columns:In "留♀️People" one column has the staff "Name" and the other column has a ...
Hi there!I have been trying to get an automation to look at a view in Airtable and list up all the records with their hyperlink in a Slack message every Wednesday.The outcome would be something like:´Here's a few entries you can pick from:SW-0001 (hy...
Hi there!I am trying to create a formula that looks at an entry (single select) and if that entry is = A, B or C say "Blabla" and if it says anything else say "Haha".I have hence tried to nest OR() into IF() as followed:IF(entry=OR("A", "B","C"), "Bl...
Hi Airtable team, I currently use an automation linked to a single select "status" change to manage communication with candidates that have applied for a role at our company.Eg. if I change the status to "dismissed", it triggers the automation to sen...
Hi @ScottWorld !Thanks for your reply. The leave is linked to a staff record which itself is linked to a team record. So I imagine this connection may make it impossible to rollup/lookup team leave directly?Also, I only want to show the leave from th...
Hi !The automation setup is in the attachement called automation 1. Or do you mean something else?I have replaced my code with yours and I get the same code run result than with mine so yours definitely looks less complex to reproduce in the future -...
Hi @kuovonne !Assuming this collaborator is tagged in space "A" in the workplace "ABCDE", as I remove them from the workplace and re-add them to space "A", will all the field they were initially tagged in re-appear as if nothing happened?
