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.
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...
I have built a database in Airtable that is unfortunately just a static import from my company’s database.
However, we do have an API that can grab full files or deltas (in JSON). Can Airtable access it to stay current? If so, where should I be looki...
I am trying to plan various combinations of trips, people, and room assignments.
For the sake of simplicity, let’s say there are:
25 trips this year
10 two-person rooms available for each trip.
300 people who may go on these trips. Many will go on mo...
A couple of recommendations:- If you don't need times, I'd un-check "Include time" in the date columns.- If there is a "Week" field (whether linked from another table or not), then you can group by week without having to add tasks:Questions:- What if...
@Darcie_Tanner1 you may be able to do this using the Duration field. They would have to enter in hours and minutes, not as a decimal. In other words, an hour and a half they would enter as 1:30, not 1.5. These are easy to roll up in totals as well:
The regular expression to grab the "REQ-" with 1-5 numbers after it would beREQ-\\d{1,5}However, I'm at a loss for how to get Airtable to get more than the first instance of it.In this table, the formula for "Only the REQs" isREGEX_EXTRACT({Text Fiel...
@Nathan_Ramey thanks for clarifying! In that case, you just need this formula:DATETIME_FORMAT(Date, "DD")or, if you don't want the leading zero on single-digit days, thenDATETIME_FORMAT(Date, "D")
