Other Questions

I have a restaurant tracker that enables me, my wife and my 2 boys to each give it a rating using 1-5 stars. Is there any way to have a field that averages these stars?

I’m trying to create a script in Airtable linked to a button. The process is as follows: Button within Airtable pressed If the checkbox field ‘switch’ is false, then turn it to true Wait for 2 seconds, reset the field to false This is the script I’ve written using the setTimeout() function: let table = base.getTable("EXM"); //The name of the table you're in here let record = await input.recordAsync('Pick a record', table); if (record) { if (record.getCellValue("switch")===false) { table.updateRecordAsync(record, {'switch': true}); output.text('checkbox ticked'); } const myTimeout = setTimeout(timeDelay, 2000); function timeDelay() table.updateRecordAsync(record, {'switch': false}); output.text('2 second interval'); } When I write the code I get an error that says “cannot find name setTimeout”. As a solution, it suggests “add missing function declaration ‘setTimeout’” How do I declare this function so it can function with my code?

I’m having trouble with something that seems very simple. I’d like where it says “0.9 available” for it to show that time formatted as “h:mm”, as it does in the “Time Available” field next to it. Here the formula for the Name field: Essentially I think I need to convert seconds to hours, minutes and seconds within a formula, but I can’t find a way to do it and feel I’m probably just missing something simple. Thanks so much.

Hi! I am trying to add internal links on my blog that I am managing via Airtable used as a backend CRM. I fetch the blog posts via Airtable API but Airtable always prefixes “http” on internal links, so “/about” becomes http:///about. It’s really puzzling that this is not natively supported and there’s no workaround it seems like such a common use case! I’ve also tried a normal Markdown syntax but, as the docs say, hyperlinks Markdown is not supported in Rich Text Fields (??!!!). Does anyone have any workarounds?

Hello, I was wondering if anyone has ever made a bundles. I want to take about 10 different Items with 10 of each and have it still subtract out of my inventory. I would like to have it work as following: if we use 15 of the bundles it would subtract out 15 X10 of each. This is for Simulation training so we have 6 different Cohorts that will be using the same bundles. What I have will work I just have to enter every Item for each time I use it. Hopefully one of you can help? Thanks

Hi Community, please could you advise me how to filter view by latest date dynamically? I would love to use in filters something like: max(last modified date () ) Thank you, Standa

Hi, I’m using Airtable as my agency CRM. Before Airtable I was using Hubspot. A feature that Hubspot has and that we loved was the information when the client seen our quote. We could know at which time and which day the client opened the quote. Can I make this with Airtable ? Thanks in advance,

I currently have two date fields, start and end. How do I create a relationship between two rows, e.g. Have the start date of Task B be days before Task A end date?

Hi folks, My apologies if this has already been explained. I couldn’t find a way to add an input to a field. I would like to enter any decimal value on the interface and then go through the calculation process. Thank you :slightly_smiling_face:

I manually entered numbers in a Single Line field, then I changed the field type to Number, and the last two digits of the numbers changed before my eyes for no apparent reason. The change is in the last two digits (14 changed to 20, and 05 changed to 00). Note that I didn’t make a typo - I watched the digits change when I changed the field type to number. I tried making a new number field and copy pasted the values in there, but the same thing happened there. I tried the same with a formula field with the same results. It’s not a rounding error - the number field format is set to integer, and so is the formula field. The screenshot SHOULD show the same number in every field - the “Group ID” field has the correct number. Is there a ghost in the machine?

Hi, I could use some advice on the following use case. One base, four tables: Products Orders Order Line Items Out of Stock Products Orders are linked to its Order Line Items, and each Order Line Item record is linked to 1 Product record from the Products table. Additional lookup data of the Product record is gathered in both the Orders and the Order Line Items table. Now here is the main issue: Product records are automatically (via scripting) moved to the Out of Stock Products table once they hit a quantity of 0 (and let’s assume we manually adjust the quantity of these product records). Once a product record is moved though, the link between the Product record and Order Line Item record is removed, causing all the additional lookup and summed up data of my final Order data to be flawed. Somehow, I need to retain that product data in the order. I’m looking for any type of suggestion to deal with this use case to retain the product data in the orders. Could be going anywhere – from

Is it possible to retrieve the possible options within a column’s “Single Select”? Without having a record for each option listed? I have one column with 5 possibilities (right now), and want to retrieve those possible values so I can dynamically build a select box on the front end of my application. I want to be able to change those options in Airtable (add or remove) without having to touch my application. The select box will allow me to create a new record in the table with only the values I’ll allow the table to accept. I’m using only jQuery to interface with the Airtable API, and have been doing well with it (I know it’s not the most secure but it works!)

Hello and thank you for taking the time to help me out! I have two event tables. One for private events and one for community events. Both of these Tables have a Calendar view. I would love to combine these two Calenders into one so that the team can keep track of everything and ensure no overlap. Does anyone know a good and simple way to do this? Cheers! Chris

