Solved

Hi,I have a currency column that is being auto-calculated, and the way Airtable is summing the numbers is sometimes incorrect - off by a few cents.I suspect this is because the auto-calucations sometimes come from .00 or .000 fractional ownership of certain goods, so when Airtable sums a bunch of those at once it's somehow dropping or carrying over fractions of cents...If I copy and paste the whole list of numbers in Excel, for instance, it gives me the correct total. So I'm searching for a way to somehow convert the auto-calculated field to a plain number field which will hopefully only give me the sum of the numbers as they are.Any suggestions for how to to this? Thanks!

Hi,My company has reached its max limits of automation configurations on one base and has decided to move on of the tables in our base to a secondary base for better scalability.  What would be the best course of action to begin this process, provided that there are multiple tables that are already linked in the original base.  My thoughts are that taking advantage of Enterprise 2-way sync should make this feasible, but I am wondering if anyone else has attempted this and has any tips. Drew

I have two tables: "Billing" and "Activities". I'm trying to find a way to combine this data so that I can see $ received from bills while only including "TimeEntry's". In this specific scenario, the amount I would need to see is $530, since the $100 is an ExpenseEntry.It is way too time consuming to manually count the hundreds of records, so I need a formula or an easier way to compute this. Thank you very much!

I am a historian, constructing a historical database (1940s-60s). When I click on my linked record for a person or institution, some of which will have to link to 1000+ records, I notice that the records are almost arranged in date order - but not quite. As I scroll down, I will notice up to 20 or 30 records running from earlier to later, as I would like, then a record from a decade earlier will appear next, followed by another run of (successful) earlier-later sequencing, though often for yet another subset of years. Naturally, I would like the entire contents of a linked record to run from earlier to later. I cannot see what other sort criterion the linked record might be using. It certainly isn’t the random 6-digit number I’ve created for each record ID. What is odd is how the linked record is almost in date order.

Hi All, A search of the community yielded the same question but no definite answer. I have created a view on Airtable, shared it so users can search and find info that they need. Problem - filtering, grouping, and search work only on desktop or laptop browsers. None of those options are available on mobile devices. Is there a workaround or some way to get at least the filter and search to work on a mobile device? Thanks in advance. Regards, usha

I'm not certain if the OAuth flow is working as expected...When initiating an OAuth flow for an existing, and currently logged-in user, the OAuth pattern works as expected. After the OAuth consent screen is displayed, flow correctly redirects the user to the redirect_uri.However, if a user is NOT logged in, the flow works to the point of providing an Airtable login screen for the user and then drops them into their admin page WITHOUT a OAuth consent screen. I would have presumed that for users who have not logged in, Airtable would allow them to login and then proceed to the OAuth consent process. As it stands now, users are dropped into Airtable without ever redirecting back to the calling site leaving users stranded. And assistance on this would be appreciated.

Hi everyone!Okay.. so... bear with me... I have people that have multiple roles {Contact Type} in the company (Humans Table)I also have a Junction table (CT Category by Human) so I can manipulate the dataso in my third table (CT status NEW) now that each role {Contact Type} is on a separate row I can add a different 'Status' to each roleMy issue arises when I add a new role to a contact in the 'Humans' Table. I have a working automation that populates the Contact Type row in the junction table with the new human that has been assigned this role....But I can't work out how to get that new info into a new row in the third table in order to allocate a status for it.... What I have been able to do is create a fourth table that creates records anytime the [Contact Type] field is updated in the first table... like so..  mainly so i can keep track of how often role changes happen. Table names 'HU to CT new':I'm hoping i haven't lost anyone so far... so currently AA2 AA3 human is a P

Hello everyone,I can't create a formula to find pieces of text in the "Libellé" (Text) field and transform them into a word.Example :IF “PAYMENT” or “PRLV SEPA” in the "Libellé" fieldTHEN “VER” in the formula field

When trying to read or write data to and from a long text field via the API, I am loosing the newlines.This is an example of what I have in the field:When reading the content through the API, I am getting this:Also, when writing \n to the field via the API it get's stored literally, i.e., is not translated into linebreaks:I cannot find any hint how to encode newlines in the API docs or the forum.Any help would be highly appreciated.  

