Ask the Community

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

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

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

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.

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! 

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 i

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

How to populate a blanc single column in Hubspot from a filled column in Airtable using integromat?

Hello! I run an auction house for a primarily text based MMORPG that’s PG-13 with the use of Airtable. Lately, we’ve received some submissions that are clearly meme/pranks. The problem is, that some of the material that have been submitted have involved nudity and acts that are lewd. Which breaks the rules of the auction house, as well as the MMORPG that the auction house is ran for (It’s the internet. Some players in the game are minors.). That being said, the staff for the game has asked that I grab the IP address of those that have submitted such images/content so that those users can be banned as appropriate by the game’s TOS. Is there a way for me to discover an IP address of the form submitter or figure out whom submitted what?

Is there a way to use Google Analytics to track table views?

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 Records

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?

I have two forms on my website: An interest-gauging form where the client fills in their name, email, and a brief message, and a longer form that they’re emailed later. 📄I’d rather not have “John Smith” in two separate databases. Is there a way, upon submitting the second form, for the answers to be combined with or added to the records from the first form, like if they share the same email address or something? 🤔

Just curious if anyone here uses a form on a website as a contact submission form. Do you have a problem with spam entries? I’m thinking of replacing my contact form with an embedded Airtable form.

Hey guys I am new to airtable and trying to develop a weekly schedule for our team based on the projects that are scheduled for that week.We have approx. 20 staff in the field each week, multiple projects running each day and each week. Some projects will only last one day, others might last 5-10 days.I have managed to develop the full week schedule with staff assigned to each job. However, we often need to change the staff each day on each job i.e. a project that lasts 5 days might have different people on it each day. Is there a way to show this view for a week, with the different people on the projects on each dayHere is a picture of our current excel spreadsheet we use that I am trying to replicate Thanks heaps