Other Questions

Hi all! I have read this great post but I have a further question about sync....there is a precise synchronization time following the "Source Base" update?My process is this:- When the event occurs I send a webhook via Make- The webhook triggers an automation inside the Source Base on Airtable (this automation looks up the last created record and updates a field by setting a checked field)The problem is the time between this update on the "Source Base" and the synchronization on the "Sync Base"I realized that up to 9 minutes pass and for this I had to insert 2 "Sleep" modules set to 300 seconds (screenshot attached) each on Make before looking for the new (synchronized) record on the "Sync Base".Can you confirm that the process described is correct? I had read that the ""Sync Base" synchronization takes place within 5 minutes following the "Source Base" update.Thank you very much all for your help! 🙂

We are in the process of transitioning some of our different bases to use synced tables coming from a sort of ‘Single Source of Truth’ base. Now, some of these tables that we would like to make synced to the base have numerous linked records, lookups, rollups, as well as scripts and automations that impact them. From what I have discovered so far, there is no way to sync an already existing table containing the same information to our new source base. Is this correct? Essentially, to properly transition to the synced table, I will need to recreate all of the items that are not synced? I want to make sure this is the case before I jump into transitioning some of these bases, only to find out there was an easier workaround all along. Thanks for all the help!

Hello all, Looking to modify this script to see if it can recognize multiple template types linked to a parent record and run/create the necessary tasks in the child table. For instance, if I have a checklist and want to generate tasks based on Variable A and Variable B, I'd like to make sure tasks are included for both variables. It seems right now, the script is only set to recognize the tasks from Variable A and ignores Variable B. 

Hi there, I have a Projects table and a Tasks table, as laid out in the Project Management demos from AirTable. When a Project is completed, we check the “Complete” checkbox and that moves it from the Upcoming Projects view to the Past Projects view (which are simply the same tables, but with a filter based on the Complete checkbox). However, when a project is completed, I’d like for all the linked tasks in the Tasks table to be deleted. Not moved to another place, but actually deleted. Is there a way to automate this? Nickie

Hi all, it's my first time using no-code tools and I am trying to add airtable as a database tool to collect sign-up information as well as customer queries and any other related data. Where do I start? 😁

Dear airtable community,I want to send out a form where someone can fill in some information. But I really want an option where a table could be filled in. Currently, if you make a form from the existing spreadsheet, you need to fill in the form 4 times to fill in all the questions. Therefore I want to integrate a table, where someone could fill in the table (in this example consisting of 4 locations with questions) and only have to submit the form once.It would be really helpful if anyone knows a solution 🙂  

I have a Date/Time field that feeds into a formula field to pull the date from it. It used to work perfectly well, now that I have added the time option to it as well though there is an issue with it sorted dates wrong. As an example I have a task that is listed with the date 1/19/2021 7:00pm but when I put it into the formula it reads it as 01/20/2021. If I change the time to 1/19/2021 7:00am it reads it as 01/19/2021. It does read the Date/Time correctly in Calendar view. Is there anything I can do to ensure it reads the Date/Time field correctly for the formula? It is important for grouping reasons. The formula I am currently using is: IF({Due On}=BLANK(), “N/A”, DATETIME_FORMAT({Due On}, ‘L’))

Hi, I am having a problem using Integromat to upload my email attachments to Airtable. My process is to save attachments in Drive > Generate a direct download link (double checked that it works without requiring any login) > save all attachments in an array (multiple attachments) > upload the entire array to Airtable. I also get the files uploaded to Airtable as seen on my Airtable base. But within seconds, all the files vanish. I am at the end of my wits trying to figure out the problem. My email is a Google Workspace account, and I am currently trying out the Pro plan of Airtable. Also, the first few records uploaded using Zapier are still there. But Integromat uploads keep on disappearing. Please help!

I am seeking to embed an airtable form into a webpage. On the embed view, if I turn on autosize height, there is a javascript. When this switch is turned off, the embed is just a simple iframe. On the page webpage where I’m attempting to embed the airtable form, I can embed other pages using iframe. Therefore, I know iframe will properly display content. The embed code supplied by airtable shows nothing. The page is blank. When I use an iframe checker it reports: Header X-Frame-Options found. The header is set to SAMEORIGIN. You are on a different domain and therefore this page can NOT be included.. If I understand X-Frame properly, this indicates that an iframe embed can only be made from the airtable domain. The full header reported is as follows: HTTP/1.1 200 OK cache-control: no-store, no-cache, must-revalidate Cache-control: no-cache="set-cookie" Content-Length: 25963 Content-Type: text/html; charset=utf-8 Date: Sat, 26 Sep 2020 18:16:23 GMT ETag: W/"656b-ovIs+MpQkjuLC/L

HelloI have a task I'm trying to achieve with a script in an automation. It's an automation to run every 3rd week of a month (ideally), and to trigger a script which will find all the Wednesdays in the next month and create certain records on those dates. That part I have sussed out, but what I can't find out how to do would be to grab the data/title from the last record of the current month the automation runs on so that I can make sure the new records it creates in the following month flow on correctly. Eg:Automation runs on 16th Jan, triggers a script to create records on every Wednesday in February, starting with a specific title relative to the last Wednesday record in January.The script needs to find out the title of record on the last wednesday of January (which would have been the 25th) and pass that variable into some logic I'll create to determine the titles of the February entries it automates. Hopefully this makes sense! Thanks 

Sorry if I'm not expressing well what I intend to do.Let's say I want to list several virtual pc's services but most of them offer their services per hour and price ranges changes between pc tiers. Let's say basic £2 per hour, medium £3 per hour and ultimate £5 per hour.How can I display those prices in the best way so users can filter them, like they can type the price on filter so it can display the prices not exceeding £3I don't want to create text column with price ranges I want them to be able to filter them

