Ask the Community

Hello - I am new here and trying to create a base for following cash flows in my various accounts, cash or petty cash.Thanks to sources I found here, I succeeded to create deposit and withdrawal through two tables, one for accounts and one for transactions, and a rollup structure to calculate the balances of each account under the deposit/withdrawal transactions. However my concern is related to "transfer" transactions between accounts. When it is a "transfer" transaction, I want the rollup to subtract the amount value from the transferring account and add the amount value to the receiving account. I mean, when the number of accounts and the rollup transactions becomes two, I cannot find a practical (or sophisticated! 🙂 ) solution for such purpose, so that;(a) I select the "transfer" as the transaction type;(b) I enter the amount of the transaction;(c) I select the From and To accounts separately;(d) The amount becomes withdrawal for first

our airtable is automated in sending email notification whenever a new data is added in google calendar. however, i've noticed recently that it sends email notifications excessively and was wondering how to fix it. it's excessive to a point where if you just adjust the time in an event in calendar, it sends email notifs as seen below. the trigger to the action is "when a google calendar event changes"even though i can change the script logic to only add the guest if the change in event was a new guest, it will still run the automation and therefore count towards the number of automations run each monthis there a way to figure out why the google calendar events are changed? i can't see it when looking into it

Hi, is there an option to stop the Formula Helper dialogue box appearing when I click in the Formula edit box?The thing obstructs visibility of the formula when I'm trying to edit.   I'm having to click out of the formula edit field to close the dialogue in order to see all parts of the formula. 

Hello - I am trying to get a total count field if student's have passed multiple tests. There are six fields representing each test. Within each multi select field the contents contain: Drop downs for fields:  Pass 4/5/24, Pass 4/17/24, Fail 4/5/24, Fail 4/17/24.  I want to use a multi-select tool so if/when they retake the test, I can note which date they passed or failed. Fields:Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 I would like another column to say, if the fields contain pass, then count it as one. If a student passes 4 out of 6 of the tests, I would like the column to have the total = 4. I am stuck combining the multiple fields. Airtable provides the following equation to count for one multi select field: IF({YOUR MULTIPLE-SELECT FIELD NAME},LEN({YOUR MULTIPLE-SELECT FIELD NAME})-LEN(SUBSTITUTE({YOUR MULTIPLE-

Hi,I'm looking at trying to create a simple invoice e-mail to be sent out as a result of an automation. I can basically get all the needed data in, but struggle with getting visually at least semi-appealing ;).I read the manual about markdown and that some html can be used. I also looked at the instructions regarding including images in the mail. However:with the limited html on offer, has anybody been able to build any form of layout (other than vertical listing 😉 )? Could CSS and <span> be used to, say, get a right side header column? Or should I try to build views of the relevant tables and insert the data as grids?if I include images (one top banner, one logo) as attachments from a table, they are not just plain images, but have some frames around them. They are also clickable links, which is not good. Based on the instructions I can't decipher if it's possible to have inline images *that are not linked*, but actually a part of th

Hopefully useful for someone. If you set a variable called ‘Shorten’, then you can use this script to pull the URL and turn it into a bit.ly link which you can then use to automate something else! Feedback always welcome. let inputConfig = input.config(); let response = await fetch('https://api-ssl.bitly.com/v4/shorten', { method: 'POST', headers: { 'Authorization': 'API CODE FROM BITLY GOES HERE', 'Content-Type': 'application/json' }, body: JSON.stringify({ "long_url": inputConfig.Shorten, "domain": "bit.ly", "group_guid": "THIS CAN BE FOUND IN THE URL OF YOUR BITLY ACCOUNT" }) }); let bitly = await response.json() output.set("bitly", bitly)

Hello!We have former users with Creator permissions that we would like to move to non-billable to save funds for a nonprofit.When we disabled a former "Creator" user, other users were no longer able to manage rows through a particular view or interface.How can we locate (and bulk move!) all created/permissioned collateral like automation, views and interfaces from one user to another?I could do this with a regular SQL database, however the nonprofit prefers for data entry using Airtable and thus I need some assistance to work within existing management tools provided 🙂Thank you!

Hi, I'm new to automations on Airtable and am facing an unusual error:"Name is "foo", Invalid filter on Email (Invalid choice name or id: foo@bar.baz)"My "Find records" step has two conditions (OR), attempting to match on "Name" or "Email".Here you can see a successful test, when a match is found:It is also successful when no match is found, BUT when only "name" is used, and not both name and email, finding 0 results (expected behaviour).  BUT when adding the email condition bac, when there are no matches, it gives the error: This seems

I’ve added Multiple Select field to my base. In the Fields section on the API page it displays all the Possible Values this Multiple Select field as an array. Is there a way to grab this Possible Values array upfront or do I have to loop through the records and build this array based on each record’s selected value(s)?

I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a date dependency to calculate the end date for the subscription. Is this possible?I already figured out that i can convert it to duration using a formula field but then i can't use it in a date dependency...

