Ask the Community

let table = base.getTable("Copy-Orders");for (let record of resulttxt['Data']) {    let recordId = await table.createRecordAsync({        "Order": Number(record['orderNumber']),        "Due Date": record['dueDate'],        "Order Total": record['orderTotal'],        //...        "Quote Number": [{id: '24229'}],    });}output.text("Created orders records OK!"); //tips:The field name is "Quote Number", the associated table name is "Quotes", the associated field is "Quote", and record['quoteNumber'] is the value to be inserted. how to deal with the  "Quote Number": [{id: '24229'}], for example,the value of Quote Numbe is  '24229'. thank you.

I am trying to make a tutoring database and have it so when a tutor claims a students session as a record and add themselves onto the record via the fillout form it makes it so that when another student loads up the page a conditional tells them that someone has already taken the spot. The problem is this only happens if the person opens up the form page at a time after the tutor already submitted his or her form or if the person reloads the page. I was wondering if there was a way for the form to refresh instantly without the tutor having to click refresh to let them know that someone took the spot because if both tutors open the form at the same time and tutor A submits first and takes the spot. On Tutor B's end it still shows that he can still take the spot so when he submits it kicks tutor A off the spot and claims it as tutor B's.

This might have a simple answer that I'm just missing - my supervisor wants to stay logged in to her Airtable account instead of being prompted to sign in each time. I use Google Chrome and am able to stay logged in with my workspaces saved as favorites on my browser. She said she has hers saved in her favorites as well, but uses Microsoft Edge. I'm not exactly sure why mine lets me stay logged in, I've just never had any issue. Any tips on what she could try to get the same result? Thanks so much for your help!

Hello,Is it possible to update multiple records from information in one email?I know I can use the “When email received” trigger to create a record and extract the body of the email into that record. However, I sometimes receive emails with information that belongs to different records in Airtable.Initially, I receive an order confirmation. That contains only information about one order, so I can set Airtable up to create a record from each order confirmation.When the order is ready, I receive another email, and that email often contains information about multiple orders.The data in the body of the second email is structured roughly like this:           The ordered materials have arrived.           Order number: …           [Other details about the materials]           Order number: …           [Other details about the materials]           Order number: …           [Other details about the materials]           You cannot respond to this e-mail…The order number is in the initial order c

The new forms look nice, but I liked old ones better. Specifically, it was not as wide and the font size was larger (now it puts a lot of strain on my eyes). How can I use the old design in my forms? Or adjust the font size and how wide the form is?

Hemos creado recientemente una comunidad de usuarios de Airtable en el idioma español, con la idea de compartir conocimientos, soluciones y trabajos en plantillas (templates) en el idioma español para todos los hispanohablantes. Si quieres aportar a que existan más usuarios de habla hispana que conozcan esta maravillosa herramienta, por favor mándame tu correo y te agregaré al grupo de co-work que hemos creado. Necesitamos gente experta en Airtable con interés de compartir su conocimiento. Saludos

The Send SMS App only works when I use the primary number under the Twilio Account Info Section But I have a second mobile number in the same Twilio account under my other Active Numbers that I want to send from but When I change the number in Airtable send sms app sending fails. I tried Creating new API Credentials but that didnt work or I dont know what I am doing there - there was no option to select a particular number,  and I cant find Auth Token and SSID for the number I specifically want to send from. Any ideas would be greatly appreciated.  

There has got to be an easy way to fill an Adobe PDF form with an Airtable record.It honestly sounds simple to me and I can’t find a solution (so I guess it’s not simple LOL).  I should be able to map fields from airtable to the fields on the existing pdf form and press a button to put the airtable data on the pdf form. Done. I’ve been messing with this for days now looking for a simple solution.  Fillout offers a complex solution and I’m struggling to overcome the learning curve.  Fillout forms are max two columns and it just doesn’t look good to me.  I like the way airtable forms look, the the functionality is limited.  For example why doesn’t a button exist to “SUBMIT and email a formatted copy of the data”? Currently, our staff is using an airtble form to enter data into the table.  Works fine.  But thennnn, someone has to physically enter that data from the airtable table into an existing pdf form.  Very time consuming and mistake prone.  Cut and paste or retype 50 fields.  We dea

Hello,We are a large sales organization using the Airtable Page Designer to create PDFs in order visualize data from our commission tables. We have created the PDFs in the Airtable Page Designer, but do not know how to attach them back to the individual record within the table.For example: we have commission data generated from the table for the entire sales organization. We would like the PDF that was created for Bob Smith, to automatically pull back into Bob Smith’s record. We plan on emailing all of these PDFs to each individual rep through an automation.TLDR: How do we attach the PDF to the individual rep (record) from which the information was pulled.

I have been using AT for about a year now and love how I can incorporate it to my project management and our companies overall workflow. I am now starting to get the hang of forms but am wondering if I can take it a step further. Here is what I am trying to achieve: I understand that you can embed a form onto a website to get information shot back to your AT. I am wondering if you can do the opposite and share that exact form with another individual, with pre-fille information, a pre-attached file(s) without having to share the record with the person through email. When a record if shared from the original form, the information (record) just gets emailed to the person and that does me no good because I would like to have a “single select” field where someone can approve the form that is being sent to them. If this helps for visual/functional purposes: I want to send over a URL link (custom generated form) to individual customers so that they can approve or deny proofs that our company

Hi everyone. I am able to get the following using Excel formulas but unable to find the equivalent in Airtable formula. Would appreciate any help here: [based on a given date e.g. 2020-11-25], show Number of days in a given month [30 days] Date of 1st day of this given month [1 Nov 2020] Days left in this given month [5] I tried workdays formula to no avail. Thank you. jamesquek

I have a transaction table that is collecting post information through a serverless function. When I get those transactions, I want to run an automation that will look for am email address and, if found, update the contact record, if not found, insert it. I need an Upsert. Is there such an animal in Airtable?

Thank you for your help, folks!!!! Each EVENT has two or three PROGRAM_NUMBERS with corresponding CREDITS_EARNED for each prog_numevent title prog_num_1 cred_1 prog_num_2 cred_2 prog_num_3 cred_3 event a xyz 1 abc 2 fgh 1 event b xyz 1 abc 3     Each CUSTOMER is affiliated with one or more EVENTS.At the end of the day, I need to produce this:Customer 1 event a xyz 1 Customer 1 event a abc 2 Customer 1 event a fgh 1 Customer 1 event b xyz 1 Customer 1 event b abc 3 Customer 2 event b xyz 1 Customer 2 event b abc 3

Hi everyone, I'm a bit new to using tools like AT and am looking for some feedback. My overall goal is to maintain membership data within organization(s). These organizations are linked together to some capacity and have overlapping members. I want to use this to my advantage so that updates from one organization update the profile of the person (and thus other organizations).I included some organizational charts below to get a better idea of what I’m trying to accomplish. The main problems I’m having with the current setup is:How to handle the unique person ID problem. Data lists provided are not 100% standardized with complete information. only 10% of records may have a phone/email, so do I resort to fuzzy matching based on first/last + zip code?User defined fields. Some clients may have a field they want to store for information like membership ID #, DOB, etc. How do I allow for this without adding a new field everytime and updating all my automations.How to safely handle bulk impor

Hi everyone 👋I’m running into an issue with an Automation setup and was wondering if anyone else has dealt with something similar.Context: Trigger: Webhook (connected to a form on my website) Action: Google Docs: Create doc Problem:Sometimes the automation fails with the following error:The contents contain unexpected formatting that cannot be convertedIt doesn’t happen every time, only occasionally, which makes it hard to debug.Has anyone experienced this with the Google Docs integration? Could it be related to certain formatting coming through from the form/webhook payload? Or maybe a limitation in how Airtable passes rich text to Google Docs?Any tips or workarounds would be greatly appreciated 🙏(I’ll attach a screenshot in the comments as well.)Thanks in advance!  

My Team plan has reached its API Public rate limit, evidently.It’s never happened before.How do I see my usage?Is there anything I can do-- can I get some more for this period?

Is there a way to set the time zone for all tables in a base? I just noticed that my “where Ordered is today” filtered out all orders and it’s only 6:31pm – the day is not over yet. :neutral_face:

Hello,I’m looking for a way to create a schedule based on projects stored in a main list (with the project name and team assignment).I’d like to display a calendar running from 7 AM to 4 PM, Monday through Friday only.A single project may be assigned to multiple days, and I’d like the view to show: Teams arranged along the X-axis, Days of the week along the Y-axis. The planning would be managed in AirTable, but visualized in Noloco.I’ve been trying different approaches but haven’t managed to get a clear solution.If a kind soul could help me set up such an interface, it would be greatly appreciated!Gauthier Arnould 

I think I have painted myself into a corner here. Appreciate any advice.We’ve migrated from another system that generated autonumbers for our Leads.I’ve imported all the  leads them into my Leads table. It is critical I keep the old data - it can’t be changed as all our  work for these clients has been against that specific ID number.You can see from my Screenshot that column A has the ID number (now a text field), column B has the customer name, and column C is a joining of the two (but just a text field for now, no formula/concatenation used).I have tossed in a 4th autonumber column to try and create a formula that carries on the numbering from column A (Lead Number). But now I’m stumped. Having an ‘m’ at the beginning of the Lead number does not help - otherwise I presume a simple sum formula to add the lead number to the autonumber would suffice. It’s like I need historical numbers to be text, but all future records to be a formula.Any ideas? Thanks in advance. 

I’ve been banging my head against a wall here. `block run` appears to run successfully but the webserver isn’t returning content and instead is returning a 404. A `block release` works successfully and I can see the `Hello World` in my extension. It’s running on port 9000 and it’s listening cause I get a response, it just doesn’t have any content.Any ideas?

THE HELP ARTICLE SAYS IT’S LOCATED IN THE BOTTOM LEFT CORNER.  IT’S NOT INTERFACE DESIGNER "ADD ELEMENT" BUTTON IS NOWHERE TO BE FOUND. What an I doing wrong?   Do I have to install “Interface Designer”? I click “ Interfaces” on the top center of my base and have created several interfaces.  None of them have an “ADD ELEMENT” button. I’m simply trying to add some instructions on this interface and I don’t need it to be a long text field.  I just want to add a Text element to add helpful formatted text, links, lists, descriptions to my interfaces. SUPER FRUSTRATING!!!!!!!!!!!!!!!!!! 

I’m running into a strange issue. I have a table of records that I filter by ‘Created date’ before passing it into “Generate text with AI.” At this AI stage, I’m just filtering entries where the Source is a scientific source (peer-reviewed papers, preprints, PubMed, etc.).This used to work perfectly. But today the output only contains 1 row, even though my input table has more valid entries. If I feed the AI a table containing only the two Nature entries, it correctly outputs both. But when I pass in the full table (with more rows from other sources), it only outputs one Nature entry. ExampleTitle: Paper 1 Source: natureTitle: Paper 2 Source: natureTitle: Blogpost Source: yahooExpected output:Paper 1 (nature.com) Paper 2 (nature.com)Actual output with full table:Paper 1 (nature.com)I also tried simplifying the prompt to:Based on the table: Grid of RecordsPrint all rows where the Source has "nature"But it still only returns one row. I first thought this might be a visualization issue

Can you tell me formula to make bullet list from comma separated text?eg text: "text1, text2".expected output:• text1• text2

This is not a new topic and I’ve read through all other topics on adding images to email automations using the <img> I use Airtable formula: IF(Attachments, REGEX_EXTRACT(Attachments, "(?:[^(]*\\()([^)]*)"))to create the url. The image file name has no underscores in it. I’ve done the img src=”formula url”/ and doesn’t work.I’ve done the Expiring Download trick and doesn’t work.I’ve created a long text field and added the whole image tag in it then pointed to the long text field in the email body and still didn’t work.I get the broken images. Results all attempts I’ve made below in image. Any insights where something is going wrong, I feel I’m almost there.

I am using a new base created with the help of AI. I have a form to enter data, however two blocks say “field deleted” and at the bottom, the “Create” button is greyed out, and it says “The form cannot be submitted because some of the fields have been deleted.” How do I delete these fields in a way that the form isn’t looking for them, and the form can be submitted?