Ask the Community

I'm looking to create a form with fields for a project lead like name, title, affiliation, and email. What's the best way to allow for multiple project leads? Ideally, a user could click a checkbox to 'Add Additional Project Lead'. There's no limit on the number of leads. Any advice on using repeating fields for this? Basically, trying to determine if I can somehow not have to replicate each field an ungodly amount of times with a checkbox between each conditionally showing the next bunch of project lead fields conditionally based on the particular checkbox (nightmare).

If I have one date in a single cell, then I would use the formula DATETIME_FORMAT({}, 'MMMM) to convert that date into a month.  However, sometimes when using a Look Up I'm pulling multiple dates, separated by commas, into one cell. I'd like to find a formula that will convert all of these multiple dates into the month equivalent. So solving the 'error below'.  Any help much appreciated. Thanks. 

I am trying to build an order system with several tabs: Orders at vendor (I buy from 1 vendor) Orders from customers Customers Products An order from a customer has several products and might have more than 1 from each item. And that is where I get stuck. How can I add more than 1 of an item when there are multiple items? If it was just 1 item more times the colums would be product & amount, but that wont work. I feel like I am missing something obvious…

I have a string of text that I want to break into two separate strings of text. Here’s an example: This is an example string of text / I want to break it into two separate strings of text I want all of the words that precede the “/” to be one string of text. And then I want all of the words that come after the “/” to be a separate string of text. I want to completely eliminate the “/”. So, to recap, we start with this: This is an example string of text / I want to break it into two separate parts And then we end-up with this: This is an example string of text I want to break it into two separate parts

I have emailed and used the contact support feature and have not gotten a response. I need to have tax removed from an invoice before my institution can pay the balance. Has anyone else dealt with this? Why is there not a phone number where we can reach a support person?

As some of you may know, I’ve spent the past year, at least, battling a debilitating physical condition. For the last few months, this expressed itself as near-disabling reflected pain in my arms and shoulders that made working at a keyboard – or focusing on any task more complicated than rereading genre fiction – virtually impossible. Although the condition was finally diagnosed mid-November, complications (a two-month pause to reschedule surgery with an in-network physician amenable to my insurance provider; the scorched-earth arrival of Covid-19) pushed my surgery back to April 10. (Fortunately [?], the delay meant my situation had deteriorated to the point the procedure was no longer considered elective; otherwise, you’d be reading this in October.) Today, a week out of the hospital and with another month of recovery ahead of me, I already feel better than I have in a couple of years. A whole raft of symptoms my doctors said might be alleviated by the surgery have completely disapp

Dear allI'm new here to the community - so thank you for all future help & interaction!I have trouble finding a setting to the buttons in interfaces. In the airtable manual (https://support.airtable.com/docs/interface-element-button) there ist the following description: AppearanceBefore moving on to further interface configuration or publishing your interface, you may want to rename/label the button or change its color to provide more context to collaborators who are interacting within the interface you are building. You can also have the button update colors and/or label after the button has been clicked. I saw this function in the past, but can't find it consistently. Maybe I'm just don't see it or was it removed? I also can't find any thread or comment about this.Since it is a very valuable feature, I'm greatful for every hint!Kind regards, Chris

HelloI'm trying to do something like this:Attributes TableNameMin ValueMax ValueHealth-99999999Energy0164000000Potions TableNameDescriptionAttribute ModifiersFooBarHealing Potionheal_pot_descr(Health 50)......Curse Potioncurse_pot_descr(Health -25), (Energy -25)......So is that possible? I.e. referencing the attribute value in the Attributes Table from the Potions Table with an additional value of some type (in this example an integer)?The use case there is pretty simple and straightforward. I was also wondering if that's not possible if we could join then two columns into one? Something like:NameAttributeModifierAttribute ModifierHealing PotionHealth50(Health 50)Curse PotionHealth, Energy-25,-25(Health -25), (Energy -25)This at least allows us to preview the values in the table

Hello,I am stuck at automation and would highly appreciate help with the issue.I have the tables:Projects (linked to operations),Operations (linked to projects, stakeholders, products, accounts),Stakeholdersand Accounts. What I am trying to do:If you create a project, I want to create several rows in Operations table (with template) - one for revenue, several for fixed costs.But I want to input the Stakeholder and preferably product, when adding a new project.Scenario:1. Add project (project name, stakeholder)Projects Table:Project NameStakeholderTEST1X2. Template created one row for Revenue and several rows for fixed costs in Operations. What I want is to fill in the same stakeholder for Revenue entry in , which was chosen in Project entry.Operations Table:ProjectStakeholderTypeTEST1XRevenueTEST1 Cost1TEST1 Cost2

Hello,I would like to know if changing my extension name and the dev contact is possible. I tried to find the solution in the code but didn't find any information. Do I have to recreate a new extension with the name I want? (I know I can change the extension name after but I would like to see if I could do it directly)Best regards  

Hey can you kindly tell how to generate Api key for air table . Is air table generating api keys or not? I tried every method i get a personal token but key isn’t generating. I also pasted personal token at the place of api key but it gives error 401 in voice flow

Hi, my currency script can be run manually but fails when run via automation. I'm using the standard, "recommended" currency script.  See attached image. 

I'm using formula: SET_TIMEZONE(NOW(),'America/Los_Angeles') I want it to show the current time in LA but it keeps returning the UTC time instead. Any idea what's wrong with the formula?

Hi everyone,I am having trouble with a SEARCH() formula that isn't acting as I would expect. I have this long text in the field "FORMULE" :"1: Pratiquer une activité2: Me consacrer3: Vivre des expériences4: Pratiquer un sport"I want to search for the position of this string : "Vivre des expériences"Here is my formula : LEFT(FORMULE,FIND("Vivre des expériences",FORMULE)) And here is my result : "1: Pratiquer une activité2: Me consacrer3: Vi"-> The end string finishes by "Vi" which is one caracter to long, it should finish by "V" only... It is an example but it changes when you look for the other words, other example, when I search for "Pratiquer un sport" it gives me this result :"1: Pratiquer une activité2: Me consacrer3: Vivre des expériences4: Pra"-> It is now 2 caracters too long, it shloud finish by "P" onlyDo you have any solution about this ? I am surely missing something...Thanks a lot for your help

Is it possible to hide or display certain fields in a table based on the value of another field? Basically, conditionally. For example, let’s say a table has the following: Field A Field B Field C And I want the following display options Field A: Always visible Field B: Visible only when field A is marked “Present” Field C: Visible when field C is marked “Absent” How would one do this?

I know using a formula like this-IF({T-Shirt Size} = "extra small",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -2), 'MM/DD/YYYY'),IF({T-Shirt Size} = "small",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -6), 'MM/DD/YYYY'),IF({T-Shirt Size} = "medium",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -13), 'MM/DD/YYYY'),IF({T-Shirt Size} = "large",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -22), 'MM/DD/YYYY'),IF({T-Shirt Size} = "extra large",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -30), 'MM/DD/YYYY'),""))))) Gives me the date in the format I want but I would like to have it in bold and Airtable says "Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date." I know this is a result of using DATETIME_FORMAT. I updated the formula to:IF({T-Shirt Size} = "extra small",DATEADD({Expected Final Files}, -2, 'days'),IF({T-Shirt Size} = "small",DATEADD({Expected Final Files}, -6, 'days'),IF({T-Sh

I am new to Airtable.  I have a base of speaking engagements.  I want to send an automated reminder to my boss when the engagement is 5, 3, and 1 day away.  I am able to get it to work the first time but I can't get it to know that the time is getting closer.   From what I read, DATETIME_DIFF used with NOW() doesn't update daily.  How to get this to work?

In airtable, I've programmed a calendar with dates and times for specific events. The formula is as follows: IF({Override horaire cour 1}=0,IF(Ordre="1", DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h1}), DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h2})),DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Override horaire cour 1}))When I install the calendar in my application, all the appointments are 1 hour later. How can I fix this?

Hello,I am having an unusual experience in Interface Designer's "Checklists" which is causing a problem for me...When I have added a Text Box element to my Interface, and use the "Checklist" function (this is *not* the Airtable field type CheckBox), it's behaving strangely. When I am editing the interface, I can check/uncheck the Checklist. But when I've published it and I'm in the "normal" user view of the Interface, I cannot check/uncheck the Checklist boxes. So, if I "check" a box while editing, and then publish the interface, then the checkbox is stuck in the "checked" status. Likewise, if I "uncheck" a box while editing, and then publish the interface, then the checkbox is stuck in the "unchecked" status. I cannot change it either way from the User View.This is surprising to me. Does anybody know how to get the checklists to be able to check/uncheck when I'm using the interface, and not just when I'm editing? It's hard for me to imagine this is the intended fun

Hi, guys!I would like to find out if Airtable is by default downsizing attachments when it comes to images / video / PDF files. Thank you in advance!Razz

I have a base that I use for onboarding new users. New records are created via a fillout form. I want to create a linked record in my Agents & Staff table, as well as my phone directory table when a new record is created in onboarding. I know how to link to an existing record, but I am stuck on creating a new record and linking.

Hello you wonderful people! Small roadblock I've encountered that I am hoping someone can help with. I would like to use Airtable for our team to record meeting notes. When a new record is created in that table, it would be great to have some text pre-fill, much like in the manner default values can be assigned to some Field types. Since the default option (as far as I can tell) doesn't exist for Long Text Field type, I figured I would use an automation. I tried a simple test. I tried to get the automation to produce rich text entry, or even multiple linesEven using markdown, I was not able to get more than a single string of text to appear... ie it looks like this on my best efforts: **Action Items:** <br> * 1 <br> * 2 <br> * 3 The Goal is to have a much more complex volume of text (ie default questions for one type of meeting, default questions for another, action items, follow up reminders, priority... etc etc...Is there a solution?  

Hi everyone,My team and I are trying to create URL previews for AirTable share links. The URL preview extension works for other URL types, such as Google Sheets, but we are seeing "No preview" when we select a cell with AirTable share link. It's the same issue whether the share link is for a base or for a table view.While looking through online documentation, I saw that the format of the link that's generated for us is different from the format I see in the documentation. Ours is in the format "https://airtable.com/app[random-string]/shr[random-string]/tbl[random-string]" or "https://airtable.com/app[random-string]/shr[random-string]",  while the online documentation shows the format "https://airtable.com/shr[random-string]".I'm not sure if that is the cause of the URL preview failing, but was wondering if anyone else encountered a similar issue.Online documentation I was referring to:Screenshot 1Screenshot 2Screenshot 3 

Anyone else having issues logging into Airtable with two-factor authentication? The code that is supposed to be sent via text message to my phone is not going through, so I am unable to login ☹

upgrading to Airtable's Enterprise plan would remove the base row limits and allow more automations, but as of my knowledge , it is very expensive around 10k$?We have a large dataset that exceeds the 100,000 row limit per Airtable base. We also need more than the 25 automations allowed in the base. Upgrading to Enterprise is not feasible due to high cost.  We're looking for more affordable solutions to handle our large dataset size and automation needs within Airtable's business solutions. Has anyone found creative ways to structure large datasets across multiple linked bases or integrate affordable supplementary tools to overcome Airtable limits?We'd love to hear any cost-effective ideas or solutions that don't involve upgrading to the expensive Enterprise tier.Even partial solutions could give us ideas to explore further. We greatly appreciate any insights the community can offer!