Solved

I currently have an inventory base (A) that I synced to another base (B) in the same workspace. When I tried to sync the same base (A) to another base (C), I get this error message: Non-200 Response Received: 413 error. I am not sure why I am getting that, since the first sync worked fine. Could anyone help me figure out what that error means? I do have to sync the original inventory base (A) to multiple separate bases. I hope this makes sense! Thank you so much!!

Over time our long text field with bullet points has evolved into 100+ lines and we're looking for a way to no longer add new bullets at the bottom of the field, but rather at the top. Hence the very logical question: on existing long text fields how could one "invert" the bullet points. As an example:Item 1Item 2Item 3Should become:Item 3Item 2Item 1I've tried to use the "LEN" formula but haven't been able to produce anything working. Many thanks,

I have a Date/Time field that feeds into a formula field to pull the date from it. It used to work perfectly well, now that I have added the time option to it as well though there is an issue with it sorted dates wrong. As an example I have a task that is listed with the date 1/19/2021 7:00pm but when I put it into the formula it reads it as 01/20/2021. If I change the time to 1/19/2021 7:00am it reads it as 01/19/2021. It does read the Date/Time correctly in Calendar view. Is there anything I can do to ensure it reads the Date/Time field correctly for the formula? It is important for grouping reasons. The formula I am currently using is: IF({Due On}=BLANK(), “N/A”, DATETIME_FORMAT({Due On}, ‘L’))

Hi everyone. I’m using some rollup fields in a way that is only really useful if I can automate the linking of new relevant records to that rollup field’s record. Right now, the automation simply overwrites the old record link, rather than adding an additional one. The link field is set to allow multiple linked records, and I can add multiple links manually. Is there a way to configure this in the update record action? I am stumped.

Hi, I am trying to create a formula to work out meal allocations for works at a festival site.Currently I have date fields for 'ARRIVAL DATE' & 'DEPARTURE DATE' and a field for 'DAYS ON SITE' which uses the formula DATETIME_DIFF({DEPARTURE DATE},{ARRIVAL DATE}, 'DAYS') to calculate the days that any given crew member will be on site. I use another field 'Crew Meals' with the formula SUM({DAYS ON SITE}*3)Through the actual show component of the event, we only feed crew members that are actively working ie audo / lighting operators. I have included a check box field 'SHOW CREW' for crew members to check if they work on the show. I would like to create a formula (potentially an extension of the 'CREW MEALS' formula) which takes into consideration the 'SHOW CREW' check box status.For example - departure date minus arrival date = days on site minus 4 days, if the check box is unchecked. ORdeparture date minus arrival date = days on site minus 0 days, if the check box is checke

Howdy yall, I am trying to do a simple math setup for a client. calls per hour, demos per hour, calls per demo... The issue I am running into is the math seems to be coming back wrong. I have tried a few different ways and still having issues. Here you can see the number not adding up. In this case, we did 30 demos and had 19 families sign up. According to my calculator, I get 1.58 demos per family (30/19). However, I get 1.82 in the formula field. I have eliminated the infinity/NaN issues with the code in the pic that I found and edited. I will add that the rows the data is being pulled from are just normal number rows. I have tried different decimal sizes to see if it was a rounding issue, but it wasn't. Any advice or ideas would be awesome. 

A few days ago, I tried to help another Airtable enthusiast concerning a question about timelines. According to this community platform, I have written about  3250 posts since 2018, and despite my grandfatherly age, I recall one such post about Vega-Lite that would be perfect to help this customer.When a search engine believes you've made a mistake crafting your query, such as a misspelling, it tries to help. In this case, it demonstrates a significant degree of cluelessness.Did you mean: negative-lite ... Seriously? And what will this brilliant discovery engine tell me about "negative-lite"? Feel free to dive into that rabbit hole. We need to press on with a point to this post.Looking through all 42 pages of results did not contain the post I was looking for, but it did give me a few laughs like this one. It's entirely irrelevant to the query.The Khoros search engine has no idea that Vega-Lite is an entity, much less an Airtable extension. This says a great deal about the indexin

