Solved

I have a multi-select field that has a large number of choices. I have decided it would be better to separate them into different categories (fields). Is there a way to do this? I have a master list of choices in a separate table (if that helps). These choices have a name and a description and a category. Is it possible to do something like this: Category 1 Field Look at the main select fields and find all choices. Look at the master choice list and find the choice name that matches the category. Place the choice that matches the field category into the field. I am on a free plan and have no access to paid tools. Example base for explanation purposes: Airtable Example Base - Airtable Explore the "Example Base" base on Airtable.

I signed into a collaborator’s account today and noticed that my personal views can be seen. This is not normal, right? See photo below. I checked my account to see if I could see the collaborator’s personal views on my account and I cannot. Hope this issue can be resolved quickly. Airtable Support Personal views Personal views are a special view configuration type that allows collaborators with creator, editor, or commenter permissions to create views that can only be customized by the view's current owner...

I have an open-access data collection form that my members can fill in. Members are in different organisations with their own email domain. I want to be able to restrict views of the results by domain so that people can only see the responses from others in their organisation - which Airtable lets me do via the restrictions options built in to the view. So I created a View, gave it the name of the company in question and restricted the view by domain. However when somebody is invited to collaborate on the base they just see everything in the table/view and the view itself isn’t restricted by domain - I think the difference between being invited as a full base collaborator (with commenter permissions) and simply having a link to a view without being invited to to the base. I believe I need these members to be collaborators, as opposed to simply being sent a link. If they only had a link to a restricted view they wouldn’t (necessarily) have an Airtable account and the domain-restricted

Hello, I’m relatively new to Airtable, so I have a question if something I’m doing can be improved: I have a base where I am counting the number of checked boxes (so far so good) However, I will create a large number of bases where the task name varies and won’t be a simple Task1 etc. Is there a way to count the no. of checked boxes without referencing the Task1, but something along the lines of referencing the cells (like in excel) This way I can just duplicate the base and change the “task” name for each base as needed, without needing to change the formula all the time. But the formula would work regardless of what the task name is. Thanks!

I have set up and automation to email a client when their job is marked as done, and it is working. However, I just want to make it more intuitive if possible. Currently - When marked as done and there is an email in the ‘client email’ field there is an email generated, in the email I reference job title, notes etc (all pulled from data in the table) I would like - 2 emails set up, email ‘a’ gets sent if there is a url in the url field filled in the job. email ‘b’ gets sent if there is NOT a url in the url field in the job data. Hopefully I am explaining that correctly. So I know how to do the automation, I have one working well, I just want some more detail and not sure how to add the additional conditions, or if I need two automations set up and only the one matching the specific condition would be triggered.

Good morning, I’m discovering the automations, with sending an email when a record matches a defined condition - so far so good. But the little problem (or limit I should say) is that I have multiple tables with many entries, and I’d like to add some details to the email sent: at least the table / base name, and ideally some way to identify the concerned record, with for example the first or second column value. Do you think it’s possible, please ? Thanks in advance for your help, Regards. Nicolas Caplat

Hello, I’m starting on airtable and I can’t find the right formula to perform an operation. I would like to extract the link in the second column IMAGE to insert it at the planned location in the third column JSON. Can someone help me with this ? Thank you :slightly_smiling_face:

Yesterday was the first time in over two years I experienced a bug in Airtable. Data in 3 columns has inexplicably disappeared. The data is all intergers. The summations at the bottom of the columns is still correct I just cannot view the data anymore. Any thought on recovering my data, I think it must be still thereI just am unable to view it. all other columns about 20 of them appear to be working fine. thanks

Hello :slightly_smiling_face: I have created two tables, one with projects and one with tasks which link to the projects. In the projects table I have the tasks shown as well, but I’d like the tasks to show up as “Task1✅”, “Task2❌” - depending on completed or not, which will be determined in the task table. I know I can’t override a linked column, but I wanna know how I can adjust the formula in the tasks table, if I want the Task name to update according to the checkbox done/not done. I tried various formulas from a past thread (IF({Completed}, “ :heavy_check_mark: ”, “ :x: ”) & " " & {Name}) but they never seemed to work… Anyone got an idea? :slightly_smiling_face:

Hello everyone! I have recently experienced this error with my automations is this something to do with gmail? It has been going on since today at 8:27 am (EST). Does anyone know anything about this?

I am working on the intake of roster information for Wildfire Firefighters. We have availability beginning and end dates that we could see might need to be changed. I would like to allow an individual to make a change to just their information after they have submitted an intake form. Submitted info goes into a grid view that will be displayed on a pw protected site for high ranking logistics officers to access. One option is to have someone submit their changes via a change request form. The change would be sent to an admin and they would update that. But I’m looking for a way for someone to control their own info without the use of an admin in the middle. Thoughts?

Notice: I am on a free plan and do not have access to any paid tools by Airtable or another company. I am trying to export airtable data in a csv. The place I am importing to cannot recognize “drop down” menu options. I need to extract about 100 dropdown menu options* and format them thusly in a “text” field ["value1", "value2"] *When I mention options I am talking about all the options in the dropdown menu, not just the ones selected and displayed. I don’t know if this is possible, but if anyone knows a workaround that would be awesome. It would save me the hassle of having to type them all out with that formatting. :dizzy_face:

Automation is setup too append a row to a Google Sheet. All of the values (text, dates) will populate within the sheet row, except for the numerical score values when the automation is running. However, if I run test automation with the same record, the numeric value will populate into the column. The scoring numeric values in AirTable are single select based on automated triggers to specify to a certain score. I have tried changing the column data format on the google sheet with no success. I have tried to change the triggers as well as adjusting the value lookup but still will not work unless I run a manual test. Any ideas on what I maybe missing?

Hi there :slightly_smiling_face: I’m trying to batch update a date field in a specific view. The new dates are coming from a formula field (I’ve assumed the output of the formula field in the scripting app is a date because it’s formatted as such in the table). It runs with no errors but the dates aren’t actually being updated in the table and I’m not sure why. If anyone can pick up from my code why it isn’t updating, I would really appreciate it.

