Solved

Hey all,I’m getting the dreaded “received invalid inputs” but it’s not specific.I have a form that someone fills out to get a “certificate” number in another table.There’s a specific view for the Non-Assigned certificates. There are two tables, one that stores the form’s data, and another that has a listing of certificate numbers and such. Now I’d set it up as such: Then the Find Records settings:  Not sure what else to do???   

Hello!I created a Project Template base that has various phases and steps with our design process. This base will be duplicated and renamed as new projects come in.I also created a separate Project Dashboard base, to be used to get a birds eye view of all the active projects going on at once.In the Project Template base there’s a table with a name, assignee, and project status fields. This grid view is synced to the Project Dashboard.Once I duplicate the project template base and rename it to the new project, is there a way to pull in the new name of the base into the name field?I didn’t see anywhere in the functions to pull in the base name. I was able to generate the base name using the script extension +  output.text(`${base.name}`);, but I don’t see a way of bringing that information into the name field.Thank you for your help!

Hi Airtable Friends,I need help. Since I couldn’t squeeze all the Product fields I needed to see at-a-glance into the Record View template, I laid them out onto a Blank Canvas. But when I add the List element, it doesn’t display a list of products as would have been the case with the Record View template. Instead, it only allows me to choose from one of the Link to Record fields. If I change the source to “Products”, I see the list of products—but it’s not at all connected to the record view fields. Really hoping some of you  geniuses out there have ideas! Thanks in advance!  

Hi, I want to be able to copy the result in one field into another single-line text file so that I can look it up. The first field is multi-select. All I want to do is convert it into a single-line text field. I need this to look up the text from another table. I need to do this because the first field is already a lookup in this table from yet another, and I need to be able to link some of the details from a third table altogether. I hope this is making sense. I don’t know how else to explain it. Thanks S

See screenshots below - I've used the "find records" option many times, and always restrict it to a specific view.  Only this time, and any time I test the find records action anywhere globally, it suddenly seems to stop at 10 records. The description still lists the limit as 100 records, it just stops at 10.  The view in question has 52 records in it. I've even went so far as to test this on older automations which we've since stopped using (afraid to touch any currently running automations for fear they might stop working properly).I've recreated the automation, refreshed the page, re-sorted/grouped records, but have not been able to work around the issue.Has anyone else ran into this?

Hi community members, I’m setting up an automation that triggers based on the date but running into a problem with getting the values of the record that triggered the automation… To give you context, the main table is "Reservation" and contains all details of the reservation. In it, there is also a linked field "Yacht" which points to another table "Yachts". I have also added 2 lookup fields in Reservations : yacht name and yacht model. I defined the input variables but when I want to output them, the linked fields are empty arrays (see screenshots below). Please advise on how to fix it because I need to pass these values via webhook for further use.  

Here's a question for you all,If you have a check box that asks a question such as [Would you like to add this service?] Where checked is yes. How can I get a formula field to fill with a price result?i.e. IF({New Service}, ….{New Service} Being the checkbox field. What goes next? Thanks in advance.  S 

Hey there--- I seem to not be able to use the same “run script” function anymore, because the record area is missing-- Here is what I’m looking at now: And on my other base, I have one more field that I can set that doesn’t seem to appear anymore:  What am I missing?? 

Hello, I want to know if there is a formula to identify a text within a link cell, in this cell conditions that a home meets appear. Example: unreleased, released, foundation, walls, roof, finishes, finished. I want the formula to identify if the cell evaluated says without releasing the result is UNSTARTED, if it contains released the result is IN PROCESS or if it contains finished, the result is TERMINATED. I have tried with the IF formula, but I have not succeeded. Thank you 

