Solved

Hi, can I get a blank space/nothing instead of “0” as the result of a formula ?

Hi there, Lets say I have four fields: A B C D I would like to create a single formula field that could show which of the above fields are blank. So, for example: If only A is blank, the field should say “Field A is blank” If A and B are blank, the field should say “Field A and B are blank” And so on … I have been able to create a formula that tracks whether all the fields are blank, but I am struggling to find a way to use the formula field to display which specific fields are blank. If anyone has any advice, that would be much much appreciated!

Please could somebody help me troubleshoot this formula? I’m building a financial forecast and have a number of new business opportunities to build in. Not all opportunities have the same probability of converting into a sale however so I need to create a weighted value for each opportunity to give me a more realistic view of what my pipeline value is. The calculation needs to be Contract Value x Probability = Weighted Value, however I’m struggling to work out how I incorporate the multiple options into my formula. I have 6 probability options in total: 100% 75% 50% 30% 10% Lost (0%) If anyone could offer some advice, that would be much appreciated! Thank you.

Hello, I’m new to Airtable & I have a formula that an Airtable support doc says should work & I can get to work in Excel, but keeps returning an error in my Airtable base. What I want to accomplish is this: IF the Jan 22 Commission Field is not blank, Jan 22 Prof Calc should equal that. Otherwise, IF Jan 22 Actual is blank, Jan Prof Calc should equal zero. IF it’s not blank, Jan 22 Prof Calc should equal Jan 22 Remaining. Thanks in advance!

Is there a way to password protect a base so that when it’s opened (even by me) it requests a password before showing any information? I’m attempting to make a base to store ALL passwords. Personal and Business. However I do not want anyone who may get access to my computer to be able to pull up the base without a password. Thanks

Hai, I want to know how to record person with Forms View because I was restrict forms with my company domain, but still not recorded. This result of user input on Forms View

Is there an easy way of creating a column (field) in Airtable that includes consecutive dates (ie. each record shows the next date on from the record before)? The only way I find I can do this is to manually insert each date. Another way would be to select two of the dates and drag down or up through empty records (a la a spreadsheet). But unlike Apple Numbers you cannot create new records as you drag. Therefore you have to pre-create the empty records. The problem is that the empty records are not adjacent to the most recent date (and I want to add dates after the most recent date). The empty records always appear at the other end of the list of records. I assume I am missing something basic? Thanks

Hi - I’m trying to rollup a look up date field to find the earliest date but all I’m getting are values of ‘0’. Here’s how I’m set up: Table A: Contains a list of events per location. For example, Location A on 1/1/2022, Location A on 1/2/2022, and so on where each location + event date is a unique row. I also created a formula field (Formatted Event Date) for the event date: DATETIME_FORMAT({Event Date},‘M/D/YYYY’) Table B: Contains a list of locations and a lookup on Table A for Formatted Event Date. I tried creating a rollup on Table A for Formatted Event Date using MIN(Values) but it’s returning all ‘0’. Is there a better way to rollup dates so that it’s formatted correctly??

Hi there! I have a “Campaigns” table and a “Schedule” table within the same base. My “Schedule” records are all linked to a campaign in my “Campaigns” table, for example: I have a “Product Launch” campaign in my “Campaigns” table, and in my “Schedule” table I have a record for a Product Launch email, Product Launch social post and Product Launch display ad. Every record in my “Schedule” table has an attachment to go along with it (creative/artwork). I would like for the attachments I add to a record in “Schedule” table to automatically duplicate into the “Campaigns” table, under the appropriate (linked) campaign. Using the same example as above, I would like my Product Launch email, social post and display ad attachments to automatically populate in the attachments field for the Product Launch record in my “Campaigns” table. Would I set this up as an automation? I know the answer has got to be right in front of me, just having a total mental block :slightly_smiling_face: Thanks in ad

Hello, Airtablers. I have a question regarding using the ‘Data Fetcher’ app to pull in data via API to a table and then updating that data. Basically, when I run the call it brings back the information on ~157 products in the database. We use this data to then sync into Webflow to populate an ecommerce menu. The challenge we have is that the products we have change fairly frequently and we’d like for the product to not show up when it’s no longer available. In Airtable, how could we get records in Airtable to be removed when an updated API call runs and those specific records are no longer returned (because they aren’t available). Any seeds of ideas greatly appreciated.

Hi everyone! Is there a formula to count the number of records were added per quarter/year/month? I would like to know how many were added in general and how many records were added during a specific period by category.

Hi everyone. I am currently using the Slack automation to notify me when a record has been added or updated. Is there a way to include the name of who updated the record last in this notification.

Hi, is Airtable able to do Finish to Start formulas that autofill dates similar to smartsheets? I’d love to have a sheet with the tasks and deadlines are autofilled based on the formula for how many days from Go-Live, so all I would enter is the Go-Live date and all tasks are automatically filled. Is this possible in Airtable?

Hai, can anyone help me to write formula but based on single select column. If single select = Kg will be multiply 1 ( * 1) then If single select = Box will be multiply 5 (* 5) and then if single select = 200 gram will be divide 5 (/ 5)

Hi, I have an automation that is designed to create multiple records from a single row in another table. All but one of the fields will be identical, so I’d like to be able to copy my action step and just adjust the one field that I need to, but I can’t see a way of doing this. Is it possible? Thanks in advance.

