Ask the Community

I am from a company selling STEM supplies to schools. I have three tables:A “Material List” table with a list of materials we have in inventory An “Activity List” table with a list of our STEM activities. Each activity has a linked record field which is populated with linked records in the “Material List” table   An “Activity Material” junction table with the quantities of each material for each activity listed.  Desired Outcome of the Script:I’ve written a scri

I would like to monitor when anyone changes certain field configurations (e.g. changes the field type, or edits a drop-down selection or similar) so that downstream dependencies can be adjusted or the change can be rolled back. The field manager seems helpful but doesn't seem to be proactive enough for this purpose.

I have a schema, which I would like to implement for 3 similar businesses.  Is it possible to have the same base template, and have the schema synchronised between ALL 3 bases?  That is, if for example I add a new table, it is also added on the other bases. Same for fields.I would like to segregate the data, and also they do not need to share the data, hence it doesnt make sense to hit the 125k record for Business for example when they are not related data, just related schema. 

Hello there, Does anyone know how to export from base schema? I want a snapshot image thats clear to show elsewhere.  

I have a list of addresses and I already represented them through Map block using google Map API on the map. The queseion is how to get the coresponding geocode (latitude and longitude) for each address. eventhough I noteced that Map Block created text code for each address called Geocode cache is that may help or converted to coordinates. “Geocode cache This block stores additional information for each address. Create a new text field in your table and pick it below. Other map blocks can use the same field.” Thank you so much for your help in advance.

Okay guys, ive seen a similar post about this but didn’t answer what i was looking for. I am wanting to take a url (google.com) and add it to a “open URL” button then another record have another url (youtube.com) and add it to another “Open URL” button. What formula could i use to target the url inside of the button field? SCREENSHOT: https://snipboard.io/A3ucNd.jpg

I would like to send out an email through automation and share a link to a specific record in an Interface. Is this possible? Regards, Ruchika

Hi !Our company is working with Airtable for almost a year now, and I believe it can provide everything we need from a CRM / Dashboarding tool. But as our company grows, our Airtable base also is…  and we’re at the point of needing to evaluate the database structure because I believe it will become a bit of a mess when we grow and continue this way...  So I would like to reorganize the database and also build a lot of interfaces on top of that, so I don’t want to break up the database structure afterwards… 😉 So before changing it all, I’m looking for some advise and best practices on how to design a structured Airtable base which can grow and develop along with our company. More specific: right now I’m looking for some guidelines to when to separate or combine a grid to keep data in a structured way and maintaining flexible as our organization grows and our processes and needs change along. I appreciate some general guid

Hi everyone! I'm trying to create automations such as emails and Slack messages to send reminders to my team to update certain projects (records) in a project management interface. When we were using data mode, I simply linked to the Record URL in the body of the message in the automation. Is there a way to link to a specific project/record in the record review layout? Or perhaps in the record summary layout?Here's a link to the video I sent to customer support. I haven't heard back from them and they suggested posting here. https://www.loom.com/share/d6166031e85e47afaf7e1311866f7b88thanks! Megan

I have two emails showing up and the wrong one is one character off.  I don’t know how to reach help to fix this so I can get access to all my bases 

I do not get Function Field as a choice in customize field selection- I get Number, Date, etc. Thanks.

This is something that has been bothering me on both desktop and mobile…  When I have the app downloaded to a device, and I click on an email that is from a comment, there should be a function where the action takes me directly to the comment in the app. Not to a login page in my browser, not a new tab in the browser.  This would be a lot better than the current behavior because: 1) I downloaded the app. I’m here, I’m using the app, I’m the power user and I should be taken care of; 2) When opening a series of comments in my email, I now have to wait for each of the tabs to open. My base isn’t small, so it takes a while each time, and it’s a little frustrating. 

We recently added the ability to create tables, create fields, and update field options from the scripting app. The methods to perform each of these actions are the same as in the Blocks SDK. base.createTableAsync table.createFieldAsync field.updateOptionsAsync Refer to the Field Options documentation to see which options are supported for each field type The field types that are allowed to be created via base.createTableAsync and table.createFieldAsync are: barcode checkbox currency date dateTime duration email

Hello, I’m trying to wrap the text in linked fields but I can’t figure out how to do so. In the example below, the Name and the Doc Gap Descriptions fields are linked. In the original field, where the field type is Long Text, the text wraps and is fully visible. In the linked field, the text is cut off rather than wrapped. How do I display wrapped text here? I tried seeing if wrapping would happen in a printout using the print option of “Wrap long text onto additional lines as needed,” but that doesn’t wrap the linked text either. Thanks, Erik

