Solved

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')

Dear community, Does someone know how color a field by level of progress? For example, all tasks under 30% of completion in red, tasks between 30-60% in yellow, tasks between 60-90% in blue and tasks between 90%-100% in green? I’m sure that is something very easy to do, but I’m new with the PRO subscription and I still learning Thanks all!

Hi,I'm trying to automatically update a linked field with the data that auto populates in the "Auto" number field when a new record/line is created. I can get the data to return but it's all in one field.  I tried to use the "Update Record" option but continued to get errors Thank you 

I am looking for a script to assign to a button field.When a user clicks the button I would like for their username to be filled in the "Assigned To:" field. Is something like this possible?

Hi everyone ! 👋I'm setting up a database with a lot of elements coming from different tables.It's a database on which sales people have to make modifications, but I'd like them not to have access to this database in Edit mode.To remedy this, I'd like to create a form with an active search.e.g.: They enter a customer's name, and all the information we've already pre-filled in the fields, to avoid duplicating questions.Have you already implemented this? Is this possible?If not, what tools or workflows would you recommend?Thank you !

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and if I filter for the specific month, will it still work?Thank you! 

It’s slightly similar question to the previous poster actually. I have a field which has numbers in it. If I do this (grouped by field), it shows a very neat view which also contains SUM of each group. The question is. How do I get this sum to my other table? In my screenshot, that will be how do I create a record on other table which has my [400x600] text and ‘30’ integer in it? Is there a very easy solution that I miss? Thanks

We’re using Airtable as a PIM for clothing and we sometimes do modifications that creates a new style code. A lot of the information is the same (as it’s just a modification), but I don’t want to copy over any linked fields or certain notes on an item. I was wondering if it was possible to create a script that would let you select an item you want to modify and create a new item with select information from the base item. The links are in the same table FYI.

Hello, wondering if someone could help me correct the formula in the photo.  I am hoping for this to happen:If OLD JOB# is blank, display current 2 digit year (CREATED DATE) & "-" & 4000 + ID#. If OLD JOB# is NOT blank, display OLD JOB#For example, looking at the last 2 rows at the bottom, 42 is correct, but 43 should display "24-4183"