I’ve used Airtable before, but never set up my own base before, so pretty new to this. I have two tables Students Daily Submissions Students is a fixed list of enrolled students that is linked to Daily Submissions Daily Submissions is fed by a form that collects a student (selected from a menu from Students), a link, and a description. When someone submits a form, it also collects Created Time in a field called timestamp. In Students, I want to create a field called Most Recent Share that will display the date of the most recent Daily Submission for each student. After reading Rollup field overview and topics including Formula to calculate the latest Date in an array and Roll up max date but show another field I tried creating a Rollup that collects ARRAYUNIQUE(values), which showed nothing, and MAX(ARRAYUNIQUE(values)), which showed a column of zeroes But I don’t know which of those is correct, or what the Formula (or is it Lookup?) in the Most Recent Share field should be, and h

Hi, I’ve set up a scheduled automation to send me an email reminder everyday for open tickets that I need to resolve. The thing is that I’d like to configure this automation to only be triggered if there are open tickets in the first place, i.e. if the count of open tickets > 0 or if one of the views in my table “Open tickets” has any records in it. I don’t want to keep receiving an email daily that says “You have 0 open tickets”. How can I set the Scheduled automation to only run based on a condition? Is this even possible? Any help would be much appreciated. Thank you.

Hi! Having some issues with an automation. In summary: 2 tables: Customer ‘Orders’ table Customer ‘Leads’ table Automation: Step 1 (Trigger) : New record is added to Orders. Step 2 (Action): Find record in ‘Leads’ that has a matching email address (as the record in Step 1). Step 3 (Update): In ‘Leads’, update a field in the record found in Step 2. Outcome: When a matching email address is found, everything works as expected :slightly_smiling_face: However, when there is no match found: Step 2 reports ‘Step Successful’, but returns 0 records found (this is as I would expect) Step 3 throws a ‘Received invalid inputs’ error. I would expect Step 3 to not run at all, if Step 2 doesn’t find any matching records. So I guess the question is, is there conditional logic built into automations that does something like the following: If Step 2 finds record, go to step 3 If Step 2 doesn’t find record, stop. Any help appreciated!

Hey all, In the new automations dashboard, is it possible to add a conditional action - one that only runs if a condition is met. My use case is that I’m trying to create a 2-way sync with a Google calendar. If I create an event in Google Calendar, I want it to first search my base by event ID to see if it already exists. If it does not, then I want it to create a new record. If it does, then I want it to update any fields that have changed in Google. I may be going about this all wrong. Any suggestions? Thanks! Joel

Hi guys I hope some of you scripting geniuses can help me. I have a button In a task list and want to add a button to add a new row in that list under that project instead of clicking the “plus sign” underneath the row. Can someone help me with the script? Sinve I have the button and record picker script we know what row we’re at so to add a row/task shouldn’t be so complicated? But its complicated for me… The script look like this know : // Change this name to use a different table let table = base.getTable(“Tasks”); // Prompt the user to pick a record // If this script is run from a button field, this will use the button’s record instead. let record = await input.recordAsync(‘Select a record to use’, table); if (record) { // Customize this section to handle the selected record // You can use record.getCellValue(“Field name”) to access // cell values from the record output.text(You selected this record: ${record.name}); } else { output.text(‘No record was selected’); } Much appreciate

I’m looking to add “available dates” (pre-defined) into a form for the user to select. Not sure how to go about setting this up. Once the form is submitted, I would like the selected date to fall off the available date list. Also, not sure on how to go about setting this up.

Hello, completely new to Airtable and fairly new on dealing with APIs. I was super excited that I was able to get an API connection to work and successfully pull the data I needed a few weeks ago. Today I went back because I forgot to include two fields in the original pull of the data. I amended my Body JSON query to include these two new fields and when I use the “Open Field Mapping” button in the Data Fetcher app everything actually looks fine (it’s pulling in the new fields). But, when I run the query, I receive the following warning with the yellow exclamation: Can’t update field: invalid field config. Failed schema validation: symbol is not included in the .(type=number).options schema Because I’m fairly new both APIs and Airtable, is someone able to give me a “laymans” explanation of what I can search for to troubleshoot this warning. Interestingly, while I see Airtable successfully pulling in the two new fields (and with the right data populating), when I go to the actu

Hello! I’m trying to edit a script that I already have. To do so, I need to be able to get values from a Link to Another Record. The linked record is on a different table. I’ve been using .getCellValue() for most cases, but it doesn’t seem to be helping me here. Right now, when I run the .getCellValue, it returns an Object, and when I run .getCellValue().values, it outputs “function”. How can I get a specific field off of the linked record?

Hey all! I am trying to set up an automation that will update multiple records using a script. From reading around the forum, I think I’m definitely almost there but need help crossing the finish line. Here’s the breakdown: I have two two tables: one has pieces written by authors, while the other has feedback notes for those pieces. They have a one-to-many relationship: via linked record, several notes can be associated with one story. Each time a new note comes in via submission form, it receives a number via automation. So the first note submitted for a piece has its note # set to “1”, the second to “2”, etc. This is a number field, not multiple select, single select, etc. I’d like to set up another automation that renumbers notes whenever one is flagged for content. So, say that record A has 8 notes linked to it. Note #6 has inappropriate content, so I don’t want it to count towards the tally. I have two of three parts set up. When a note is flagged, it prompts the automation to cha

I have a base I am using for rehearsing a play. I have several tables including a character table, which I linked to the scene table, inputting which characters appear in each scene, finally linking a rehearsal table which has which scenes are being rehearsed on any given day. In the rehearsals table, I am trying to find any characters that will appear in any of the scenes rehearsed that day, without duplicates. I have tried a rollup command and a function command. I have played with ARRAYFLATTEN and ARRAYUNIQUE to no avail. Can anyone help?