Solved

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!

I have an automation that I need to count all records that meet a certain criteria. The number of records that meet this criteria exceeds 100, so the find records tool isn’t useful. There is a scripting block in the automation and I would like to count them there, but I’m not seeing an easy way to do this. I only need the step to return the count of records that meet the criteria, not the actual records themselves. Has anybody done something similar? Ideally I could make a view with the criteria filtered and then have the scripting step return the number of records in the view, but I don’t see any documentation for a function to fetch record count within a view in the API docs. Also don’t see a way to use selectRecordsAsync with an offset to capture all records that meet a criteria instead of just the 100 allowed by the function as it currently exists. Any thoughts?

Hi, I’m designing a database to help manage my client base. I created a main table (let’s call it Table A), for the clients and other tables (table B, table C) for data that I measure over time. I need to make calculations (result = table B/Table C), but only with the last data entered in those tables (B and C). Is there a way to get only the last data entered for a given client?

I am eager to know which file format are supported in attachment field of Airtable? can i upload PHP file in attachment field?

Hi all! Not sure if anyone can answer my question here, but I’m a bit concerned about the updates to the Attachment URLs, and I wanted to make sure my team won’t be impacted. One of our use-cases for Airtable is to gather lists of users via an external submission through a form in Airtable. As I understand it, this change will only impact/expire the URL itself, and not the actual file, which will persist in our Airtable database. Can anyone confirm that it’s only the URL that will be expired? Thanks in advance!

I have events that are multiple hours long, and when I put a start and end date/time the calendar creates 2 events for one hour at the start and end of the event. For example, an event that goes from 7om - 9pm has a one hour long event from 7pm - 8pm and a one hour event from 9pm - 10pm. Is there a way to make the event a multiple hour block for the duration rather than 2, one hour events?

I have seen several posts with different solutions on how to sync the bases two ways, but none really to fit what I hope to do. So I have this one base where our leasing officers are tracking our lease-ups with one “Status” field used to track the Status of the process. One of the status is “W9 Review”. I created a special view where it is synced to another base where our Property Owner Data Manager will review the W9 and mark approval or denial. [I want it to be another base because our Data Manager has other unrelated tasks on their base that I want to keep separate from the other department] So I synced the base to the other table and added another field where they can mark approve or deny and also an attachment field where they can put in a form or document. I want these two additional fields to be then sync back to the other base upon approval, update the original base Status from “W9 Review” to “W9 Approved” based off of the trigger/automation/script set by the approval status o

Hey everyone! I had help with a formula not too long ago, and I’ve simply tweaked it to apply to other tables… but as of now, I’m not getting the results I need. Here’s the formula: IF( {Date}, IF( Date > TODAY(), IF( DATETIME_DIFF(Date, TODAY(), "days") <= 30, "30 days", "1 month", IF( DATETIME_DIFF({Date}, TODAY(), "days") <= 180, "180 days", "6 months" ) ), "Send 6 month status check email" ), "Send 30 day status check email" ) Every status is showing as “Send 6 month status check email” even if it’s within 30-days. Help? And can anyone offer resources for the clueless when it comes to building formulas (outside of the Airtable cheat sheet)? I would definitely appreciate the help.