Ask the Community

Hi there, Here's the scenario: • I have an automation to send an email to the marketing contact if the 'marketing contact email' field isn't empty• the 'marketing contact field' is a Rollup field with a formula of ARRAYUNIQUE(values)• even though the 'marketing contact field'rollup field is empty, as you'll see from the test run on the below Loom, it still tried to execute that worflow. • is it seen as not empty because there's a formula in it?https://www.loom.com/share/5b726b2bc41a414da662f055af863b55

I've posted here before, but never was able to find a solution, thanks those who tried to help me though.  I've since recreated what I'm trying to do in hopes that it is simpler and can be done.  Here goes. Use Case: I have orders getting added to a table "Order Fulfillment" by Zapier.  The Course can be several different things "ITIL 4 Foundation, ITIL 4 Foundation w/TAKE2, etc".  What needs to happen is, when the order gets created into this table and I check the "Run Automation" checkbox, it needs to find the next available Voucher Code from the table Voucher Code and move the information in Voucher Code table to the Order Fulfillment table and update the record.  The Course is what should tell it which to match and use. Is this at all possible to do?

Good morning,I don't understand why the function is refused, even though the content is basic. Do you have an idea?Thanks

I think this has been asked before, but I can’t figure out if it was ever answered: Is there any way to do row-based conditional formatting? I.e. is it possible for me to format a row (let’s say, make it all BOLD or add a color to it), depending on the value inside one of the cells/records within the row?

I would like to convert this text into an HTML format so I can send an API call to a particular software, but no matter what I do this text output always come out wrong on this software.I am using a "markdown to HTML" formatter for this via Zapier and I believe this rich text might not be markdown hence causing this issue, could anyone give their input and how I can convert this text into a HTML format

Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets relayed to the table in the form of a checkbox being selected/unselected. Here's the problem -- I need to calculate accessories inventory, for each individual column AND be able to automatically update the rolling amount in another table, which uses the accessory name as the primary record. I've tried EVERYTHING I can think of from linked records, to roll up fields, to automations, and formulas. If anyone can calculate how this can be done I'll literally send you a $100.

Good morning, I am working on an Interface and I want to add a drop down filter for a specific field in the table I am using. But Airtable is only offering me one field and it is a linked field. Is there a reason that a native short text field is not available to use as a filter? This Interface is of no value if I cannot filter by this field. I do not want my users to have to use the filter button the top right as it requires skills most of them do not have.Thanks for any help you can give.Thanks, Scott

I want to combine cells into one address block, but if there are no addresses I want the cell to remain blank. I'm having trouble creating this. Right now I'm getting a random common in the box: This is the formula I'm using: CONCATENATE({Address 1} & "\n" & IF({Address 2}, {Address 2} & "\n") & {Address 3},", ",{State / County}," ",{Zip / Postal Code})

HiI'm trying to make an AIRTABLE API callTo update a recordThe field I want to update is a field of type numberAnd when I try to enter a number I get this messageField "Hours used" cannot accept the provided valueOf course I enter only a number without signsThis is the body of the API call I'm making{"fields": {"Hours used": "35"}}I will rejoice in repentanceThank you

