Ron_Daniel - profile

Ron_Daniel · Jan 05, 2023

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...

Ron_Daniel · Feb 05, 2022

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...

Ron_Daniel · Nov 05, 2021

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...

Ron_Daniel · Sep 21, 2021

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...

Ron_Daniel · Jan 27, 2023

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:

Ron_Daniel · Jan 27, 2023

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_...

Ron_Daniel · Jan 27, 2023

The formula for the "Actual Company Name" field isREGEX_REPLACE({Listed Company Name},"[0-9](. )|[0-9](.)","")

Ron_Daniel · Jan 25, 2023

Sorry, forgot to include the link!https://community.airtable.com/t5/other-questions/lookup-to-show-latest-entry/td-p/106261

Ron_Daniel · Jan 25, 2023

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).

User Statistics

User Activity

Selecting from multiple sale prices to show product discount

How to get info out of the JSON that an API delivered

Can Airtable hit our API to keep data current?

Planning multiple trips with people and rooms

Re: Quick and very dumb question about using date fields

Re: Formula field to split text into 3 ways

Re: Delete first matching characters in a column

Re: How to show most recent entry in group of numbers

Re: How to show most recent entry in group of numbers