Solved

I have a table that I created to track resource allocation, and use that information to then report out to a graph in my interface to show based on the allocations, how much I would be expected to spend each month. The setup for this is a bit of a workaround to solve for not being able to have multiple fields reported into a chart.  This is working how i need, but it is prone for error if I do not manually link the months in the linked field. I'm trying to create an automation, or solve this in any way that doesnt require me updating both the linked field and the fields that determine if a resource is active or not. My hope is that I could create an automation that would check the Month Fields, and if a Month is set to active, it would then enter that Month into the Linked Months field - this way i could just update the allocation fields, and my report would always be insync with what months should be linked -  See Image attached. 

I have 4 Tables (Payments, Receivables, CostCenters, Extract)The Payments and Receivables records are linked to CostCenters records.The Extract records are linked to Payments ou Receivables records ("If it's a receipt, it will be associated with an account receivable, and if it's a payment, it will be associated with an account payable.) So i want to make a formula field with an IF to get a cost center from Payments if the record is linked to a payment if not it will get the receivable costcenterIs it possible?

I have a pre-filled form that is launched from a button in a record in the Assets table. When the form is submitted, the automation is triggered. A new record is created in the Updates table. Then, there's a Find Record step where a condition is entered to find the record to be updated in the Assets table. Right now, I'm using the condition Today's Date.That's fine for testing but what I really want to do is let the Find Record value be the record from the Assets table from which I launched the form in the first place using a button.How do I refer to that Rec ID? 

I added a button to a table that forms a task when the button is clicked.The task is an async call to a REST API using Javascript's fetch.  I'd like to be able to display the state of the operation, including when its completed.The code:// make the REST API with an async function const response = await updateLicense(config.access_token, employeeNumber, licenseNumber); // dispay the results of the processing output.text(response) Unfortunately, the code doesn't wait for the updateLicense function to complete.  Any ideas?

Hi everyone! I'm trying to build monthly employee attendance with NFC tag. Basically when you "scan" nfc tag with your phone, it open up AT Form for submitting your entry or leave (start in the morning, start of the break, end of the break and end of work). In this form you can choose what type of entry or leave you're submitting. Name is preffiled (and linked to another table with personal information about Of course, when submitting the form, every entry from the form is in a new record. Is it possible to combine all four records into one (for one day)? And after that, I want to calculate duration (how long was one working and how long was on break). I tried by updating the field in another table, but I don't know how to define where (to which record) should information update (so for the specific employee and for a specific date). I'm thinking to build specific table for every employee. Can anyone help me?Thanks!

I've currently got an automation set to pull text fields from multiple records as a list into a Google doc. However, I'd like for the field names to not generate in the Google doc, just the content of the field. The hope is to compile text with less need for formatting/deleting of the field names.Example of how the field names and field contents are pulling in now:TITLE (field name)The quick brown fox jumped over the lazy dogs (field contents)STORY SNIPPET (field name)In a picturesque moment captured by onlookers, a quick brown fox elegantly vaulted over several lethargic canines in its haste to escape a pursuing hunter. (field contents)Is there an easy way to do this that I'm just missing?

Anybody have a workaround to print out an Interface (physically or digitally as a pdf)? I have a Financial Dashboard that I would like to print and file at the end of each year. 

I'm trying to build a system where users can copy a Roll Up/Look Up field of phone numbers directly from their phone. This field often has up to 20+ phone numbers.My current solution is to set up a pre-filled form that is accessible via mobile, in which the user will be able to highlight the pre-filled text within a single line text (pre-filled with the look-up field data). From here, users will be able to copy the data. It's a bit clunky.With the introduction of Interfaces on Mobile, I was hoping to build an interface that I could simply display the Roll Up field. However, on mobile, these fields are a bit difficult to copy out. It's still easier to use the Pre-Filled Form where users can "select all" text.Ideally, there would be a button to just copy text or a better way to display the Look Up/Roll Up fields in a way that's easily selectable to be copied. If anyone has a better suggestion for me rather than using a useless form that would be amazing!

I am trying to create an automation to transform a row with multiple linked records to multiple rows, each with one linked record. Ideally, they would appear on the same table. This is for a historical database where I track where people were over time, and it has four tables:(1) Location (registries of where people were at a particular moment in time)(2) Place (a list of cities where people could appear)(3) Person (a list of people, some of whom had the same name)(4) Reference (a list of archives where I get my information from)On the Location table, I have several registries where multiple people appear at the same place at the same time. Is it possible to create an automation to transform those rows into multiple rows, one for each person? I'm attaching several screenshots of a sample base that I made to illustrate the problem, and I'm including a link here in case anyone wants to copy it: https://airtable.com/app7lNkr5my9uiMtU/shr6v6rNqHXtfZ68RThank you in advance, as I've tri

I am new to Airtable and the database had me the permission to edit it. I am trying to add an option to choose from but I can't seem to "edit" nor "add" an option when trying to add one. How do I successfully do it? Edit it and input the desired option I want to add.

Dear AT Community!I'm collecting arrival and departure dates for an event setup period from workers. They can register through a form. In my base now I have two date fields with an arrival and a departure date for each worker. The setup period spans from 5th May to 16th May.The question is: How many workers are on site each day?In order to answer that question I created 8 formula fields and wrote a simple formula to extract the needed information from the date fields. The output looks like this:Now in the bottom row the sums are given which equal the number of workers on site each day.I tried to create a bar chart in an interface showing the days on the vertical axis and the number of workers on the horizontal axis. To no avail. Any ideas on how to approach this would be appreciated. I'm kinda stuck.Best regardsHenry

I want to make a pie chart that i already know the % for. Can I do that?

Hi guys!Is it possible to have URL in primary field? So that the URL is hidden behind some text (rich text formatting). Like you can do in other fields:So now I have this:One field is brand and the other is model (here I added URL). Primary field is brand + model. When I embed this view into my blog post, reader needs to click on the primary field and from that it opens up window where he needs to find it and click on URL one more time. I don't want that additional step (click) and honestly I think that reader won't find it quickly. Or it can be confusing.Is there a way to add rich text formatting in primary field?Thanks!

🅰️ On iOS and iPadOS, since April 2, 2024, AirTable has started to malfunction regarding newly attached pictures, as follows. { i[Pad]OS here means either and both of iOS and iPadOS }First off, the here described malfunction only affects "full picture display", as opposed to "thumbnail preview miniature imagery", so thumbnails show up correctly no matter what, and their appearance is essentially as expected.Secondly, the darn actual anomaly ::: 
➖ Only affects pictures attached by ⌜the Airtable for i[Pad]OS app⌝, 
and ➖ Only strikes when attempting a full view of given imagery in again ⌜the Airtable for i[Pad]OS app⌝,• which means the Airtable for Android nor the Airtable webApp seem affected, so those will be perfectly able to view imagery that has turned black (or invisible) in ⌜the Airtable app for i[Pad]OS⌝,• Moreover, any imagery attached by Airtable for Android or the Airtable webApp will perfectly show up in ⌜the Airtable for i[Pa

Deceptively, the here described image "disappearance" phenomenon may seemingly represent no more than an insignificant, minor issue, which *only* seems to occur when at least four "simultaneous" conditions are fulfilled : [1:] dealing with a newly attached picture ( meaning uploaded after 2024.04.02.Tu.), [2:] the upload was achieved from Airtable's mobile app for i[Pad]OS, and [3:] we are attempting to fully open the new picture in again Airtable's mobile app for i[Pad]OS, [4:] after having stepped out of the given record, been elsewhere, then returning to the new imagery.OK, this is about the currently happening and most unfortunate resurging of an earlier problem, dating from nine months ago actually, then and now again regarding New Picture Attachments in Airtable on i[Pad]OS – so in fact this is about an utterly, truly undesirable and unexpected revival of what we already had to describe mid last year, when we elaborately reported on it in :::














Since this annoying problem resurged, starting apparently April 2, 2024 and not resolved a week onward, here's two further links ::: "3. On iPhone and iPad ( i[Pad]OS ), newly attached pictures fail since April 2, 2024 [AShAP]" Here's about the very strange Lost-Visualisation-of-Any-New-Picture-Attachment malfunction in AirTable on iOS & iPadOS.. ( I even thought of an acronym :: "LosViNIA": Lost Visualisation of New Image Attachments ; or "LosViNPA" maybe : Lost Visualisation of New Picture Attachments ) 




For_instance :: a base created for testing purposes from the "Balloon Adventure" template, where at base creation time we keep ( or "include") the example records as originally provided. Starting from there, herebelow a 10-step test scenario is described, which – for afaik since early July 2023 – predictably will cause any newly attached picture to malfunction, at least that's the situation o

Hi everybody,if I can ask for help with formulas in IF statementsI have developed Glide app with Airtable, works really good.I have a table WorkOrders, and among other columns, I have:"Start time", "Start kilometers", "End Time", "End kilometers", "Total km", "Total time", "Status".This formula is in column "Status", works good:IF(OR({NameSurname}="",{Startkm}=""),"CREATED",IF({Endkm}="","IN PROCESS",IF({Endkm}>{Startkm},"COMPLETED")))How can I add another Status, Canceled?Button CANCEL in Glide updates the fields: Startkm and Endkm to 0 (zero), StartTime and EndTime to CurrentTime (same data in StartTime and EndTime)Can you help me with the formula?Thank you very much    

HiI'm a new Airtable user and I'm trying to determine the best approach to creating a dashboard view for each client at our firm with read only access.I'm aware you can create 1 base and filter views but that would make it possible for clients to see each others dashboards.Would it be better to create a single base specific to work for a single client and use that data set to create a dashboard or is there a way to prevent a client from looking at another client's dashboard if I chose to use a single base and filter views?

I have two tables Experiments and Readings.Each experiment is linked to two or more reading records. Each reading has a DateTime field, and some readings such as pH and temperature. The pH and temperature readings are number fields.I want to use the first and last sets of readings in the Experiments table in some numeric formulas.In Experiments table I use a rollup field with MIN(values) to find the earliest DateTime in the linked readings. In the Readings table I use a lookup field and copy the {First DateTime} reading back into the readings table. So that all the Readings for a specific Experiment contain a field which is set to {First DateTime}.Then still in Readings, I have a field {First Temperature} with the formula:IF(DateTime={First DateTime},Temperature, '') Then back in Experiments I have a corresponding field {First Temperature Reading} that looks up the result in the {First Temperature} field.  This all appears to work correctly so far. In the {First Tem

Hi,I need to add images into a filed in a form, it it possible?

Hi, I am doing a form for a remiders request, and I need that the filed "fecha de envio" the person is requesting the reminder have not the option to select a day before Today (current day).

Hi, I am looking for a front end for my base that allows a pos experience for my store, or some integration between my base and an existing POS. i am trying to use as little software outside of airtable as possible.

Hello, I think I need a help of Airtable community even though there is built in AI helper in the formula field. Here is what I am trying to do and have no success for some unknown for me reason. I'm creating an automation that with the click of the button will send an sms text message to my customer. I've recently experienced a problem with Twillio campaign approval (they are giving a hard time), but I've got an approval with TextMagic. So, Text Magic accepts sms as an email, then converts it to text and then sends it to my customer. I have a dedicated Airtable field for the phone number. Based on this, I've created another formula field that adds "@textmagic.com" after the phone number, the formula looks like this: CONCATENATE(Phone,'@textmagic.com')Everything looked good, so I started with my automation, but my automation failed at the end due the format in the formula field. My formula adds the ending, but it keeps original Airtable fortmat of the phone number with the bracket

I want to build an automation in Airtable where the user creating the record, will have their domain auto-populated based on the separate table in which each person has their own domain defined.For example, if John is creating the record and the John domain is IT defined in a separate table, when the record is created from John, the domain field is auto-populated.  

Hello - I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? I have tried: DATETIME_FORMAT(DATEADD({Showcase Date},{Number of days},'days),'MM/DD/YY')