So I have a multi-select field that has about 50 or so options. I want to take those options and surround them with quotation marks, separated by a comma. I tried using the SUBSTITUTE, but I couldn’t get it to work the way I wanted without duplicating the field a few times. I did something similar to below, but now I have three extra columns in my table…heh. SUBSTITUTE({Calculation},", ",",\\"") I am wanting to take this: and turn it into this: [“Pet Doll”,“Chubby”,“Child”,“Wings”,“Horns”,“Round Face”,“Pointed Ears”] Complete with brackets on each end. How would I go about doing this? I don’t know if scripting will work because I’m trying to import my airtable into another service and in order for those choices to be recognized as tags, they have to be formatted as you see above. So the field has to have that data in it. I have hundreds and hundreds of rows, so doing it by hand is not an option.

Hi, I was wondering: Do all scripting apps count against my app limit of my plan? For example in Pro Plan => 10 apps per base So when I have 10 scripting blocks inside one base I am already on the limit? If so, does the fact, that there are 2 paying users change this limit to 20? Help / Feedback really appreciated. Thanks in advance Onur

I want to send a message to a Slack channel based on the message in an airtable cell. And I want it to trigger when its the date in another column. I can’t seem to find an automation in Airtable or Zapier that triggers on a certain date, just at regular intervals (daily, weekly, etc) Any help would be appreciated! Thank you

I have a single select field, and a rollup field which contains a formula that references the single select field. Now I remove 1 option from the single select field. The formula of the rollup field is now broken because it references this deleted select option. Airtable did not stop me from removing that select option (although it warned me about the dangers of me deleting the option). Airtable does show that the rollup formula is now broken by adding a red indicator to the field. The problem I have is that the two fields where in different tables, so it took me quite some time before I noticed the problem. So here comes the question: is there a way to get a list of broken fields in a base? Either through the web UI or through the Airtable API? That way, I could query this once in a while to verify nothing is broken.

Hi Community, I’m having trouble creating a nested if statement, where the condition is to identify two options from the field “Financial End Year Date” (single select field), and return two different values (for ‘December 31’ data - return ‘8/15/2022’, and for ‘March 31’ data - return ‘11/15/2022’, and if neither, return ‘4/30/2022’. The nested if formula I created and tried is as below: IF({Financial End Year Date}=“December 31”,“8/15”&"/"&YEAR(NOW()),{Financial End Year Date}=“March 31”,“11/15”&"/"&YEAR(NOW()),“4/30”&"/"&YEAR(NOW())) When I run this formula, the field shows either “8/15/2022” or “true”, where the “true” should instead be “11/15/2022”. For the ‘neither’ options, it returns a blank cell. What’s more confusing is, after I save the formula and click the configuration again, the formula is automatically corrected to below: IF({Financial End Year Date}=“December 31”,“8/15”&"/"&YEAR(NOW()),{Financial End Year Date}=“March 31”) Could anyo

I have three separate filters set up on record view, however they don’t seem to be working correctly. In the attached, I’ve set the Estimators filter to display results for records that have no Estimator assigned. However, records with Estimators are still being displayed. I presume the Type filter (second filter) is taking precedence over the Estimators filter? All three filters are set as the default ‘Where’ action; it doesn’t give me the option to change this, only add additional conditions to each. Any help appreciated, TIA!

Hi there :slightly_smiling_face: I’m new to coding and Airtable and I need some assistance. My script is to update a record with user input. The issue I’m running into is in line 7. The script runs but I’m assuming it is this error that stops it from actually updating the cell. I understand the error but I’m just not sure how to remedy it. I’d also like to know how to output the new_date variable within the text output line above it.

In my base , I have contract end date column and status column which many values such as active, progress, inactive, done, started, not started yet. when status changed from only these active, progress, started to done contract date should fill-up automatically. Is this possible. If so, please help me.

Hi everyone ! Here is my problem: I have a table that consists of two columns → 1: Company // 2: Company logo. On another table, I upload company information like name, location, revenue, etc (about 1000 records for each upload). The thing I would like to do is tell Airtable to upload a logo to the 2nd table opposite the company name as I could have done in Excel with a Vlookup function. The problem is that on Airtable, before doing a Vlookup function, I have to link to another record, which takes a lot of time as I have to do it for each record… Can someone help me? :slightly_smiling_face:

hello, i am trying to do some basic count using formula (i think its basic). there are 5 columns (named “name”,“rozmer1_cm”,“rozmer2_cm”,rozmer3_cm" and “vaha_kg”) what i want to do is formula, which will get those results: if all “rozmerX” < 50 and vaha_kg * 1000 <250, than its “M1” have found it to make it this way: which is working fine. BUT than i need to do if all “rozmerX” < 50 and vaha_kg * 1000 >250 and <=500, than its “M2” there are many other conditions, but i cannot go over the condition “vaha_kg*1000 >250 and <=500” have read the basics of formula, but i cannot apply it to my case (i know, its stupid). Thanks for kicking in right direction :slightly_smiling_face:

Hello Community! I have the below script that will create X number of records based on the Episode Count, but I would like to tweak it to auto-number those episodes each time. For instance, Show 1 has 5 episodes, then each episode record would be numbered 1, 2, 3, 4, 5 //Tables let projects = base.getTable('Shows'); let episodes = base.getTable('Episodes'); //Record Input let record = await input.recordAsync('Please select a project', projects); //Record variables let quantity = record.getCellValue('Ep Count'); let order = record.id; //New record array let recArray = []; //Iterate by quantity if(quantity > 1){ for(let i=0; i < quantity; i++){ //Push to the array recArray.push({ fields: { 'Shows': [{id: order}], } }); } //Create new records await episodes.createRecordsAsync(recArray); } Any insight would be so incredible appreciated :pray: Thank you!