Hey all, I have a digital display where I’ve embedded a shared grid view. I would like to scale up / zoom in on the embedded view to increase reability. The simple CSS solutions I’ve tried haven’t panned out. Does anyone have a recommendation or proven method for scaling up an embedded view? Thanks, Ray

Hi all, trying to build a table for instrument rentals at my workspace. I posted about this elsewhere thinking my answer lied with automations and formulas but maybe calendar view is my answer? We basically rent instruments to students like a library would a book. I want students to be able to submit a form requesting an instrument, they select a request date and I have a formula that calculates the due date as 14 days past that. I would like instruments to be marked unavailable when requested, this needs to function in relation to the current date (ie, instrument requested for Sept 15-29, today is the 20th, so it should show unavailable) as well as to a future date (don’t want students to double book an instrument say, for October 15th). Would calendar interact with a form in such way and allow me to do such a thing?

Hello, i have an address field in my base and i am looking to create some filters to categorise items by country, in some addresses i can see the name of the country at the end but others not, here some examples : Greater Milan Metropolitan Area Warsaw, Mazowieckie, Poland Paris, Île-de-France, France Künzelsau, Baden-Württemberg, Germany Stockholm, Stockholm County, Sweden Geneva, Geneva, Switzerland Vienna, Vienna, Austria Greater Milan Metropolitan Area Newcastle, Northern Ireland, United Kingdom Ottawa, ON Calgary, AB Seems to be not possible by default in AT even with the map extension.

I was wondering if there’s any script that allow me to check/ uncheck the box? I can only do one but I want to make a toggle checkbox. This is the script for check only let table = base.getTable("Product List"); let record = await input.recordAsync("Interest", table); let recordId = record.id; await table.updateRecordAsync(recordId, { "Interest" : true, })

Hi! My name is Dúnnia. I’m from Brazil, and I’m using AirTable for about a year. But now we are having some problems with the forms. It seems the corrector changes our text and turns in something not understandable in Portuguese. I need help çause clients are asking for money back. I’m waiting for your response.

I have a question very similar to the one posted in How can I add percentages to airtable dashboards?. I have a table with 50 rows (per company), each of which has a projectComplete Y or N. In my interface I have 2 numbers elements that count the total number of Ys and Ns. Let’s say those numbers are 10 Ys and 40 Ns. I’m trying to figure out how exactly to produce a number or chart that will tell me that the overall Y completion percentage is 20%. Surely there must be a way to do this in the interface screen without some hack that adds a new column to your dataset? Even if the only answer is a hack I can’t really see how I could construct that in my dataset. Thanks for any thoughts!

Hi, I’ve created custom extension, but my custom extension can’t automatically run and can’t run in background when my base opened, is there any way to make my custom extension can autorun and run in background ? Thanks

I would like to normalize my base data model a bit and separate out parts of logic into their own bases - everything about People in the People base, Projects in the project base, and so on. I am just learning about setting up synched tables and had a question on security. Leaving the data out there with simply a unique URL - but otherwise open - is really a non-starter. I saw where I could set a password on the synch share link, but then the synch stops, rendering the feature useless. Am I missing something? Is there some way to secure the synch between the source & destination?

Hi Community, is it possible to upload binary data to an Airtable Long text or other field? I need to save the data & use it later. I don’t need to save an image or attachment, just the binary data. Thanks

Hi folks, I’m trying to create a matching system based on goals/objectives so i’ll automatically send introductions for those who are matching so they can grab a coffee IRL. These coffee meetings are 1-1s. I’m not sure if I should use script(s) and/or formula(s) and/or a rating field and/or a scoring. I’m far from being an Airtable expert. I’d really like to create something simple as it’s a very early-stage MVP. Complexity will be needed later on, but not now.

Hi brains trust! Need some guidance here as what I think should be simple is proving not-so. I’m trying to track gifts given over time and those that are recurring annually. I have created a column for OCCASION (single select from a list of pre-determined occasions to track), a column for OCCASION DATE (manual input) and would like to add a third column (RECURRING OCCASION) for those occasions that have static and annually reoccurring dates - i.e. Christmas. Would like to include Easter, Father’s Day, Mother’s Day in this column too - returning a date for the 1st day of the month in which they fall (not too worried about specifics here as dates change annually and figuring out a formula for that would fry my poor neurons). The idea being that any event recurring annually I would simply have to select from the OCCASION column and the RECURRING OCCASION column would auto-populate with the specific date. I would then create a view to show each year’s budget by month, inclusive of all even

Hi, I have issues opening a record by scanning the url of the record. When I scan the QR code (generated from a record URL) the airtable app opens but doesn’t load the page (or it takes a long time). If i just go to the airtable mobile application and I click on the record, it immeadately opens the record. I only have 4 tables in my base, each with 10 records Link is: Sign in - Airtable Can someone help me with this? Am I doing something wrong? I’m new with airtable. Greetings, Corneel