Hello! I got unexpected behavior in airtable web api.I use "Update multiple records" (https://airtable.com/developers/web/api/update-multiple-records) method for update or create records if not exists in my table. I use it with "upsert" parameter with two key fields like ["Handle", "Image Position"]. First one is text, second one is number.Expected behavior: update records if them exists, otherwise create new. Got behavior: always create new records.Note that updating with one key field works as expected.In general we need method to import records to airtable from our internal database and keep them up to date.

I’ve made a GPT assistant for e-com clients that can recommend products. This tool is made on make.com. The scenario is made with webhooks, open ai module (convert user query to airtable formula), search airtable records, open ai module (encode formula to URL) and airtable make an api call module.Everthing works except the api module. I believe it's the URL because I have given my PAT every scope, connected it to the base, and have correctly connected it in make.com. The api module is a get request and I have used the list records url from the api documentation. I have tried these two forms of URL encoding and still no luck:v0/appBUitd0yNopP1w7/Imported%20table?maxRecords=3&view=Grid%20view&filterByFormula=AND%28%7Bcolour%7D%20%3D%20%27Blue%27%2C%20%7BCategory%7D%20%3D%20%27Sling%20Bag%27%29https://api.airtable.com/v0/appBUitd0yNopP1w7/Imported%2520table%3F?filterByFormula=AND(%7Bcolour%7D+%3D+'Blue'%2C+%7BCategory%7D+%3D+'Sling+Bag')Any help would be greatly apprecia

Hello,Something strange is happening in an automation that queries a view and sends it via Gmail as a table.I have configured two numeric fields that the only thing that changes is the format. In one I have it as a currency and in the other as a number.But the format to show in terms of separation of thousands and decimals is the same. The problem is that when I send the email from Gmail, it only keeps the format that I want to show correctly in the currency field, but not in the other one. Could it be a system error?

I there a block or formula that will create barcodes for items in my database using the individual fields in each table? Example: I have an item with a auto number, name, retail price, taxable fields that I want to capture in a barcode. How can I accomplish this? Jay

So possibly a unique case here that I haven’t seen anything on yet. Looking at using airtable for welding production tracking on a construction site. The work, in simple terms, is welding a bunch of steel plates together on a wall to make a continuous plate. If you can imagine a series of rectangles lined up on a wall, each seam between rectangles is a weld. We currently have a list of all individual plates on the job, and then have fairly complex ID #s (29M1LGE22 for example, each character defining a certain position). The way you would identify what WELD you want to pull up would be to search two plates that are adjacent, and the weld ID would be the conjunction of those two plate IDs (is 29M1LGE22-29M1LGE23). We will be doing many welds per day, so as you can imagine writing down or searching out every individual ID would be very tedious. My thought/hope is to slap a barcode on every single plate and log those barcodes into a database. I would then like to search the two barcodes o

I need to add 100 barcodes to physical objects. The objects are already in a database. I can create 100 barcode numbers outside AirTable but then I need to scan each one to add to the barcode to the barcode field in AirTable. Time consuming. Or I could add the numbers to the barcode field? No I can’t … then the AirTable barcode field will not generate the barcode image to be able to print and attach to the physical object. Has anybody got any ideas?

I'm trying to create an airtable that will intake many records over the course of day (numbers) in individual rows and then get the sum total of all rows by day. i want the sum to be its own output (i.e. not just the "grouped by" sum function) so i can use it for other uses and visualizations.i have my main table created and the intake form. however, when i try to create a second table and link records, i can't quite figure out how to (1) automatically import records as they come in and (2) create a sum by date in that table.

 I see that Interface forms have validation for dates. Question is how to set it up? I would like to set up the start date to be 14 days from today, but the Range limit doesn't allow dynamic settings. What does this Range limit help with then?

Hi all, I'm building a task management base with a Timeline interface set to the Gantt display mode.  I am interested in utilizing the critical path feature mentioned in the help site for Gantt views but I can't seem to find the settings for it on the interface side.  Does it not exist for interfaces???  TIA!

I have a Jotform that populates an airTable base.  If someone submits an exact duplicate form, I created a vew that shows ONLY those submissions that have duplicates.  I have a checkbox in that view that when I click it, it hides that entry from that view, and (Importantly), it hides the other submission because the two submissions are no longer exact duplicates. This works great.  What I am looking for is a way (automation) that will automatically click one of the two.One slight complication is that there can be 3 identical submissions and I want the automation to click the checkbox on all but one of the submissions. That one unchecked will still disappear from the view because it is no longer a duplicate.

Hi all -- I set up an automation to trigger a personalized email every time I click a checkbox in a table. I connected and reconnected my Google account, but am not receiving an email even though it says the test was successful.The email I'm trying to send *from* is my work email, if that makes any difference (wondering if our Google admin might have a security setting that would prevent from automated sending, but not trigger an error when testing).Any help would be greatly appreciated.

Hi Everyone, Happy Friday!Looking for a little bit of help. I have a record of emails in one table titled "Clients" and in another table labeled "Appointment History".For every time the status of an appointment is changed from "booked" to "completed", I want to send an email to the client for customer feedback. The current automation  I have essentially updates ALL statuses from Booked to Completed at Midnight. The issue I am running into (I think) is my record ID. For the "to" section under the "Send Email' Action. I have chose the following upon testing to see if it will work, I get this error"Invalid email address in the "to" field: rec---" from what it appears, I need to seperate multiple emails with commas, however I am choosing the emails from a list in a table. Do i have to insert a comma or a semicolon at the end of each email address in my table to make this configuration work?  Thanks in advance 

Hi there,How can I enter hours for one tasks and days for others in the same project?Thank you!

Hi there,For the same task, how can you define a Daily Time Required of 100% on certain days or periods, and a lower percentage on others?Thank you!

I generate records through the week that all pertain to an event on Saturday. For organising these records into a week-by-week historical view (and for ease of human use on Saturday), I want to be able to automatically tag all of these records for the Saturday they pertain to. I have searched and tried a few things - this is the formula I got closest with:IF(WEEKDAY(Created)=6,DATEADD(Created,0,"days"), DATEADD(Created,6+WEEKDAY({Created}),"days")) Where "Created" is the date the record is generated. However, this generates a record for the previous Saturday. I don't really understand the formula I've cobbled together from old threads well enough to understand why. Does anyone have any advice to get it to fill that date as the following saturday from the "date created"?

I have the below interfaceThe idea is to give the service team members a touchable sheet they can use a tablet to checkoff when putting a cart together. However, the checklist is not editable inside of the interface which seems really stupid to not be able to do, plus for whatever reason isn't even viewable inside of a tablet/phone so defeats the purpose entirely. Any ideas?