Hi,
With the addition of automations in Airtable, I was wondering if it was possible to automatically click on a button each 1st of the month? I’ve seen the triggers “new record in view”, but not scheduled ones (for example: every day, every month, 1...
Hi everyone,
I have some set of records that need to be duplicated. At my surprise, there’s no option to “Duplicate” when more than two records are selected.
I cannot duplicate by hand because the base is quite heavy, there’s too many records to dupl...
Hi everyone,
I have a base where I have a list of invoices which have a date an an amount. I need to know the average earnings for each working day of the month the invoice is billed.
To do so, I wanted to calculate the number of working days for eac...
Hi everyone,
I have an Airtable base with 17 collaborators.
2 of them are admins that check if everything is good on the base, update records, etc., and the rest of them put each day their working time through airtable forms. These times automaticall...
Thank you for your answer.
To make it simpler there’s three tables: the clients, one for events, which compose an invoice.
The invoices are generated at the end of the month based on the events. The events (which can be hours worked for example) are ...
Thank you both for answering.
@kuovonne the formulas you gave solved my problem. I was indeed looking for date fields and not strings since I need to use them for stats after.
I feel like I’m digging up an old topic but I totally agree with that.
I have 17 members in my Airtable base, they all put their working time through forms and those times generate an invoice at the end of the month. They should be able to edit their...