Hello everyone,I can't find the old page where I could see my published interfaces, my unpublished ones, and create a new one. For a few days now, when I click on Interfaces, I'm redirected on the new interfaces page where I can see all my published interfaces on the left menu, but I don't have any option to create a new one.Has something changed?

Hello.I need to calculate the average of the entire column (called total score) but using the average formula I am getting the average of each cell. Is there any solution please?Thanks

Hi. My nonprofit is using an Airtable base to support and manage data from youth teams that are conducting service-learning projects. I have a table called "Teams" that holds all the data about each team. Then I created a form through Fillout.com where they can create new records in a table called "Project Plans." The first thing they do when filling out the form is to select their Team name, i.e. a field in the Project Plan table that links back to the Teams table.The problem is that before I understood how linked records work (creates a field in the table where it's created, but also a corresponding one back on the table that it links to),  I would notice the new field in table it was linking to and thought- what the heck is this extra field here? And then deleted it.I now need to create lookup and rollup fields in the Teams table, but have broken the link by deleting the corresponding field there. The "Teams" field in the "Project Plan" table still shows the team name.Is t

I have a table where static information about my volunteers lives.In it, I have a field (Static Notes) with an IF statement that looks to see if they have a check mark in "Qualified" (to walk dogs) and if they do, it returns "DDW" (designated dog walker), which then shows up on the schedule.Can I write a nested IF statement that looks at a different field altogether (Training Status) and if they "Need More Training" returns "Trainee" in the Static Notes field (the same field where DDW would appear)?Or do IF statements only distinguish between options in one field? And if that's true, how would I get various information (other qualifications, for example) to show up in my Static Notes field?Thank you! (I'm learning all of this by feeling my way in the dark - appreciate everyone who is willing to take my elbow and keep me from crashing into furniture along the way!)

Here's the system:Base A: Used for Project Management for an event in January.Interface A: Created on top of Base A for use by other members on the team where data access needs to be considered.Base B: Use for Project Management for an event in February. It is created by Duplicating Base A after the completion of January's event, so that the base undergoes an iterative design process, benefiting from the additions/improvements made to the base during the last event.❌  What I'd Like to Do: Upon creation of Base B by duplicating Base A, create Interface B that is a duplicate of Interface A.I am aware that Airtable does not support duplicating Interfaces to other bases for fear that the underlying data structure will be different (on Airtable's end, I imagine that at the least they should be able to offer the option to duplicate the interface associated with the base at the time that the base is duplicated).Has anyone else found a way to work around this? Re-creating the inter

Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?

https://github.com/sleiman/airtable-phpI have been using this tool flawlessly and working my new Personal Token where my API key existed.use \TANIOS\Airtable\Airtable; $airtable = new Airtable(array( 'api_key' => 'API_KEY', 'base' => 'BASE_ID' ));When I swap out the API_KEY with my new Personal Token it doesn't work, which I suspected. What do I need to change api_key to? Is it that simple I hope! Thanks in advance!- Jon

Hi. Sorry if this is a silly question. I need to rename a table that has some airtable automations linked to it. Can anyone tell me whether the automations will dynamically change their settings to use the renamed table as before - or do I have to manually re-configure them to use the new table name?Many thanks.

Hi,Is there a way I can create a formula that will determine the Monday for all these dates and return just one date. For example, in this table it's looking up data from another table, in this case the Monday for this set of dates is the 12th. How con I accomplish this? I need it to create a "end of week".. which I already have the formula for that. Please help.

Dear all, With my team we are using airtable to do systematic reviews and extract data from science literature papers. For each study we created 2 rows and each one is assigned to a reviewer. So, for example, we have the coloumn “sample size” and reviewer 1 writes 89 in his record and reviewer 2 writes 98 in her record. Let us suppose that there is an incrugruence. I am using rollup function to ask Airtable to show me the content of the two cells. First I used rollup function ARRAYUNIQUE(values). It was ok but if a reviewer did not report the value he should had reported, I cannot see it and it might be useful to see this discrepance between filled and unfilled cells. Thus I used the ARRAYJOIN(values) to see both the values. It fixes the problem above because I can see what both reviewer have extracted, but for long text it might be difficoult to spot differences. So, here it comes my question. Is there any direct or indirect way to compare with (or without) rollup function two cell of