I have a view on an interface for a large database of plays that I want to group by their playwrights. I have added in a user action that allows this to happen. However I have to click ‘Group’ and select ‘Group by Writer’ every time I open the interface. Is there any way to ‘lock’ this grouping so that the plays are grouped in this way every time I open the database? The first picture is how I’d like the database to open and the second is how it does open (where I then have to manually group them).Grouped Airtable Ungrouped Airtable​​​​​  

Hello Airtable Community!I’m designing a system to collect structured KPI data (10 standardized metrics) from independent businesses. Phase 1 (Pilot): 16 businesses entering data via Airtable forms Phase 2: Expand to 60 businesses Phase 3 (Scale): 600+ businesses Goal: Aggregate all submissions into a single dataset for analysis and benchmarking.My core questions: Can Airtable handle this scale of data collection and access control? If so, what architecture would you recommend? One base where businesses submit via forms, with Interfaces restricting visibility to only their data? Or multiple bases that sync into a central analytics base? Thanks in advance for your insights!— Walker

Hello everyone,I created an automation that sends an email (gmail) at the click of a button. It uses some fields + attachment to create the email:Fields:Email addressSubjectBodyAttachment It works fine but it is very fragile: if one of those fields is empty, the email won’t work and the user won’t know.I set a warning message when clicking the button, it helps, but I’d like something stronger; like during the automation, if any of those fields is empty, to show a popup or error message to the user.I have looked around but cannot find anything like this. Any help?

I have 3 tables:Table 1: Work productivity data from our delivery management system. This has the employee’s email and date of shift.Table 2: Employee Data from our HR system. This has the employee’s email address and employee ID.Table 3: Shift data from our clock in/clock out system. This includes the employee ID, hours worked, and date of shift. There is a way to link all three as they share sufficient fields. I would like to match the productivity data for a specific employee on a specific date to the hours work within Table 1. So I have hours worked in there.For example, I’d like in Table 1:Bryan - bryan@hotmac.com - employee ID: 113495 - 34 tasks - 4.73 hours worked. I can link each table, but I’m stuck on how to match the shifts on the correct date between Table 1 and Table 3. Any help is really welcomed. Thank you.

Is there a way to customize a form so it’s more than just one long vertical column of fields. Would like to have fields be able to display horizontally too.That way you can see some or all the fields at once. Any ideas for layout change?

So, we have calendars imbedded in our website and have color-coded different activities to make it easier for the parents to look for certain things.  This is the grid view.And this is the embedded calendar.  But the colors aren’t translating.  Everything on the calendar is the same color unless you open the activity up. 

Hi everyone,I always found Airtable formulas a bit tricky, so I built a Chrome extension called Airtable AI Formula Builder. It lets you describe what you want in plain English (e.g. “combine first name and last name”), and it instantly generates the correct Airtable formula.👉 Extension link: Ai formula builder It’s a freemium tool: you can try it once for free to see how it works, and then unlock unlimited usage with a small upgrade.This is the very first version (MVP), and I’d love your feedback: What formula types do you use the most? What extra features would make this more useful for you?Thanks a lot, every bit of feedback helps me improve it 🙏

Hello!In the interface, I have a kanban section with some cards where 4 fields shows, aside from the name of the cards. Now my problem is that those fields also show their title.So at the moment it look like this:Garry’s PubTypeCADAddress157 Rue de VilléCityMontréalBut I want it to look like this:Garry’s PubCAD157 Rue de VilléMontréalAnd I cannot find the option to hide the field titles anywhere.Anybody with better luck than me here? 

We have an intake form to generate URLs with UTMs parameters. I have created a new form with additional functionality. During testing, I need both the old and new forms to work.My current Formula field concatenates the URL (Root Link) with the UTM parameters and values. There is also a check to determine if the URL provided in the Root Link field contains a "?". If it does, then the concatenation output is handled differently:IF(FIND("?", {Root Link})=0,{Root Link}&{Source Parameter}&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input},{Root Link}&"&utm_source="&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content P

Hi guys,The easiest explanation of my problem is this:I have an orders table and I have a “Tags” field in that table (multi select) - one of the tags is “Awaiting Payment” When a customer pays, a team member will remove this tag. When this happens, we want to automatically leave a note in our Notes table.We already create notes automatically in other automations so are confident with that part, but the trigger is more of an issue?I’m thinking that maybe I need a “Tags Previous State” field to copy to?Not really sure, I appreciate any insight anyone can offer. 

In airtable form the column should be visible when 2 column values together should be 100%. 1st Question:For example, as shown in the screenshot below, in the Airtable Form, when a user updates Tag 1 and Tag 2 so that their total equals 100%, Tag 3 and Tag 4 should no longer be visible in the form. If the tags do not total 100%, all three remaining tags (Tag 2, Tag 3, and Tag 4) should remain visible. 2nd Question:Is there an option or way in Airtable forms to prevent users from submitting the form if the total Tag does not equal 100%?