HelloI have a task I'm trying to achieve with a script in an automation. It's an automation to run every 3rd week of a month (ideally), and to trigger a script which will find all the Wednesdays in the next month and create certain records on those dates. That part I have sussed out, but what I can't find out how to do would be to grab the data/title from the last record of the current month the automation runs on so that I can make sure the new records it creates in the following month flow on correctly. Eg:Automation runs on 16th Jan, triggers a script to create records on every Wednesday in February, starting with a specific title relative to the last Wednesday record in January.The script needs to find out the title of record on the last wednesday of January (which would have been the 25th) and pass that variable into some logic I'll create to determine the titles of the February entries it automates. Hopefully this makes sense! Thanks 

I can't for the life of me figure out what's happening with this one transaction in the personal finances base I've been building.  Would you guys take a look?These are two of the same type of transaction for comparison.  The top transaction calculates exactly as expected.  The bottom transaction calculates out to -$0.00?!?!  I have traced and re-traced the formulas and can't find the issue, haha!  Here's the flow:The Amount field calculates by choosing the non-empty entry amount field from the following options:  an Enter Amount field that allows me to type the amount indirectly, and the Import Debit and Import Credit fields you see in this screenshot which come from my bank import files.Transactions are designated into one or more categories.The amounts from those designation records are rolled up into the Total Split field.The Left to Split formula is: IF(Type="Withdrawl",Amount-{Total Split},IF(Type="Deposit", Amount-{Total Split})) Does anyo

I’d like to use a rollup field with an array as an input for a formula in a different field, but it gives me an error. It seems to not be treating the rollup as a text string.

Hi,We have three main tables.  Client table records have one or many Interaction Table records, which have one or many Outcome records.To make the process smooth for collaborators and to reduce errors, I have a button on the Client record which launches an 'Enter NEW Interaction' form, with the Clients Name (i.e. its record id) pre-filled. Foe exammpleI frequently duplicate the live base to make test/training copies, every time I have to go into the url and manually alter the Enter NEW Interaction form's URL.  (And I have several other buttons performing a similarDoes anyone know a way round this? I would really like to use the forms name, rather than actual record Id.Margaret  

Hi,  I have an issue when using the formula fields in AirTable when using an IF statement.Context: I need the fields to be format as a percentage, or blank if there's an error/infinity.Here is the formula that I want to use in its simplified form, and I can easily format it to return as a percentage. (FYI both fields used in this formula are rollup fields)Sometimes, the values are 0, or blank, causing the data to reflect as such.  (or infinity in some cases)I want the data to reflect as blank. The following  is the formula used, that would have worked fine in excel/sheets.However, AirTable seems to have no idea to read this as a string or a number anymore since I cannot edit the format:Is this intended, if so, is there a way for me to workaround this?I am aware that it is possible to replace the value1 into 0 (instead of "" or ''), but that would cause a problem with another formula down the line.My result end up becoming a long string of decimal that is hard to vis

Hi,I have two tables that are linked. I have table 1 that consists of the membership information:Email (primary field)Last nameFirst namephoneI have table 2 that adds records after submission of a form. This consists of visits you can do once you are a member: ID (primary field)Email (only field to be filled out in form)Last nameFirst nameDateThe idea is to create records of each visit and it should autocomplete the fields (last name, first name) on table 2 pulling them from table 1 based on the email (matched field). The key here is not to manually select the "link to table 1" field but it should be done automatically.Please I would appreciate any suggestions.

I am running a simple automation to identify birthdays for the upcoming month.  My 'Find records' works beautifully when I test. My second action is to send the list of birthdays to specific managers. The action works, but the email produces a blank message and I know there are hits. What am I missing?Thanks in advance

