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...
You may want to do your initial setup in a grid view, because it will help you understand what the fields are doing.Imagine Airtable like a big spreadsheet, and the fields are your columns. The field name is basically your column header. Example:
I'd like to be able to give you a complete answer, but for some reason Airtable doesn't like the regular expression I'm writing for "State". Hopefully someone can add to the conversation to help us figure that part out.The formula for "City" isREGEX_...
I believe @W_Vann_Hall 's answer in this thread might be a good building block (though you'd still need to figure out the final step of it working for each serial number).