Hello!!I have an automation I'm creating where I need it to do a "find record" based on email address. In table A, the email address is a lookup field so I created a formula field titled "email for automation" and simply told the formula to populate ...
Hello!There are a LOT of posts regarding the popular error of "Received Invalid Input" but in my search I didn't find anything that was specific to the conditional logic of the automation being the area that returned the error.I've created a video to...
Hello!I have a formula field set to format as a percent in the table. That field is then part of a linked record lookup field in a table that will trigger automation to send emails. I want to share that percentage in the email. However, when I use th...
Hello!I realize that Airtable most likely wants to push forms to be built via Interfaces, but of course, many forms have already been built by users in the standard table views. When going to a form view within the table (not Interface), we get a pop...
I have a script that looks at a Festivals table and based on a date input prompt in the script it returns any festivals that are occurring during the date input by the user by looking at the start and end date fields. I'd like to further modify the s...
@Tyler_Thorson the feature is for linked records. The original question posted was regarding limiting single or multiselect options in a field dependent on another fields selection in the *same table*. I was searching for a solution similar to the OP...
@Pascal_Gallais- Thank you for your answers. Unfortunately, I'm not sure how I'd do your suggestion of defining a formula to add the suffix to the email address and use that formula in the find records action allowing me to do away with the suffix an...
I'm also in this situation, but one step further. I tried this work around, where if I make a formula field to populate the lookup fields data, I get "invalid input errors" as if it cannot read the formula field and I swear this used to be an option ...
