Air table stock full#
Air table stock free#

This will then trigger a simple, native Airtable automation that creates the Google Calendar event for the wedding couple. For example, thanks to the script below we can, by clicking on the “Ready for Booking” button connected to the specific wedding, flag all the connected events with the “Book in Calendly” check. Scripting can be an important asset that allows us to perform such automations. When a wedding is ready, it is useful to create the relevant google calendar invites for its events so that the timeslots are booked for the wedding couples, and we make sure that they are notified about their appointments. This is a very good system if you love to have things colour coded and do not have many records in your base (with several records, the ones flagged in red can easily get lost among the others and an ad-hoc view may be preferrable). This is very visually appealing as at any point in time you can just go to this view and check which products should be replenished and by how much COLOR CODINGĪ second approach is to create a colour coding system so that all products with a value in the Missing column higher than 0 are flagged in red. The first way to keep track of the products that have dropped under the treshold is to have an ad-hoc view which is filtered to show only the products that have the missing column showing a value higher than 0. If the treshold for a product is 50 but you currently only have 10, then the Missing column should say 40

Missing: the amount of the product that you are missing to reach the treshold.

Treshold: the minimum quantity you want to have for that specific product.Quantity on Hand: showing the actual quantity in the inventory for the product.AIRTABLE SETUPĪ good initial approach is setting up the Airtable fields to track for the low inventory quantity. This is very useful to be sure that inventory is replenished in a timely manner. RecordsToUpdate = recordsToUpdate.When working with an inventory base, it is important to track when the quantity of a certain product falls below a certain threshold. const table = base.getTable('Stock Quotes') Ĭonst result = await lectRecordsAsync() Ĭonst stockSymbol = record.getCellValue('Symbol')Ĭonst request = await fetch(baseUrl+stockSymbol+'?apikey='+apiKey) If you go for the paid version, you can combine multiple stock symbols in one request /quote/AAPL,META,GOOG etc.

Air table stock free#

The scripting block in extensions, will not work due to CORS with this API.īelow script works with the free version of FMP, so it needs to request stock symbols one by one.

If would prefer to use the code, you can use a scheduled automation to run a script e.g. Apart from the price tickers, they also offer access to SEC filing data, so could be quite a good way to source quickly bunch of annual report figures if you are looking at fundamentals.įor the no-code version with Make you can checkout my video below: They have a very decent free plan, so you can test out if it works for you.

Air table stock full#

I have built an integration using and (their full API docs here Free Stock Market API and Financial Statements API - FMP API).

Ve a working integration, where stock prices are automatically (eg timebased refresh) fetched into an airtable sheet, depe