This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello! So I've started to use the Interface feature of Airtable. It works quite well for me and my team. Now I'm at the point where I want to deny access to the views that the Interfaces are built upon. How can I do this? And is it possible to only r...
I've created an Automation that should help me automatically update Records in another table when x happens. So I have two tables: One table with a whole bunch of records (new ones will appear every week) and then I have a table where some of these r...
Can someone help me modifying this formula so that if the condition 'Trækdato (FarPay)' field is empty, the formula field is left blank? Right now it returns an #ERROR! IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Trækdato (...
I've a table that generates records through the Airtable built-in form. Each record comes with an ID from an external software. The ID is connected to accounts in this external software, so account 1 could have ID: 123, account 2 could have ID: 1234....
Hello, @TheTimeSavingCo Thanks for your reply. Yea, I figured that out, but the thing is that my colleagues are already part of the "team" in Airtable and therefore have access to all bases. As far as I understand what you are referring to only works...
Thanks, @Alexey_Gusev !Maybe you have time to help me with another one? I have this formula:IF(
AND(
{Betalingsmetode} = 'PBS',
Status = 'Confirmed',
WEEKDAY({Tilføjet d.}) = 3,
{Type refundering} = 'Dobbeltbetaling'
),
DATEADD(...
Hi MLOThanks a lot for your reply. I've tried to create the Automation now, but for some reason it also sends me an email when there is no duplicate to be found. My Automation looks like this (see picture). The trigger is 'When a form is submitted' 1...
I've tried this, but it won't accept it:IF(AND({Trækdato (FarPay)}, {Dato for udløb}, MONTH({Trækdato (FarPay)})=MONTH({Dato for udløb})),
IF(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10 && DATETIME_FORMAT({Dato for udløb}, "D")<10,
IF(W...
