Solved

Hi! So I know there is an app to show how each field is connected. Where it will show if a field in one table is linked to a field in another table via a lookup or formula, ect. My database has a LOT of fields and tables, so I’m trying to consolidate some of the info and am digging into how everything is connected before deleting anything. My question is - is there anyway to see how the fields are currently being utilized in views for filters and groups, before deleting a field? I hope that makes sense! Thanks!!

I was wondering if someone was able to help me out. I am looking use a formula to calculate the amount of days until an item has to be renewed. What I would like is that when it’s nested within an IF statement it is calculated as a VALUE rather than a STRING. The reason for the IF statement is that when the Expiry Date is empty, no value will show in the “Days Remaining” Field. Here is the formula: IF({Passport (Expiry)}=BLANK(),’’, DATETIME_DIFF({Passport (Expiry)},TODAY(),‘days’)) I’m likely missing something really obvious in this regard.

Hello guys! I would like help to do a subtraction according to the values ​​that are being established. The situation is as follows: I work in credit format with my clients, so they start the month with 8 credits, as they request me, I establish the value in credits and these are consumed. Because of this situation, I would like to create 3 columns, 1 column “Cost in credits”, 1 column “Remaining credits” and 1 column “Total credits”. As I establish the cost of each material, I would like the column “Remaining credits” to be the result of “Total credits”-“Cost in credits”(for each row). I know Airtable has a different focus than spreadsheets, but the point is that I’m really enjoying the platform and I’d like to centralize as much activities as possible here, my company is just starting out, so splitting things across multiple platforms ends up messing up the flow of work. If there is a way to do what I said, I would be very happy. Thanks in advance!

Any help on this issue would be really appreciated! I’m making a simple app to create quotes. I’ve got everything up and running to edit fields with the <Input /> component and for anything other than text it works great e.g. function updateRecord (quote, recordFields) { quotesTable.updateRecordAsync(quote, recordFields) } <Input name="Hire Start" type="date" value={quote.getCellValue('Hire Start')} onChange={(e) => updateRecord(quote, {'Hire Start': e.target.value})} /> However, when the input type is text (or currency, anything that can be typed quickly), there’s a very noticeable delay in the update to the cell value which makes input glitchy and, if you type fast enough, inputs get dropped. I then switched to controlling the <Input /> with a state object, only writing back to Airtable in a useEffect() that watched the state object. This solved the issue but now updates made in Airtable (outside of the app) are of course not reflected in th

Does Airtable allow to read the content within/ inside the documents/ attachments with its own APIs?

Use-case: As an airtable user/developer, I would like to invoke one custom script from multiple buttons within the same table and my custom script’s logic determines next steps to execute from the invoking button’s identifier. Does Airtable’s API (or workaround) currently support this functionality? I’d like to avoid creating multiple scripts for the same action and I’m not “there yet” as far as creating more robust custom apps. I attempted googling various phrasings of this question as well as referencing the Airtable help docs (and API docs) related to the custom button feature but could not find anything for certain so I thought I’d ask here!

Hi All, I’ve got a formula that tells me when a job post is about to expire, when it is expiring today, and when it’s expired. I would like it to display an “Acvite” status for all other days, is this possible within this formula? Any help would be appreciated! IF(IS_AFTER(TODAY(), {Expiration Date}), “ :x: Expired”, IF(IS_SAME(TODAY(), {Expiration Date}), “ :firecracker: Expires Today”, IF(IS_AFTER(TODAY(), DATEADD({Expiration Date}, -3, ‘days’)), “ :raising_hand_man:t2: Expires Soon”))),

Hello all, I want to display my Event Start Time and Event End Time as ISO 8601 format. I need it in this format so that when I export the csv and import into Adalo (no code app builder) that it will accept the time and date format correctly. The “Local Start Time” field is the airtable user’s local time. They input the time there, then select the Event time zone. The “Event Time Zone” field has a formula to show the correct time in that time zone. I want to also create a column to show the “Event Time Zone” in ISO 8601 format and with the correct UTC offset. I need this because I need to export this airtable and import it into Adalo as a csv. I saw a user “Kuovonne” do something similar, but I can’t figure out the formula to get the correct format and utc offset. This is the output that Kuovonne showed that I am looking for.

