I have an interface that has been made to show lists of all of the Purchase Orders, Purchase Order Items, and Invoices from clients. (Purchase Orders is a table, Purchase Order Items is a table, and Invoices is a table. Each of these tables uses the ...
My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples: Site A's publication will be taken down on May 31, and the new ...
Longtime Airtable user, but limited experience with Interfaces.My regular workflow has three browser windows open at once:Window 1: Shows the fields of one record from Table AWindow 2: Shows a filtered view of the records in Table BWindow 3: Shows a ...
We have a database of thousands of products. Hundreds of them go on sale each month - and Airtable shows my designers what the % off or $ off is for each product.The challenge is that a product may have a different sale price from month to month, and...
I’m a total newbie to JavaScript, and pretty proud of myself that I’ve figured out how to connect to my company’s API to get store information.
console.log(await storeInfo.json());
is displaying all of the JSON returned from the API call, but now how...
@Olli76 ,I had to do something very similar recently. Rather than using automations, I did it by simply linking the previous record in the same table. Simplified version for your situation:
@TRBS ,Week numbering is tricky, because Airtable's WEEKNUM() doesn't follow ISO week date system standards.Airtable will always count the week containing January 1 as Week 1, regardless of how many days from the new year it includes.But the ISO stan...
@Danteaway ,There are pros and cons to the Airtable automation approach. The pros include low cost, a familiar workflow, and simplicity of implementation. (If you go this route, be sure to edit the ReplyTo field—this is hidden under "show more option...
Hi @Everrett_Thom ,That is completely doable! However, it really depends on what each base is using the data for. For example, let's say your master base is Client Info. The partner bases would each have a Client Info table that is synced to the Clie...
Nope, fortunately no automations! Everything else happens by itself, as the Approvers table is linked to the Things table. So, any Approver that gets added to a Thing's record will automatically get that thing (and consequently, their Thing Count) sh...