Hello, I'm trying to figure out how I might be able to extract a portion of string relative to the position of a delimiter or other character.For example, I have a table of Events that are structured as follows:##### | <Name of Event>.I want to be able to use the vertical bar "|" character as the item to extract each chunk of information:##### and <Name of Event> respectively.Any help with the formula logic here would be appreciated!

In my base I got some images saved which I want to use in page designer.I believe I used to be able to use the Image URL in the page designers Image element. It seems still to work for about 24 hours and then the URL becomes invalid (which believe has something do with Airtables new security updates.)However is there still a way to URLs of an image in different attachement fields?

Since manually adding a comment doesn’t go into any existing “fields” of the table, I can’t use trigger to automate this. Can this be achieved using scripts instead?

Thanks to Adam_TheTimeSav and his post Solved: Re: How to make a colorful kanban board - Airtable Community I have installed Tampermonkey and changed the background color of my Kanban board.I would like to go further and change colors for tasks and stacks. Where can I find Airtable documentation on the various options to do this and other things I might like to do in the future? In the script to change background color I findGM_addStyle('#kanbanView > div.white { background-color: aliceblue !important;Where does #kanbanView and others come from and what can I do with them?Where does div.white and others come from and what can I do with them?What options are available such as background-color?What does !important mean?I'm an old-timer who's been programming for decades. I think I can figure out how to do what I want to do if I could find documentation. For starters, I'd like to change the background color of stacks to match the listname. Hope this makes sense

Hi,I've been using Airtable to track the performance of my company's social media metrics so I can pull out trends based on the topic and format of the posts.The problem is that the data from the posts (e.g. LinkedIn reacts and comments) is not kept up to date because I input it manually. I was wondering if there's any way to automatically pull data on the likes and comments of a certain post from LinkedIn and Twitter into Airtable if I link the relevant post?Please let me know if someone has already asked a similar question, I imagined it'd be a common function people would like but I couldn't find anything online. 🙂

I am trying to create a formal that adds a specific amount of days to a date field. The amount of days varies and is pulled using a lookup field. Initially, I was trying to use the DATEADD function but it doesn't seem to work when the added value is another field instead of a numeric value.The formula I have currently is DATEADD({Submission Date},{Health Plan SLA},"days")The field Health Plan SLA is a lookup field that pulls a number from another tab. I need this number to be what the formula uses. 

Hello!I have a list of records that all have a start date and end date column for a number of employees.  I am wondering if there is a way to calculate the number of employees on a given day.  All the employees have different start and end dates.  So for example I want to know the total working on March 1 vs March 7.  I know there is a way to do this in excel using an IF/AND formula but can't figure out how to do it in Airtable. Appreciate any and all advice!  

Hi,I got error message when subtmit phone number to enable 2 steps verification. My country code is +84

Hi there. I'm trying to make a custom auto number. The constant is kasse 00 and then want the autonember to be kasse 001, kasse 002, kasse 003 and so on. Can anybody send me in the right direction?And off cause will there be a problem when I reach kasse 010. It needs to be kasse 010 and not kasse 0010 best regards Thomas

I'm trying replace the following text with different values within [] with values from single select columns[art medium], [main objects], [attribute], [expression], [key light], [detailing], [camera shot], [media], [engine], [artist]I thought this would be fairly easy, but somehow can't get it to work.I tried a Substitute() like this:IF(Medium = BLANK(),SUBSTITUTE(Label, "[art medium], ", "" ),SUBSTITUTE(Label, "[art medium]", Medium)) &IF({Main objects}=BLANK(),SUBSTITUTE(Label, "[main objects], ", "" ),SUBSTITUTE(Label, "[main objects]", {Main objects})) But it subs the text and then renders the remaining text. Does anyone have any pointers how I best go about this?

Hello,I have a rollup field with the following output:FirstName1  Last Name1- XXXX Title Company , First Name2 Last Name2 - XX Title CompanyWithout going back to the original table to pull the "XXX Title Company"  I need a formula to help split and display everything after " - " for each value. Any help is appreciated!