Ask the Community

I can't seem to get labels to appear on my scatter plot even when hovering over the points. I am trying to plot leaf length and head weight for varieties, I'd like to be able to label the points with what variety they represent.

Hi guys, I'm building a CRM on Airtable. That CRM has a form to add new contacts. This form boasts 2 linked record fields: a `Contacts` field and a `Main Contact` field. I would like the `Main Contact` field to be dynamically filtered so that it displays only the contacts that were previously added by the user in the `Contacts` field. I've been trying to get this, but with no luck. I don't think that's possible as of yet in Airtable. Do you confirm this? I know I could execute this with Fillout, but I'm trying to stay within Airtable as much as possible.Thanks.  

I want to link Apollo to Airtable so I can people search from within my base.I got the Apollo organization data working with the code below to fetch company details:let apiToken = 'API KEY HERE'; let table = base.getTable('TABLE NAME HERE'); let { records } = await table.selectRecordsAsync(); console.log(records); for (let record of records) { let domain = record.getCellValue('Domain'); let response = await remoteFetchAsync(`https://api.apollo.io/v1/organizations/enrich?domain=${domain}`, { method: 'GET', headers: { 'Content-Type': 'application/json', 'Cache-Control': 'no-cache', 'X-Api-Key': apiToken } }); let data = await response.json(); let organization = data.organization; await table.updateRecordAsync(record.id, { 'Company Name': organization.name, 'Linkedin URL': organization.linkedin_url, 'Address': organization.street

Hi guys, I don’t know if the title is clear. So here’s some context. I am currently using Airtable as a CRM. Thus, I have 3 important Tables : Leads, Unpaid Leads and Clients. As of now, people can pre-subscribe to my service (not open yet). When filling the form, they will go to “Leads”. Once the service will open, I will manually validate them to send them a form for Subscription. If they fill the form, they will go to “Unpaid Leads”. If they do not, they will stay in Leads and receive a followup at D+3. If they do fill the subscription form, I’d like to erase them from “Leads” in order not to follow up with them if not needed. Do you know if there is a script for that ? Or anyway to work around it ? If there isn’t, is there a script that can help me update the status in the 1st Table when a form is submitted in the 2nd one ? PS: FI, I first wanted to keep everything in the same Table ‘Lea

I am building for the following scenario and need help to understand a few things1. I have a master table that has the main data (Name, Email id, etc) 2. There is another table with a field (Name) that is linked to the name field in the master table.3. I designed an interface to delete a record from the master table. 4. Now when I see the linked field in the second table, it has disappeared as it should be. However, the entire record does not get deleted. 5. So currently I have added a check column in the second table to check if the Name field is present or missing and am running an automation through Make to delete the entire record for the second table.I wanted to know if this is possible through airtable automation itself instead of creating an automation through another tool. Also if this is possible to run the automation through an interface. Thanks

Hi. Thanks in advance for any help.I am importing a  CSV file out of another application that exports a field in a currency format. ($X,XXX.XX). I've created a currency field in Airtable to import it into, but AT always ignores it.So, I ended up exporting to Excel, changing that field to a number without a dollar sign and that allowed me to import it into the AT currency field.  However, I'd like to avoid this step and go directly from the exported CSV into AT without messing with Excel.I assumed this meant that Airtable wasn't recognizing it as a currency or number and wouldn't move it into the currency field. So, I thought I'd create a text field to import it into, then create a formula field to make it what I need it to be, but it won't import it into a text file either.Not sure why this is so difficult for me.  Any ideas welcome. Thanks again.

Hello all, I created a form, and one of the field values needs to be "1" as the default value. However, I need that hidden so that when someone goes to submit data, they don't have to fill that field in as "1".Now this is what I have:I tried hiding this field from the form options listed, but when I go to submit this form - it doesn't display a "1" in the field value on the table view. I also tried this method on the table view:When I go to create a record on the table view - it does default the value to "1", but on form submission - it does not. Any idea what it is that I'm doing wrong?Thanks. 

Any way to clear all records or delete a table through script?This don't work:do{let table = base.tables.pop();console.log(`Goodbye, ${table.name}!`);}while(base.tables.length>0) 

Trying to create a form I click “add a field to this table” I see under “Single line text” (type of field the words “A single line of text. You can optionally prefill each new cell with a default value.” see attached that’s what I want to do but can’t figure out how to actually do that? TIA for any ideas here…

Our team uses airtable to track orders and get through a large list of records each day. I have a view setup that removes a record when a box is checked (completed) so we only see what's left to work on. Our records are grouped by client and some clients have multiple records. Due to the filter, as you click the checkbox on 1 record it disappears from the list which only allows you to click one at a time. Any solution you could think of to select all the records in one grouping and bulk edit them to "checked"?

I have 1 large airtable with jobs that I sync to airtable bases of clients in the same workspace.Now they should not be able to edit these jobs, so that's perfect.However, within that tab I want them to be able to add other jobs they might have, only for their use. How can I do this? I cannot see any way of doing this, and I don't want it to be a two-way sync, as those jobs should only visible for them. Ideally in the same tab as the other non-editable jobs. Is there a workaround?In some other tab they can link jobs to applicants with a linked record. I want that to still be the same job tab, otherwise It would not work well (if I have them make jobs in a different job tab)...Any workaround or creative wizardry?

Have a deal with a company to lower their costs on segments and get a cut per segment. The commission is based on costs cut which vary by segment. As I’m working through them one by one, the commission start dates are different per account.How can I set up a system that will take a commission start date and make a new record for every month from start date up until current month.Would like for this to work retroactively, meaning if the date was April 2024 it should automatically create records from April up until today, and a new record per segment for every future month automatically. 

Hi all, I am importing JSON into Airtable and parsing it into fields using REG_EXTRACT.Some of the JSON data are blocks of text that have "\n" (without the quotes) in place of carriage returns. Airtable treats the \n as text rather than carriage returns in the output of the REG_EXTRACT function.How can I replace the \n text characters with actual carriage returns?

Hello all!I’m working with an interface in Airtable where each record has a side panel that opens when I click on it, showing more information related to that record. When I click the link button at the top-right corner of the panel, I get a unique URL that directs me to that record with the side panel already opened, were I to paste it into a new window or share with a colleague.For example, each record has a unique detail parameter in the URL that seems to encode both the record ID and other information. I’ve tried creating a formula to dynamically generate these URLs based on the RECORD_ID(), but I can't figure out how to replicate the exact structure of the detail parameter that opens the side panel view for each record. I've used AI to try and help, but the best solution proposed so far is manually entering each URL into the field.... Not happening. My goal is to create a button (or use a formula) that I can put in another interface page, using the

I’d like to show a single calculated column of data (field 2) in an embedded table without the primary field (field 1). I recognise that I can’t hide the primary field within Airtable - but in the iframe code? Is there any way via: html creating a linked table and embedding that some other solution? Help please!

Hey can someone tell me why I keep getting a error I tried so many different ways that I know but i seem to can't figure It out😩

Here is a link to a quick video...how do I import from a .csv file and route certain fields to certain tables, and maintain the links and relationships?It seems like I have to import to each table separately, and then somehow re-link after the imports?What is best practice for doing this?https://share.zight.com/kpuvqg4q

Dear Community,i am new in the Airtable Universe and try to achieve the following:I have a Set of around 45 columns that i would like to export to a CSV - also with individual delimeter, i need semicolon instead of comma for example.I use a view to reduce the fields to the set i need.If possible i would want to do this via automation / script etc.I would not like to buy any additional programm or tool here, i seek your knowledge of how to script this or maybe with regular automations doable?Thank you for all input possible on this 🙂Have a great evening.BrChris

Hi there,we want to use Airtable Interfaces on Android phones in our field operations. The main challenge I'm encountering:When making edits to a barcode field (scanning a barcode or typing something), these edits seem to exist on the local phone only. They show on that phone in different Interface-views. However, the edits cannot be seen on a different device and are gone when the app is closed and re-opened. Hence, I believe the edits to a barcode-field on Interfaces on Android are never uploaded to the base. We've tried this on different Android-devices and always encounter this problem.Any recommendations on how to solve this would be much appreciated!

I’m currently creating an order form that will populate in the a table. I’ve noticed that if I make a typo in the field name on the form view, the typo will stay on the table view even when it is corrected on the form view. Is there a way to avoid fixing errors twice? This also happens if I enter a field on the table view and change the name on the form view. They end up not matching up. This may be user error but some guidance would be appreciated.

Hey, I’ve set-up a rather long form, and I’d like to divide it and give an explanation in that division. For instance, a section header: “Tell us about yourself” and then a short paragraph below: The next few questions ask about your name and your job. Fill them in for yourself and anyone in your group who is coming. The form gives space for four people and another spot to add even more if needed. Once you’ve given the names of all the people in your group, skip to “Your Preferences” below. Is there a way to do something like this?

Hello Airtable people!I am trying to use the Rest API through a python script to create a subcategories table with a multipleRecordLinks field that links to a category table. I am having the toughest time trying to create this field and decipher the error messages I am getting. I am hoping someone on this community can help me.My first attempt looked something like this:{"description": "A list of all of the subcategories","fields": [{"name": "Category","options": {"linkedTableId": "tblPyvCqwd50kh7P2","inverseLinkFieldId": "flduKctYyZ1ckgVxR","isReversed": false,"prefersSingleRecordLink" : true},"type": "multipleRecordLinks"},{"description": "Name of the subcategory","name": "Subcategory Name","type": "singleLineText"},{"name": "Display Color","type": "singleLineText"}],"name": "SubCategories"}And I get this error m

Hello, i’d read all discussions here to resolve my issue and nothing work, how i can get it done with this discussion :slightly_smiling_face: for this i created two tables, one contain survey results and the second contain users entries, they add their profil and based on automation airable add via the linked field all similar profil, until this point all is good. For one of the survey questions, i asked people for main daily missions they do (multiple select field), when i check the lookup or rollup field that get missions data from all result i see many missions many times, i would like to have unique values but seems impossible, i tried all tips that i found here :confused: any advice please ?

When you are exporting an attachment value from the API the JSON object has multiple properties: url, width, height, etc. We have made it possible to distill the JSON down on our platform, https://www.csvgetter.com.This means, if you'd like just want image URLs in an Airtable CSV export, you can do it quite easily now. Check out this brief video demo of how it works:https://youtu.be/4IvIj0ir-BY 

I've seen this question, but not the type of answer I'm hoping for. A CURL example is a great for me to translate the request. Similar to the CURL examples in the docs for List Records, it looks like I should be able to request records 101-200 using the offset value returned in the original request. The docs say it's a Query, therefore: ...?offset=itrvDOnB9cbRDnn63/rec1VA0JPORC2S9Zz It's not working. I haven't inspected the returned headers yet. So the questions:-- should the request be RAW or POST?--should/could the request be a JSON payload instead of querystring params? I need to retrieve thousands of records. My follow up question for data from a different table, USING JSON Payloads can I somehow filter fields? There are many fields I really don't want to process on my end.Thanks,ScottIDS PS: I plan on using POSTMAN for testing.