Other Questions

I have a Google Form that is pulling records into a table using automation. Once we’ve reached out to those people, we archive them with a checkbox. However, it’s gotten to the point where it’s hard to sort through the archived and ones we still need to contact. I’m using a script to create an automation where once the archived checkbox is checked, the record will be deleted off the existing table and moved to an “archive” table. My problem is that it’s throwing an error code for any field that has preset answers (multiple select or dropdown). I am still new to Airtable scripting so I’m struggling! ERROR CODE: Error: Field “Who are you interested in booking an appointment with?” cannot accept the provided value. at main on line 6 CODE: let table1 = base.getTable(“Referral Calls copy”); let table2 = base.getTable(“Archive”); let result = await table1.selectRecordsAsync(); for (let record of result.records) { if (record.getCellValue(“Archived”)) { await table2.createRecordsAsync([ { fiel

I manage a dataset with each row representing dates and several columns with times. In this dataset, I really don’t need ‘dates’ in the field but have to use ‘date’ format. Is there a format or formula or anything else that I don’t need to enter date every time?

Hi guys! I looked through several threads that were also trying to find COUNTIF workarounds, but none really matched the use case I have, so I’m hoping to find some help. We use Airtable to manage a large editorial team and content calendar. We have our main editorial table with our content roadmap and weekly assignments. My colleague who manages our freelance writer network has created a separate table with information about all of our freelancers including their names, contact info, assignment capacity, area of expertise, etc. She is wanting to find a way to count all active assignments assigned to a particular freelancer and pull that number from our main editorial table into her freelancer table. Is this possible? I can easily find the assignment count of each freelancer within our main editorial board, but can’t figure out a way to get that count to show up on the other table. Right now she is manually counting and putting that number in there as plain text. I’m attaching screensh

I have seen how to hide fields and create personal views and locked views but I did not understand how to make some attributes (columns) of a table visible only to one user. These attributes are not to be seen by other users. For example, with the maintenance table I would like to hide the “expected cost” field from the operators and see it only I who am the owner. Can you help me please Thank you very much

I’m trying to see if there is an ability to lock a task/table for individuals. Basically, we are providing courses and the next levels (with the content) need to be locked until they’ve completed courses/tasks…

Hello, I have text that I would like to paste text into a table. I’d like each line of text to get split across two columns. I know that I could probably get to this to work with a CSV import but I’m wondering if there’s a way to get the result I want with copy/paste. Here’s an example of the text I would be pasting: Line 1, Another boring day in the ocean. Line 3, Another boring day in the ocean, SIR! Here’s how I would like it to appear in a table: Here’s how it actually appears in a table when I paste it: I would either like the paste function to recognize the , and split the text into two cells at the comma (like a CSV import would do). Or I would like to paste the text then highlight column A and split the text at the comma into two columns. Are either of these things possible?

Hello everybody. I’m getting the Max value from a field which links to some records, then I’m adding to the link to increment it for the next time I need the MAX. Is there a limit on how many records I can link from 1 field? Thanks.

I created a test account to explore airtable functionality. We might need to publish our own application on airtable marketplace. But I cannot install any application from the marketplace. I click “Install” button on an app (e.g. - this one https://airtable.com/marketplace/blkt8D4LiDFZ1SCop/sendgrid) and nothing happens why is this?

Hi! I have table: integer - text - date I want view with group by text+date and average(integer) In grid view I see count(records) In Martix app and Pivot app - summarization by one field only. In excel/spreadsheet I can do it easily in pivot report. Could you advise way to create such view here?

Hey guys. I have an integration between Typeform and Airtable, I’m using Zapier to do that. BUT whenever a new record is created in Airtable, this record appears duplicated but without the field that I named as “Interaction ID” and with a different Record ID. PS: If I run a test in Zapier, the record appears with no duplication. Any ideas?

Hello everyone, I was wondeing if there was anything like a heatmap app where i can see what time of the day/week is the most popular order times, please see my screenshot for extra clarification (this was taken from google analytics). Many thanks! Matt

Hi Airtable Community! I have a problem I’m sure some of you have already solved. I’m collecting monthly data for specific metrics (example: Revenue) I’m capturing three data elements in one record - Actual, Budget, and Previous Year. When I try to create visualizations for this in the Chart app, because of the way I’m capturing the data I can’t get the visualization I’m looking for. I would like to see three vertical (or horizontal bars) for for each of the data points in the record (Actual, Budget, Previous Year). I’m thinking Veg-Lite might be the answer but have never used it. Really appreciate any feedback and ideas. I’m also open to other ideas on how to better capture this data from end users, there may be a better way to capture these elements that would lend to better visualizations. I added all three data fields to one record to make it easier for the end users to submit updates. Thank you all. Travis

Hi—I’m new to Airtable, and have a free account for now. I’m working with a cowriter on a detailed outline for a musical. My cowriter has a Pro Plan. If I also get a Pro Plan, can we collaborate on the same base without either of us being charged a collaboration fee beyond the $20/month standard fee? If not, is there any plan that would allow us to both make changes to the same base without being charged a base-specific collaboration fee? Thanks—Peter

Hi all, So today I wanted to get a “Mark Duplicate” script up and running on a base. Turns out its one of the featured examples. So I copied the code, adjusted it for my base and hit test and it didn’t work. The error reporting is rubbish - so I have no idea what went wrong and logging variables doesn’t work. This is the second time in 3 months I have tried to use the scripts block. I can’t say I am enjoying it, its slow and has no failure message (primitive stack trace) So my question is - how are others working with this productively. Because at the moment this absolutely sucks and I’d be better off using zaps.

Hello everybody. As the title says, I’m generating receipts with Airtable and I’m looking for a solution to generate a unique number for each one. I was looking at automation to maybe grab the last record and on the receipts # field do a +1, but I think this could be simpler with autonumber. Greatly appreciate your input.

User AISYAH_AMBOK asked the same thing some months ago, and even provided a great example. The third field in this table, with the issue pointed out with the ‘CROSS MONTH’: Can anyone here figure out how to make this work? And if possible make it work so it will list every month (and not just the first two) included in the range. e.g. if the range started 9 workdays before the end of January, and five workdays into april.: jan 2020, 9 - feb 2020, 21 - mar 2020, 22 - april 2020, 5 Obviously all the holidays of the year would have to be added to the formula to have a correct tally. This would make or break my use of Airtable on one project, so I really hope someone can figure this out.

Please assist me in Managing users with rights.

Hin Guys ! I’m using the Batch Update to sort the linked records but the are not sorting by date … any idea what could be the problem ? Thanks !!

Dear sirs, In our company we are considering to use Airtable pro. But a question emerged. We can have non payed users accessing via forms or kanban modes and giving inputs. Or will they be considered payed users? The use case is the following, we are onboarding partners and organisations and we will establish a simple CRM to schedule our work. Some users will engage with the forms to get assignments and progress the leads. But the cost will not scale if they are payed users. thanks in advance, Paulo

Hello! Im an airtable newbie with very light coding experience. Having several challenges setting up the bases for my team, but there’s one in particular that I cant seem to figure out. I’ve created an automation that triggers record B to be created on table B whenever a new record (record A) enters the view on table A. Table B’s purpose is to aggregate information from table A and table C and provide a top level view of many different scheduled communications. The problem that I have now, however, is that whenever there are updates to record A or C—like a date change, for example—the updates arent passed along to record B. I tried to create an automation triggered when record A is updated, but am unable to link it to record B. Are any of the below possible through a script or automation? 1- when record A is updated, the now outdated, record B is deleted and a new, updated, record B is created 2- when record A is updated a new record B is created, script runs to remove older record by

Hey there, We’re missing some records that we have created in airtable and exported as csv. These records had image attachments and those urls to the images still work but we cannot find the records anywhere on our tables. Any suggestion/recommendation? not sure what has happened here… We’ve looked in trash and history but no indication of removing those records.

Hello everyone, I have a base with information about individuals (i.e. Date of birth / death etc.) and I would like to configure a field that would let me know if any of these individuals were born or died or published something significant on a specific day I am logging on the base (“today”). Is there a way to configure this? Thank you in advance for any assistance!

Buenas tardes. Deseo hacer una aplicacion con airtable donde varios colaboradores lean informacion con sus dispositivos moviles pero cada vez que ellos ingresen informacion a la tabla en un campo quede identificado el celular desde donde se completo la informacion. Como se puede saber desde donde salio en forma automatica y sin necesidad de que el operador se identifique. Gracias

After sending a batch of emails through the SendGrid block, I can’t find a way to view the sent emails after the fact. There appears to be no record of the emails I sent. Even if I want to bcc myself so that I have a record, I cannot easily do that since the cc and bcc options only let you select fields in the table. How do you suggest I log the emails sent to contacts in my table?

Hi I am trying to add records to a new table by from another table of linked records. Will eventually automate when original table is updated with new but have tons to transfer over. I want the same record to be linked to each other in each table. Copy and paste will take too long. Any ideas welcome. Thank you, Maria