Hello,I am endeavoring to create a social-media post manager/tracker to coordinate reposting of the same centrally-approved content on the same dates by many different agencies for various campaigns.  The first table contains a record for each content item with the posting date(s) assigned, along with the agencies who will need to post; since there may be multiple posting dates, instead of a Date field, I have added a table just for dates to make this a Linked Record selection.  My second table, which has a row for each selectable date, pulls in the content to be posted on each selected date with a lookup for the agencies tied to each. This is intended to be the table that contains views specific to each agency for their own status updates, filtered to show each agency's approved content assignments (via the "Msg Approved by City" checkbox). This is how I would like it to work when the base is put into use.  Note that I tried to use Autonumber for the primary f

I’m working on a voting app, where there are tons of enhancements. There’s a ‘Votes’ field which is of type ‘User.’ Users can add their names to that field in order to vote for that enhancement. This is based on a simple, single table.I want to have an interface page that lists enhancements that have gotten votes, sorted by the number of votes each has gotten. So if I add my name to that Users-type field, the number of votes for that enhancement goes up by one, and the sorted list of enhancements by number of votes gets appropriately updated.I thought I could just do a calculated field with this formula: COUNTALL({Votes})However, that’s giving me a value of one (1) for each record, even though right now most fields have no entries and a few have 2 or three.I’ve only done pretty basic things with Airtable, so I’m hoping there’s a simple way to do this and I just can’t get google to find it for me. Any help you can offer would be appreciated! 

I use Airtable as a logbook for the vehicle (TABLE1). Each row = one trip. I would like to use automation to send myself an email when an oil change is due. So I need to total the miles driven (from TABLE1) and compare that to when the oil change is due, which should be placed in another table (TABLE2).Is it possible to create one record in TAB2 that still shows the current SUM column from TAB1 (same number as in the summary bar)?I don't want to use a rollup that has to be manually updated each time.

I built a project management tool using softr as the UI. I am looking to build an airtable automation that sends and email upon various triggers with the airtable data. The triggers seem to work fine, I am having trouble pulling in the data I need from related records in other tables. The data structure in this example would be:Project Table - has a field containing project members. This field is related to the user table Users table - has individual records for each user and a field in each user record containing all the projects it is associated with Drafts Table - Each record contains the data about a video draft I have built, including the project the draft is related to.The desired automation would detect a new draft record has been created and find the associated project record which contains a field defining the “primary project contact”. Using the ID associated to the primary contact, it would find that user in the “users” table to retrieve that user’s email address . Then send

I need a formula to populate a field based on three other fields - where only one will have data. So in fields 2 - 4 below, only one will have data and I want that to show up in Field 1. Field 1 - formulaField 2 - Lookup from table 1Field 3 - Lookup from table 2Field 4 - Lookup from table 3

I've created a customer appointment confirmation system for our solar installation business and am struggling with a specific issue.Current Setup:We have an Airtable base with appointment records for our customers We send automated emails with links to an Airtable form for appointment confirmationProblem:When customers submit the form, it creates a new record with their feedback instead of updating the original appointment record. This disconnects their response from their appointment data.What I've Tried:Passing the Record ID as a parameter in the form URL Using "prefill_RecordID" to attempt to link back to the original recordQuestion:How can I set up an automation that will:Capture the form submission Find the original appointment record using the Record ID passed in the form Update the original record with the confirmation status Optionally delete the new record created by the formI'm looking for step-by-step instructions on setting up this automation correctly, especially the "Find

Hi,I’m experimenting with the RLP with DNA 2023 Airtable template.  I’m trying to personalize the column headings and can’t figure out how to do what I want after reading the Airtable help.  Can someone please tell me the following?  It's really a general question about copying/pasting a column field from one tab to another.I made a new field called “My Tree” and inserted it on the DNA Match Details tab.  But, now how do I insert that same “My Tree” column on the Kit Access tab?Thanks! 

Hi, I have an automation that triggers on record update. But it triggers whilst I’m still typing instead of once i finish and press enter. Is there a way i can tell it to wait until the user ahs finished entering the data (aka pressed enter) and then run? Thanks in advance :slightly_smiling_face:

Hi there! I have two tables involved in this automation, a Projects table and a Tasks table. Currently my automation is set up so that when a project status changes to "Ready to Build," a series of new records are created in the Tasks table.I'm running into a scenario where a project might be paused or delayed and moves back to "Pending" status, then back to "Ready to Build" again at a later date. Is there a way to keep the automation from recreating the same set of tasks again?Thanks! 