To any formula ninjas, A column has multiple keywords/values. I need to add a pre-fix before each of the values. From: column: Colour values: White, Black, Blue To: add the prefix “Colour_” to each one of the values in the colour values: Colour_White, Colour_Black, Colour_Blue I created another column with the prefix Colour_, and then a basic concat, but the result is (of course): Colour_White, Black, Blue I don’t know how to add the prefix to each of the values individually, and if concat is the right formula. Detail: not all columns will have a value, so need to consider an empty cell. If anyone has a good idea… much appreciate it ! Christie

Hi,I find myself needing to change at least single select values, and would like to know if there's a way to do that without breaking automations and interfaces?I e.g. have names of event types that I need to change, for example from "Discovery" to "Discovery call" or status kind of values like "Ready" to "Ready for invoicing". Any of these are used in interfaces and automations as discriminating variables to either activate automations or filter what is shown.When attempting to edit one, I get a warning of dependencies, but I can't understand whether the update would actually break the listed dependencies.Thankful for any help how to do this safely. I have a ton of changes to make....Rgds,Björn

Hi, we track which topics will be posted to social media mainly in calendar view in Airtable. Ex. Have "receipe" show up every Wednesday on the calendar instead of having to input the date manually. Any suggestion on how to accomplish that? 

I’m comparing two currency values in a table, and attempting to flag if there is a mismatch. The way I’d do this in gSheets is pretty obvious: =IF(field1 = field2, TRUE, FALSE) - then conditionally format on TRUE or FALSE to get a visual indicator. I actually like that there is no range-based conditional formatting in airtable, since these are meant to be DBs - but I still think a coherent display of true/false values (As a checkbox!) is reasonable and I shockingly don’t see a way to do that here. Yes, I could do something idiotic like represent it with an emoji, but that’s a nasty hack if I want to query for items in my table whose cost-match is FALSE. Thanks!

Hello! My gmail automation email is going to spam. I created an auto responder using gmail and airtable automation. All my emails are going straight to spam. Is there a fix for this ?

I am looking at a way to deplete inventory of items when adding a kit to inventory. For example:I have 1 kit that contains 2 A's 4 B's, and 1 C. SO when I add a kit to my inventory, it removes 2 A's, 4 B's, and 1 C. How would I make this work? Thank you for any help.

Bonjour,Sur l'appli mobile Airtable, il est possible d'ajouter une base à l'écran d'accueil pour faciliter l'accès à la base depuis son téléphone (très pratique).Je n'ai pas trouvé l'équivalent pour les interfaces mobile, est-ce possible à ce jour ? sinon est-ce prévu prochainement ?Merci pour votre retour.Damien

Hello everyone,I tried out the project management template and found some functions that I couldn't find in the normal Interface Designer. Do some templates simply have additional functions that cannot be replicated?For example this sorting function: Or the ability to call up a form without being redirected to a new URL.Or the option to choose between list and timeline. I would love to have these functions.BestMirko 

I have some interfaces that would be so much cleaner and user friendly in the new interface formats if there was a way to show summary details, and then add a button action that opens a side sheet for detailed view/editing of additional data.Is this possible, either through current feature sets or workarounds? I know i can open a side sheet if there is a linked record to click on, but in some cases there is too many linked records so i want to hide them and be able to open sidesheet exposing all details of those linked records as a view. Adding them as a view within main interface makes it clunky.

Hi all,When someone submits a form, I already know we have a relatively empty record that exists for that submission. I want an automation to do the following:Trigger: When a form is submittedAction 1: Find a record by matching phone numbers in the table to the form submission.Action 2: Update the record in the table with the new information submitted on the form (5+ fields, some of the fields are drop-downs and some are free text). In my test, it all seemed to go well, and then when we actually submitted something, it stopped working.

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks 

Hello,As the title implies I am looking for an automation to catch records created by a form and notify via email when there is a discontinuity from the last submission. For example if the miles entered on a particular vehicle in the last submission were 101 but the next submission starts at 101.3, an email is sent to notify of the discontinuity.Thanks!

I have a script that I'm having difficulties with. The script is part of an automation block which is triggered by a new record being added to a table called Projects. This record in the projects field has some info about it, (how many episodes, series number, etc) but crucially, has a multi-select field. The automation is supposed to look at the trigger record, which has a field for how many 'episode' records it should create, and then makes the episode records and links them back to the project. It is supposed to also copy the multi-select entries that are in the triggering record and make them the same in the newly created 'episode' records. But it seems to be failing at that, and I'm getting an error: Error: Field "fldYr1BVOeRj2DLLz" cannot accept the provided value. at main on line 43 Can anyone see from the script what might be the issue. The field mentioned above is the 'El

1. Say you have 2 pages in Airtable interface (page 1 and page2)2. The actions a user needs to take are located in different 2 grids,  respectively located on page 1 and page 23. Currently we need to set the filter manually in Page 1 and again manually in Page 2.Is there a way/workaround to retain the filter parameters set up in Page 1 when navigating to Page 2?Apparently we cannot pass parameters to filters via URL parameters either 😕😕

If I have Filter Tabs enabled and I click 'Add records,' if I don't manually populate the fields that the filter is using, the record is filtered out of view immediately after it is created.It might be useful to have the fields and values specified in the current tab's filter automatically applied to the new record I created, at least as an option. I think in many cases this would be a more intuitive behaviour for users.