Ask the Community

I'm trying to calculate cost/price in my shop by hourly rate. I have the Time Tracker linked with my Duration Field, but something is off in the calculation. IE one duration is 0:43 (0 full hours;43 minutes) but the calculation cost is showing $3,870. It should be $64.4999 with the formula (Duration/60)*90. How do I get it to calculate the correct amount wether the billable hours are 1h:43m or 0h:43m? Thank you in advance

Hello,Please, I would like to create an automation that, on the 1st day of each month at midnight, creates a new record with the actual trigger time. I expect the trigger time in the action section to be the same as in the trigger section of the automation scheme. However, somehow, the "Actual trigger time" field value is created with the last day of the previous month.Thank you for clarifying what I am doing wrong

Hello All, I am not sure if this is a bug or if I have something set up incorrect. I have a user that is given access to an interface without access to the base. However her notifications will occasionally send her to the base which se of course does not have access too. I have experienced this as well, some of my notifications will bring me to the interface and some will being me to the base. We only use the interfaces in our day to day, so I am not sure why it would send us to the base. Thank You. 

Hi Unable to automatically generate Invoice number when make new invoice from Airtable to QBO though MAKE Please help    

I design and produce products which I sell online. I use Airtable for project management. My Airtable base has tables for PROJECTS, TASKS, PRODUCTS and more. Each Task and Each Product is assigned to a Project. I have created an interface where my supplier can get all the data and infos for the upcoming products.In my PRODUCTS table, I use a formula to create a SKU for each product. It is a combination of the project number, the product category and the product number. My Problem: Some Products have variants (e.g. T-Shirt sizes). 5 different sizes of the same T-Shirt should all have the same SKU, just with an addition "-SM", "-MD", "-LG" etc.When I send the info to the print company, the interface should not only show a total amount of units ordered. If there are variants, it should also show the ordered unit for each variant. For example "Small (AR0010101-SM): 11 Units", "Medium (AR0010101-MD): 23 Units".But there are many other potential variants for products

I have two rollup field I need to evaluate and for some reason I can't get it to work.Field1: {rollupStockMinimum}Field2: {rollupNonStockMinimum}Field1 is empty, but Field2 is not.I only want the formular to do something when there are something in both fields.I've tried with this very simple formular  IF(AND(Field1, Field2), True, False)   However for some reason it evaluates to 'True' despite Field1 being emptyI've tried to just do IF(Field1, "True", "False") where it evaluates to False.What is it I'm missing or don't understand?

That can be used to generate web pages automatically from a base? I know that Carrd can be connected to Airtable one way (for instance, to fill in data into a base for a form created in Carrd), but I am not sure if it can work the other way around (a row in Airtable becomes a website page in a Carrd site) Are there any other applications besides Pory, Table2Site?

Dear Community Members,We are a non-profit organization from Germany. We have submitted the application for non-profits along with all necessary documents twice via Airtable, but we have not received any response so far – neither an acceptance nor a rejection. I have written to the support staff twice, but we have not received a response from them either.Perhaps you could advise me on how to obtain more information about the status of our application and whether additional documents or information are required from our end.It's worth mentioning that we have already been classified as a non-profit organization by Google and several other companies. However, due to our limited budget, we need to consider whether we can continue to afford the costs of Airtable.Thank you in advance.

Hi,I developed custom extension in airtable..In this I am implemented Oauth manually and its almost done.The blocker i am facing is after getting access token i dont know the redirect url for that extensionhow can i get the redirect url for the extension that i am building

I'm trying to have the formula with a dateadd calculation be blank of a certain field is blank. However if I put the  DateFormat function around the whole If formula it will either result in an error if the input is Blank or if any option could be blank it will not allow the Formula Formatting as a Date field either way. How can AT recognize a formula field as a date field if the date could be blank based on a conditional formula or related blank field???  DATETIME_FORMAT(IF({Weekday Planner}=BLANK(),BLANK(),DATEADD(TODAY(),(({Auto Date 2}-(WEEKDAY(TODAY())))*24)+15,

Hello there,Everytime an event occurs, a tool add a new record in Airtable. Once added, it's automatically sorted by Creating Time, so the newest one is always on top.What i need it that if the total rows is 500 and a new record is added on the top, Airtable automatically deletes the number 501 (the oldest one).If not possible another viable solution would be that the 10th of each month for example, or 2 times a week, Airtable automatically deletes columns from 500 to the end.Hope you can help, thank you very much!

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%29

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.