Solved

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

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

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?

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,"hours")),'MM/DD/YYYY h:hm A') 

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

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

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?

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 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? 

I have a formula setup to show a status based on an 'Expiry Date'.This works from a date column {Expiry Date} with a column that works out the difference in days called {Diff}, this uses the formula: DATETIME_DIFF({Expiry Date}, NOW(), "days") Then is the status column I am using: IF(Diff <= 0, "❌", IF(AND(Diff > 0, Diff <= 28), "⚠️")) This works perfectly, my question is how do I add an additional "✅" status for all records that are in date? What would I need to add to the status column formula?

Hi Airtable Community, When applying the TRIM function to fields that are lookup fields from another table I receive an error. However when testing other formula’s E.g. Concatenate that does work this particular situation using Linked/lookup fields from another table. I would assume that the all functions gather data in the back-end in the same way. Can one confirm this is actually not possible to use TRIM in combination with Lookup Field type? Thank you

I can't wrap my head around this... For demo purposes, I have created a pretty simple base that looks like so, and this all looks goodThen I created a simple interface; the only problem is the item highlighted, which is incorrect. I have tried all the options, and nothing is giving me the correct %. If I plot the same data in Excel, this is what I see:Any idea how do I get the right ROI % (I need the result from the same table)?    

Hey, is there a way to separate files in an attachment field in airtable?Currently we have customers submitting photos into an attachment that automatically creates a new airtable record. These photos are stored under the one attachment field in airtable. I'm wanting to create an individual record for each file/photo in a different table called photos. For example; a customer submits three photos in one attachment. I want this to trigger an automation that creates a new record for each file within the attachment field. I've attached the code I'm trying to use with no success. Is there a way to do it without code?

Hi, I’m trying to automate creating an invoice on Quickbooks Online by a button press on Airtable through Integromat. While I’m successful in creating an invoice, the invoice is created for a Customer in Quickbooks. However, I want the invoice to be created for a Project of a Customer in Quickbooks, which is what I’m struggling with. Here’s the workflow: Have a Projects table and an Items table in Airtable. Create Invoice button exists in Projects table. On button click an invoice is created for all the items from Items table associated with the respective Project. In Quickbooks: Customer exists. Multiple Projects exist under Customer. Problem: Unable to map the invoice created to a Project in Quickbooks Any ideas, tips or solutions on how to achieve this? Thanks!

Hi,I want to search for 1 item in a table which contains multiple items in a cell - apple, banana, grape.The filterByFormula with the = only works if there is only 1 item in the cell.  If they are multiple items, I get an error.I tried using "contains" and "like" but they don't work.  What should I use?ThanksSteve

I am trying to create a scoring system using Airtable where judges can score a team (with the different metrics in columns). What I have done: Created 3 different tables for each judge Each judge’s table has a list of all the teams (teams are populated as new records across all judges’ tables automatically using external software) Judges can manually key in the score for each metric and an overall score is automatically calculated in the respective record What I need help with: However, I want to create a new table which gives a summary of the overall score for each team for each judge (i.e. looking across a particular record, I will be able to see the overall score for judges A, B and C). And I want this table to be updated AUTOMATICALLY whenever each judge finish scoring the team. What I have achieved thus far is using linked tables and lookup function. However, this is very inefficient as I have to manually choose which the team (or record) to be linked manually before I can looku

Hi there, i'm having issues with letters' case in my filterByFormula text and API call.I'm trying to do a searching box where user can give an input of what they are looking for, and Airtable fetches from a big database. Right now if i'm looking for "Hilfinger" it actually works alright and returns a few records, but if I type "hilfinger" it won't find anything.Here is my API call, i hope you can help:https://api.airtable.com/v0/appk7bV1OTtj*****/Offerte?filterByFormula=SEARCH(%22TEXT+HERE%22%2C+%7BNome+Oggetto%7D)&sort%5B0%5D%5Bfield%5D=Identificativo&sort%5B0%5D%5Bdirection%5D=descWhat would be ideal to happen is that Airtable gets the records even if cases are lower of uppercase.Thank you very much, any help would be much appreciated

I copied the Project management Airtable Template and I see Manual sort as a field type. This is not available for me on any other bases. Is this a new field type? 

Hello all 🙂 I've been staring at this and I am sure it is right in front of me but can't see it. I have a table of scenes that have their filming date defined by a lookup field (I link backwards for print result purposes - if you have seen my other posts DocsAutomator saved my sanity)Now the problem is of course that the linked filed doesn't ACT like one, so I cannot sort properly by date. I can group all the same dates together but they sort alphabetically, not chronologically. How do I accomplish this?

Hey Wonderful Community! I am currently having an issue with a formula that I am trying to show as a progress bar. Here are the specifics: I am calculating the percetage of time passed between a start date and an end date. The formula seems to be correct: ROUND((DATETIME_DIFF(NOW(), {Start Date}, 'days') / DATETIME_DIFF({End Date}, {Start Date}, 'days')) * 100, 2) However, when I go into the "Formatting" section of the Formula Field, it gives me a very large percentage which seems to be incorrect (in this particular case the preview shows 345600% but in the formula section, the preview shows 35.56%. I have attached the two images of the settings below:  Please can someone help me? xx

Hi, I am trying to create either a script or automation that will detect multiple records for me. I have my trigger set up, If a record has a scheduled date that was one day ago and the status on it is "booked"I want to then update anything under these conditions to "completed" I am having issues setting up the "updating" feature.  my configuration is as shown. I have NEVER done this type of automation, so I am extremely confused on this. any help would be greatly appreciated! Thanks in advance!

This forum has been incredibly helpful, so I thought I'd keep asking questions. Next up is why filterByFormula doesn't seem to work in my node app. However, the formula works in the Airtable UI and when used in an HTTP request via the API.  const base = new Airtable({ apiKey: 'xxxxxx' }).base('yyyyy'); const matchingRecords = []; await base('tblbfJeKQo52GnLWD') .select({ filterByFormula: '{project_id}="3986271"' }).eachPage( (pageRecords, fetchNextPage) => { pageRecords.forEach(record => { console.log(record); matchingRecords.push(record); }); fetchNextPage(); }, err => { if (err) { console.error(err); return; } } ); console.log(matchingRecords); The above returns `matchingRecords` as an empty array. However,  https://api.airtable.com/v0/app49uIs2F0Ca2ES3/tblbfJeKQo52GnLWD?filterByFormula={project_id}='398627

Hello everyone,  I have got this base with active deals and I would like to send it via email to my team, but I want the email to contain the same table as on Airtable. How can I do that? Create a pdf?

Does anybody else notice changed behavior when uploading attachments with the API?AT used to fill the file name property by default, but since last week I'm not getting any value when reading the attachment field. Older attachments have the "filename" as usual, newer uploads have no value in the JSON.Can anyone confirm please?Thanks in advance!