I have a list of single-select options that I would like to clean up without causing any records to have an empty single select status. For example, I would like to delete “sketching” and convert all instances of “sketching” to “researching” (these options can be found towards the bottom of the list in the image). That way, when I delete “sketching”, no record will have an empty single select field, and all records that had “sketching” will turn into “researching”. Is this possible? Thanks :sunflower:

Hello Airtablers, In my base I have a growing list of contacts with links to other tables such as their company/organization and the state the contact is in. I’m now starting to include the cities and states linked to the company/organizations’ headquarters as well. The issue is that so far I’ve just had a table with 50 states plus territories, but now I have companies that are headquartered in other countries I’m thinking i’ll have to create another table of countries? Or just create a new field for countries in the current organizations table? Also worth noting that I just want the HQ city info to be a simple text field. I currently use Stacker to create a front end application linked to my Airtable base and I’m not sure how to structure this update to my base so that I can keep my linked table of US states from getting cluttered with foreign states. Any ideas/thoughts are welcome!

I’m working on an app that needs to filter the table in some way. It doesn’t look like there is a way to update the filters in the app. Is this correct?

Hello everyone! I am trying to get an array of unique items which are objects of two keys {id: "record ID", name: "name of record"} To filter out duplicate items I use rather complicated way. I define 3 arrays: one for keeping collected data possibly having duplicates and later for cleaned data two others for keeping filtered ids and names Code looks like this: let d = []; let u = []; let v = []; d = [{id:1, name:"a"},{id:3, name:"b"},{id:3, name:"b"}]; console.log(d); u = [...new Set(d.map(d => d.id))]; v = [...new Set(d.map(d => d.name))]; d = []; let m = 0; while (m < u.length){ d[m] = {id:u[m],name:v[m]}; m++ } console.log(d); As you can see I am using a Set to filter out duplicates. Unfortunately, this works only for simpler arrays (or I do not know how to use it in my case). Is there any easier or brief way to do that? Any valuable suggestion is much appreciated.

Hi everyone So I have this simple IF formula IF({Method}=“Digital”,1,0) Where {Method} is a multiple choice field, and can contain different type beside “Digital”. My problem is that this formula returns 1, only when {Method} is strictly equal “Digital” and nothing else. And I want it to return 1 if one of values is “Digital”. For example: Digital, Offset, Heatpress

Hi community members! I`m trying to sync change between 2 columns on Formula. (or…Is it possible??) ①:A specific textbox update (Formulas with text appended under certain conditions) ②:IF①`S record created,A specific “Checkbox” becomes :heavy_check_mark: Any ideas on how to solve this? (or recommend “automation”??) Thank you!

Hi There, I have a base that automatically date stamps when something moves through my content funnel. I would like to find a way to automatically count the number of date stamps for each month. My leads are sorted by status: First Contact, Initial & Follow Up, CAM Meeting and Play Session. When I change a leads status it automatically puts a date into the below fields so I can see how many reached each point, each month. I would like to have it so another field automatically counts how many date stamps there are in each month. For example, if I had 16 'First Contact leads and thus date stamps (as with the above image) in November, it automatically put it into the below table: Any help would be appreciated, thanks!

I’m trying to use Tailwind CSS with Airtable, but I’m not quite sure how to properly integrate the CSS. For context, I’m an experienced backend developer but my frontend experience consists of simple HTML and building simple React components. I know little about different frontend build systems. I know that it’s possible to import Tailwind from the CDN, but my understanding is that requires an HTML view to add the <a> tag that handles the import. Since Airtable doesn’t expose the HTML, I’m unsure if that is possible. Does anyone know of a very simple guide that walks through creating an Airtable app with Tailwind (or any custom CSS), bundling/building it if necessary, and uploading it to Airtable?

