Other Questions

Airtable has this really handy trick for instantly reformatting phone numbers into (###) ###-####.I need the same treatment for email addresses that are entered throughout the Airtable base to force them into lowercase. It's getting clunky to include reformatting language in automation.I'm not great at creating scripts. Is that the solution?

Hello,I am using airtable for a two step form process.The first table is called "Event Request". When you submit the Event Request Form it makes a record in that table and assigns it a "Request ID" number via an auto-number field. Once that form is approved, via some script and automation, the user receives a prefilled "Event Information Form" from an Event Information Table to add details.When the user submits the Event Information Form, I capture the Request ID from the initial request in the Event Information table too.What I would like to do is have a "Form Received" field in the Event Request Table that can say "yes" if there is a matching Request ID in both the Event Information and Event Requests table. Any help would be much appreciated! Thanks! 

Hi guys, we’ve been using web builder Softr and integrated some Airtable databases which can be accessed via URL web browser. Softr offers the functionality that we can build up a pre-defined filtering with URL for our entries. (their example: https://ninfa906.softr.app/list?filter-by-Position=Engineer) We tried to set this up based on our Airtable database data but failed (already tried a lot of other structures, case sensitive etc.). They recommend this structure: ?filter-by-fieldName=fieldValue In our case this would mean (main URL is: KidsCircle-Kurse & Workshops): https://www.kidscircle.io/kurse/list?filter-by-Coach=BRUNO (fieldName is Coach,

When I embed an Airtable grid into Squarespace and peek at the mobile view, it doesn't display the card layout as it should. It displays a sliver of the standard desktop grid layout. Is this a Squarespace-only anomaly? Any workarounds>

Suppose I have multiple products (Cola, Root Beer, and Diet Cola) that come in different sizes (6-pack and 2-liter). I currently have an interface set up where I can fill out a sales order where product and size are selected separately via single-selection. The problem is that each possible combination has an arbitrary price not based on any mathematical formula. I would like to reference the price based on these two selections, but I can't see any way to do that.I'm totally comfortable making a new table with a separate record for each possible combination (so six, in the current example). I just need a way to reference those records based on my two single-selects.

Hello:I am trying to create a RollUp for A Scoring Process we are undergoing related to our Strategic Plan. I have managed to get everything else to work; however, I am running into a challenge doing a RollUp for two questions.One is a Simple Yes/No Question. I want to get the total number of Yes/No Votes.The second is a Yes/No/Maybe question. Likewise, I would like to get the total number of Yes/No/Maybe votes.I have tried creating conditional formatting that counts IF FIELD=YES, but that is not giving me the total number of 'Yes' when I roll up. I recognize I will probably need five new columns - but I cannot figure out how to get them to populate with the required information.Thanks for any help. 

Hi, im using softr form to upload people images to airtable and then print it to an dynamic list in sofrt, but if they attach multiple images, softr just shows the first, how can i split this multiple attachments to different records?If you have some advise or another solution i hear you.Thanks.

Dear Airtable Community,I'm reaching out to seek assistance with a perplexing issue regarding the Airtable - Power BI Integration that has been causing me considerable frustration.As many of you are aware, the Airtable API imposes a limit of 100 records per request. However, I've encountered several challenges:Airtable seems to pull 100 records at random, without following any discernible order.The M Query function only operates when I utilize my API Key, which was supposed to expire last month. Personal access keys and OAuth integrations consistently result in errors.Attempts to make additional requests with offset values have only yielded errors.When I've tried to access data via the web, I'm prompted to sign up for Airtable, yet my browser is not supported, and there's no clickable button for further action.The complexity of this integration has left me feeling disappointed, particularly considering Airtable's prim

Hi Everyone, I’m working on a TV series, and looking for some online database solution for a really easy(-looking) task: I have to follow the realationships between the characters of the TV show during the script writing (friends/enemies/…etc - it can also be a simple list). So it means I make a list with the names of the characters I guess, and then I need to duplicate this list and somehow make a third list that contains the connections between them (it’s like a two dimensional graph). And then the second question: if the database is finished, how can I easily make the entries (we are talking about hundreds of character names). For example, I have two names in the list: “Joe” and “Bob”. I want to change their relationship into “friends”. I guess I will need some kind of combined searching form that looks for the two names and make me able the change the third data between them. Do you think I can do this in Airtable? Can you help me with this? Thanks,

Hi there, Brand new to Airtable and have been messing around with it to see if it fits our needs. I’ve been impressed! One question I have yet to find the answer for is… Is there a way to process a submission fee payment as part of forms created through Airtable? As an organization, we collect a small application fee. While I assumed that Airtable’s integration with Stripe/Paypal would make this easy, I have yet to find a way to do so? Any help or potential workarounds would be appreciated.

Hi Everyone,I've been using Airtable as an event registration platform for several years.I am seeking assistance in building a new event registration base where the registration form is linked to another Airtable base so that people attending previous events don't need to retype registration data such as email address, company name or pictures. The trigger can be the name of the person.I am looking forward to hearing from you.Zoltan

HiIs there a way to know how many API calls I've already made this month, and how many API calls I have left?

Hi all, I have DB on airtable and softr is processing the data and displaying as needed. My next step is to push the displayed images to Pinterest, but when I try to add the URL of the product page from Soft to Pinterest I'm getting this errorURL: https://shop.engroovers.com/tribesigns-products?recordId=recr9Wkxlqh0kM7H9"No images found. Remove any tracking parameters in this URL to try again."I understand the that the record ID is coming from Airtable but is there any way I can modify it to show the image when added from URL?Kindly let me know. Thanks.

I have been testing Process St for documenting my tasks/processes to delegate to others. It is a great tool that lets me create the steps on a left navigation and then add text/images and videos to each step. I was curious if there might be a way I could do this in Airtable. I am stuck because I can’t include text and pictures or videos on the same field. Here is an example one I did using Process St. app.process.st

I’ve just started diving into Airtable and have successfully setup our Jira Cloud instance and synced the data into a base. This seems relatively useful, however not being able to update fields and sync them back is quite a big drawback. Are there any workarounds to this? Is this feature anywhere on Airtable’s roadmap?

Hi guys, I'd like to share a section of views (these 14) is there a smooth way to do this without sharing all of them individually?I don't really want to share the whole base as there are tables with sensitive info in themAny and all help appreciated!

I’ve searched, googled and tried all the formulas I’ve found and nothing is working. I feel like I’ve spent more time working on these dang formulas than the table itself. Any help is greatly appreciated. Also, if anyone knows anywhere I can test a formula or understand what each means in the order it should be would be a huge help. I just don’t understand Airtables examples (its just words…no way of linking) which is where I think I am failing. I have a scheduled tab with dates (no times) for upcoming projects. I’d like to have a formula that shows if the date is today - the formula reads - DUE TODAY. if the date is within a week - Due next week If its due in 1 day - due tomorrow If its past due - Past due. I know its simple, but again - I loose it on the commas, parentheses and quotations. Maybe if i can figure this out with some help I can add some emojis. Thank you.

Is it possible to limit the filter option (tags) in one field based in the results of a filter set on another field?Example: I've created a view and shared the link. The user comes to my view and wants to filter the results displayed. Assume user wants to filter on two different fields (both of which have 10 values/tags each).User selects 1 filter out of the 10 options available in Field 1.User then goes to select a filter from Field 2. Is it possible to have the options available to select in Field 2 limited to just those that remain associated with the results of the Field 1 filter rather than showing all 10 of the Field 2 options. Let's say only 3 of the 10 Field 2 options are associated with the items in the result of the first filter. Can the filter selection view simply show those 3 or does it have to show all 10 even though 7 of them would result in an empty result set? Thanks!

Hi All,Newcomer to Air Table here.Can someone assist and let me know if I have created a base and, in that base, I have four tables.Is it possible to share just one table from that base but allow that person to be able to edit and add to that table but at the same time not be able to see or edit or add to any of the other tables in that base?Appreciate your help in advance

I know we have a "Contains" operators which works, but it would be nice to have a "Starts with" operator, for example when dealing names that contains the some or more of the same letters but doesn't start with the same letters.

Hey guys, just wanted to check if the charts in the interface are showing for anyone in the iOS App?iPad App does not offer interface support currently?

See an old discussion on this but nothing recent...any suggestion on best practices for copying an entire Workspace?  Built a workspace for a non-for-profit organization with multiple geographic chapters, looking for a means to give the tool we've built to others void of all data.  

I am new to Airtable. I have create a Form to capture Emergency Contact Information. When I shared the link, the end user must register to complete this form. Is there a way to have the employee complete form without having to create an account or register?Note - I am currently using the Free version of Airtable. I don't know if this make a difference.

Hi I am trying to update Airtable records using Integromat. I am getting an error: “The operation failed with an error. Insufficient permissions to create new select options” I have found out that it has to do with my multi-select option fields in Airtable (when I remove those options the record gets updated.) I would like to know if there is a workaround or some other solution, so that I don’t have to go back into the Airtable records and manually select all the options. I have over 200 records. I don’t want to have to do this for each record, that defeats the purpose of using an automation app. Is there a solution? Thank you, Mary

Hello, We are a custom shoes company and our customers can select their desired heel types. We have 13 different heel types with 13 unique codes (ex. 4544, 2017). Everytime we have an order, we are creating a record line with the necessary information, and one of the columns is HeelType column. We want to create an inventory table that we will update manually when we buy new material, but it will decrease automatically everything time relevant heel is typed in the Order Table. For example, if we bought 50 pairs of Heel 4544, we will increase the value by 50, but we want it to automatically decrease if we write an order record with Heel 4544 on the other table, so it will be 49. Same goes for the other heel types. I feel like this is so easy but I couldn’t manage. Thanks for your help in advance!