I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calculations)2. I also want to only include records with an authorized budget entered, so exclude any that the authorized budget=$0.00 (this removes TEST 2 and TEST 3 from my calculations)3. Of those filtered to only budgeted or not budgeted and not $0.00, I want to count the ones with a remaining budget greater than 0, and count those with remaining budget less than zero, getting a percentage of the two. (in this table you can see there would be 50% on budget, 50% remaining budget is negative.The end goal is to display the percent of records on budget, the percent of records over budget, and possibly the percent of records with no authorized budget entered. I know the process would involve another table with lookup fields and rollup fi

Hello. Still fairly new to Airtable and working to better understand formulas. I'm looking for input on the following.We have a rental space where rates are set based on duration (up to 4 hours, up to 6 hours, all day). I've set up a table for Rental Rates. Separately, I have a table for rental details, and this includes a duration field ("1st Day Duration") calculated based on rental start and end times.I'm trying to figure out how to create a formula that calculates the correct rental rate based on the duration and then pulling the correct rental rate. So for example, if a duration is 3 hours, the fee would be $x (since that's the "Up to 4 hours" fee). But if the duration is 7 hours, the fee would be $x since it would be a "Full day" rental.One other variable. I'm not sure how to plan for future rental rate changes, so that when rates change existing entries do not change (only newer entries). I'm assuming this starts with a date variable tied to rate increases. In the Rental Rates t

hello!I have a simple automation that finds a value in one record, finds the match in another table and links it in the source table. It works great for matching but when my source cell is blank it links all the records from the other table:here is a screenshot of the automation: https://cln.sh/dZzXpYYjand here is how it looks in data with the blank cell linking both records from the second table: https://cln.sh/n6S2g7kFim also suprised that is even able to link to multiple records as I do not have that option enabled: https://cln.sh/c3JVy3ggmy goal is for a blank source record to not link any record to the second tableI must be missing something simple but for the life of me can't figure out what im missing and searched all over... any thoughts appreciated!

Dear Airtable Community,I'm working in a multilingual environment (I'm based in Switzerland and working with partners in Africa, my daily job can involve up to 6 languages) . It is essential for my job to be able to collect data with multilingual forms, but then aggregate the results in the same answer field. For the survey part, Airtable allow very conveniently to reformulate the questions in the form view in as many languages as I want, and that is a no brainer.Where the things get complicated is when the survey includes a single or a multiple choice question.For the single choice, I've found a very practical solution:Insert all the possible answers in all the languages in a single choice field, then generate as many form as the languages and for each one filter out all the answers that are not in the correct language. Finally, aggregate all the answers in another field with a SWITCH Formula, as shown in this example here: https://airtable.com/shr9d4kkhOACVv5VK. I can then this

Integration with make.com + airtableI want to automate posting on different social media channels based on information in an Airtable database. After each successful post, I want to update a status column in Airtable to reflect which social media platform the post is live on.The issue I'm facing is that the status column keeps getting overwritten, so only the latest post's status is shown, instead of all the platforms the post is live on.I've tried using this command:{{merge(6.Live Status; add(emptyarray; "Live - FB"))}}The command works when there's pre-existing data in the Airtable cell BEFORE the router. However, it fails to recognize the updated status created after the router for each post. It seems to only read the Airtable data from before the router was introduced.Can anyone help? see attached screenshot for the scenario. Thanks

Hi! Wondering if there's any way to make this work...I have a formula field that pulls info from multiple fields & concatenates it all together to create an email (content) to be delivered to the person associated with that record.I want to include a Loom video gif in these emails. (To be clear: This is one shared video link/gif which is going out to everyone. Not unique videos for each person.)Is there any way to do this within Airtable? I'm aware that I could simply paste in the Loom URL. I'm hoping for a way to insert the video's gif file if possible.Thanks in advance!