Can a form respondent receive a copy of their form data? Can a form respondent subsequently edit their form data? I haven’t found a way to do either, so if there is a way, please point me to it :slightly_smiling_face: Many thanks for your help, Julie

I have seen several topics similar to mine but have been unable to get this automation working. My goal is to send an email per record in my summary table at the time defined in the “At a scheduled time” trigger. Each record contains, among other fields: 1) Name, 2) Email Address, 3) Lookup field with a list of items, e.g. “item 1, item 2, item 3”. So, the list of items would be different for each record. At the scheduled time I want to send one email per record to the Email Address field and include the list of items in the lookup field. I was using a Find action to locate all records in my table that have linked records, and therefore have values in the lookup field (using a view to find records). But when I preview my email, I see all the values of all linked records concatenated together, as well as all the email addresses concatenated together. I was hoping for one email per record with values from that record.

Hi Everyone, Thank you for reading my message ! I’m encountering an issue I don’t understand, as it should be pretty straightforward. Maybe one of you may help… The “Event” table is Linked to the “Invoices” Table, through the Invoice_ID’s linked record (see below) : An Event can have multiple invoices attached to it (as in multiple attendees). However in the above screenshot, the Invoice ID that you see IS NOT in the “Paid only Invoices” View, and appears anyway in the Linked record field which, as far as I understand, should not : My idea is to manage Event stock with Paid only invoices, so for me it would be very practical to have this information on this table. Thank you or your help with this ! Best, Da

I don’t see anything in the Developer docs for Apps or Scripts which has the option of setting a table’s or field’s permissions. There are methods to see if the table or user has permissions to make changes, but none to set them through the API as far as I can tell. Use case: I have created an archive of a large base with many tables for posterity prior to deleting a bunch of data. I’d feel better with the archive copy locked down to prevent any modifications. It would be great to be able to for-loop through the table’s and fields to lock them down in order to prevent record deletion, new record creation, and modification. Is there a way to do this programmatically or only through the GUI?

I extract only year from date field with DATETIME_FORMAT(Date, 'YYYY') and assign it to new field. If I order by that field it isn’t recognized as number, but as a string (the option is A-Z or Z-A). How can I change it to a number?

Hi all! I need help in calculating the average value of a single select field. I tried the count(values) and it works. However, AVERAGE(values) gives me NaN. In the image 2, I’ve created a roll up field of the linked records An alternative to this is creating a field in the first table with the formula VALUE(Strategy - Top Ten Targets (Pitch 1)) and then using the roll up function on that field and works! But I want to know whether it can calculate the average just by changing the formula in the roll up field. Thanks in advance!

I have a marriage date for some people and no date for others. I created a field called THIS YEARS ANNIVERSARY as shown below. IF({Marriage Date},DATETIME_PARSE( DATETIME_FORMAT( {Marriage Date}, ‘MMMM D’ )& ’ '& YEAR( TODAY() ), ‘MMM D YYYY’ )) I need a formula for NEXT year’s anniversary. If THIS YEARS ANNIVERSARY was a simple date field, I know how to use the DATE_Add formula but I am struggling with how to use the DATE Add formula to this formula field so it is also seen as a date so I can use it as a date field in a calendar. Any help would be appreciated.

Hey everyone, Is it possible to turn automations on and off from a script? I’m trying to turn them all off automatically during weekends, so messages don’t show up until monday. My caveman way would be something like const d = new Date(); let day = d.getDay(); if (day !== 0 && day !== 6) { //Turn all automations off } Would that make any sense? Or would it be better if I leave my automations on forever and try to script them in order to only activate on weekdays? Thanks in advance

Hi community, I need your help. I try to create multiple records with automation. If the new record created has the product A and “3month”, you have to create 3 records : 1st record : Add the product 1, product 2 and product 3 2rd record : add the product 4, 5 and 6 … To match the product i have to add when i create record, i create a data base with : Product A : Month 1 / Product 1, 2 and 3 Product A : Month 2 / Product 4,5,6 … Can you help me please ? Thank’s a lot, Matthieu