Hi all,I'm having trouble to add a password to my Airtable account. I've ever used login throught Gmail but now I need to add a Password. I click to the field "Add a Password" in my Account page but I never receive the email to set it up. I've tried many times but never worked.Can you help me to solve it?Regards,Stefano

Hello everyone, Newbie on airtable here. I want to set up 2 databases and a form in airtable where the first database will hold unique email addresses and second database will hold a set of numbers with status “free” or “taken”. The form will be made available to my audience where they enter their email and choose a number say between 1-300. The logic I am trying to set up is when someone enters their email in the form, they choose a number and submit the form, airtable checks if the email exists in the database and if the chosen number is “free” or “taken”. If an email address does not exist, an error message will show email is not valid. If email exist in database and number is “taken”, show message this number is no longer available. If email exist in database and number is “free”, show message this number has been reserved for you and user receives an email confirming the number he reserved. I have been trying to set this up but its kinda complex to me. Is this possible with airtab

Hello everyone,I have more than one fields , i need to share Grid view with some users and allow them to edit piratical field only one time .example  : Check in field , I need them to check in the user , once they check in it's should block the selection and not allow them to change that record.it can be check in , or single option.the idea to prevent the user to do more than one changes in that record.

We are looking to enable users outside our domain (parents of our students) to submit a form with an attachment. If we turn on the setting "Allow unrestricted access to shared forms" at the org level what other impact might that have from a security perspective? We are using AirTable to manage very sensitive data about our students. Thanks!

Strange issue; the password field to access Airtable (both in the Activation form and also the Login form) were observed not allowing any editing in Windows 10 via both Chrome and Edge. Ever experienced something like this before? Does Windows have something that would prevent password field editing in different browsers? I’m left with an invited user that can’t log-in to Airtable. :confused:

Hi there,I have created a survey using Airtable and then an automation which triggers an email to be sent once the survey is completed. It's all working great. However, I don't want to save, store or have access to the information that is inputted into the survey. I just want people to be able to complete the survey - which will automatically generate the desired email and send it out on their behalf - but without me as the creator having access to their answers. Is that possible?Many thanks in advance!Rose

I want to setup an airtable structure with the followingProducts -Lists the standard products (name, sku, price) - there are 12 productsCustomers -List of the customers and products from first table with an option to override the price of each product for that customer What would be the best way to set this up? 

Thanks to Adam_TheTimeSav and his post Solved: Re: How to make a colorful kanban board - Airtable Community I have installed Tampermonkey and changed the background color of my Kanban board.I would like to go further and change colors for tasks and stacks. Where can I find Airtable documentation on the various options to do this and other things I might like to do in the future? In the script to change background color I findGM_addStyle('#kanbanView > div.white { background-color: aliceblue !important;Where does #kanbanView and others come from and what can I do with them?Where does div.white and others come from and what can I do with them?What options are available such as background-color?What does !important mean?I'm an old-timer who's been programming for decades. I think I can figure out how to do what I want to do if I could find documentation. For starters, I'd like to change the background color of stacks to match the listname. Hope this makes sense

We are a marketing firm that manages social media calendars for many clients. We love the platform for building the calendars and sharing amongst our team BUT sharing the calendars to the clients for approval is an actual nightmare that I can't solve. 1. We have too many clients to add them as paid collaborators and not be super cost prohibitive2. Sharing the view-only link does not allow them to even add comments if they have edits or comments 3. Sharing via email has been confusing for them and many of them can't seem to figure it out 4. Downloading as a CSV requires too much time in reformatting to make sense How are you delivering your social media calendars to your clients? 

Hi,I got error message when subtmit phone number to enable 2 steps verification. My country code is +84

In the blog post about the new button feature, there is a use-case where a button is being used to add a new line item under “run a script”. See gif below: If I open the Product Catalog template, I’m able to extract most of the code, however it is missing the part where it gives you the option to another line item or select “done”. Is someone able to help me add that to the existing code below? Thanks! let lineItemsTable = base.getTable(‘Order line items’); let clientOrdersTable = base.getTable(‘Client orders’); let furnitureTable = base.getTable(‘Furniture’); output.markdown(’## Add a line item’); let clientOrdersRecord = await input.recordAsync(‘Pick a client order’, clientOrdersTable); if (clientOrdersRecord) { let furnitureRecord = await input.recordAsync(‘Pick a furniture item’, furnitureTable); if (furnitureRecord) { let quantity = parseInt(await input.textAsync(‘Enter the quantity’), 10); let recordId = await lineItemsTable.createRecordAsync({ ‘Belongs to order’: [{ id: clientO

Hi Airtable team,I am from Vietnam and my country code is +84. I am trying to set up 2 Step Authentication but when submitting my phone number, it keeps showing the Error: "Error submitting phone number; please try again."Does anyone have any ideas to solves this? Thank you!

Heya, I'm setting up my first timeline view and using date fields for the first time, and feeling like a complete moron because I cannot figure out for the life of me where I am supposed to enter the actual date here, this UI is not making any sense to me, lol — am I supposed to type the date into the field name ???

Hi, I created a Whatsapp button, that connected with the correct numer. But it doesnt included the text in the message. Opened the app but the text doesnt appear: My formula is IF({Movil}, "https://api.whatsapp.com/send?phone="& {Movil}&"text=Hola!%20estamos%20en%20el%20domicilio%20anterior%20al%20tuyo.%20ya%20nos%20queda%20poco.%20Nos%20vemos%20pronto,%20Equipo%20Vacunatorio%20Altotobalaba") any suggestions? thanks in advance