Hello Airtable community!I inherited a pretty robust Airtable system from a predecessor and have been working to revamp it, but my formula skills are not as good as the person who came before me, and I've been struggling to get IF AND statements to work. The logic seems sound, but they keep returning empty cells.One of the ones I'm struggling with concerns a formula that should return 1 of 2 options if a cell has a specific entry. I can get a single IF statement to return the correct result, but as soon as I try to include an AND, it fails. Here's what I have so far:In my table, the formula field is 'Ship From' with the two options being 'Direct from Printer' or 'X Distributor'. I want the formula to return 'Direct from Printer' if another field - 'Role' - is one of 3 options: Marketing/Sales, Licensor, or Editor in Chief. All other Roles should return 'X Distributor.'So I put in: IF(AND({Role}="Marketing/Sales",IF(AND({Role}="Licensor",IF(AND({Role}="Editor in Chief","Printer","X

Hello everyone, I have the following problem: I have an Airtable automation that informs the assignee of a project when some fields change. Now we often have the case that there is no assignee yet but someone edits one of these fields. Then the automation fails and I receive a notification by email every time that the automation has failed. Can I change this somehow?Unfortunately, triggers cannot be cobined, for example: If field A changes and assignee is not empty. best regardsMirko

hi everyone!I am using automations to send a message on slack when certain conditions are met. In the body of the message, I want to show the conditions that were used to create the listed results... but cannot figure this out.I have a "Find Records" block setup, with the condition to find 5 records that match a certain multiselect field (in my screenshot, "O Positive").  This works fine.When I go to configure the message block,  I can add different dynamic data by clicking the +, however, there is no way to select the condition. I want it to say "O Positive" in my message body (chosen dynamically from the Find Records block), but I only see the option to list the results here, which puts this in my message 5x, since it's showing this field for each of my 5 records. Instead, I want to simply show the condition I selected in the Find Records block 1x... so the message lets us know the conditions that created the resulting message.Is there any way to select the condit

Hi there! I am trying to remove NaN values from a formula field where both positive and negative values exist. This is in an effort to clean up two extensions: One chart indicating the number of each value's occurrence and one number where I am trying to get the average of the values, but with NaNs included I receive an infinity. Here is my current formula:DATETIME_DIFF({Due Date},{Date Completed},'days')+IF({Date Completed},{Due Date} = "NaN", BLANK())Thank you in advance!

Hi,I'm trying to create a table to track income and the records feed from different tables using automations which are assigned a deal type as they're created. If they're type A the commission is 15% of the payment amount, if they're type B the commission is 10% of the payment amount and if they're type C then the commission field needs to return 0. I don't know if it makes a difference, but the payment amount field is a formula. I've tried SWITCH({Type of deal},"A", {Payment amount} * 0.15,"B", {Payment amount} * 0.10,"C", 0) But I just keep getting ERROR in the results. I tried looking here at nested IF formula and came up with:  IF(AND({type of deal} = ”A”, {Payment amount} *0.15,))IF(AND({type of deal} = “B”, {Payment amount} *0.10,))IF(AND({type of deal} = “C”, {Payment amount} *0))But there's clearly something bigger wrong there that I can't see because it says it's not a valid formula. Any suggestions would be hugely appreciated, thank you

I have set up a slack message to kick off a workflow that requires manual input.  The slack message has multiple buttons that once clicked check the appropriate field in the Airtable.  The problem is that once one of those buttons are clicked, all of them disappear in the slack message.   How do I make it so that once one button is clicked the "Updated in Airtable" message only shows for that button; allowing for the other buttons to be clicked?

Hi there,I'm looking for a formula to automatically calculate the Venue and Producer split of the Budget and Budget Committed as per the "Deal." However, at present, the "Deal" field is a text entry, and I wondered what the best way to achieve this is? Many thanks,Tom