Other Questions

Hi all, I need to update an Airtable array field via Integromat. In Airtable I have multi select field with Project 1 Project 2 The scenario update all the people with “Project 1” and there are 3 cases: If the person in not in “Project 1” nor in “Project 2”, the Array is empty and I have to add “Project 1” If the person in already in Project 1 the Array contains “Project 1” and I can jump If the person is in Project 2 the Array contains “Project 2” and I have to add the “Project 1”. This is the function that I have insert but it does not work…can you help me? thank you very much! {{if(contains(Array; “Project 1”) = true; ; add(Array; “Project”))}}

Hello, I would like to write a formula that create a date in format with days in number and month in letter in French like “15 Septembre” out off another date cell. Thanks for you help

Hello so I have a button that triggers this script. The script is to create a unique child record based on the attachments I add to it. For example, if I add image1 and image 2 into the parent record, then I click the button to run the script and the it will create 2 child records named image1 and image 2. So I have the following script, and it works, but its actually getting all of the records from the view. But I only need it from a single record from where I clicked the button, so I understand I need to pass the record to the script. Can someone help me do this please //script settings let settings = input.config({ title: 'Create individual records from multiple attachments in a single attachment field', description: 'Creates 1 individual record in another table for each attachment in a multiple attachment field in the source table, and links the new records back to the source record.', items: [ // Source table select input.config.table('tableSource', {

Do any GB users have experience of Integrating with the PAF or other postal address solutions? As part of the local authorities effort to cut greenhouse gasses, we are running an Airtable based project to help home owners retrofit their properties with insulation etc. To ensure accurate postal addresses are entered I would like to integrate the sort of solution where you first enter postcode then select house number/name. I am not sure where to start - has anyone done this? Margaret

Hi! Is there a way to set up records, so that external viewers of a view would be able to choose and pick a record among others to share on SoMe? It is already possible to automate SoMe-posting in Airtable, so maybe there is a way to do this too? Regards, Søren

Good morning all :sunrise: I’m wondering if there’s any method to filter a MarkDown Long Text field that contains checked and unchecked tick boxes? Interestingly enough, I can write regex formulas columns that return various values - but I’m unable to run a filter directly on the Long Text Markdown field. Filter returns empty; As a workaround I’ve employed the below formula - but would be far better if we could simply filter for this condition directly without the need for funky-formula. REGEX_MATCH({Status}, "\\[ \\]") REGEX_MATCH({Status}, "\\[x]") EDIT: Almost forgot, this check count formula; (LEN({Status}) - LEN(SUBSTITUTE({Status},"[ ]","")))/LEN("[ ]") (LEN({Status}) - LEN(SUBSTITUTE({Status},"[x]","")))/LEN("[x]") Keen for any ideas.

Hi All I have downloaded airtable and it looks great, I have used an existing template, and now created some individual Gantt views I wish to share with specific team members. All that has gone well except that they cannot see the gantt table because of the following error message “Start date field is hidden or invalid” If I select the option “share all fields in expanded records” then this error goes away, BUT unfortunately this then means they are not seeing only the targeting records relvant to them as I have selected but instead all the grouped records become expanded making their gantt view huge and also then not matching the gantt view as I see it. In addition the expanded records are listed in reverse alphabetical order which also doesnt match the Gantt as I have created it in my Base How can I get around this? cheers Philip

Hi, I have two tables in my database: Food Items (contains a number of food items with various attributes such as price, food type, etc.) Shops (contains a list of shops with attributes such as address, post code) These would have a many to many relationship, in that each food item could be in many shops and each shops could contain many food items. I would like to make a third table which automatically contains all possible combinations of the two tables, and which automatically updates whenever a new record is added to either of the first two tables. Then I intend to add some other attributes and set up a filter so that I could query it. I can not work out how to do this. I have found a way to create a junction table by following this tutorial ( https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships#ex3 ) but it seems to require me selecting each line manually. I must be doing something wrong but can not work out what it is. Edit t

Hi all! I just started doing taxes as a small business and I figured I’d make an airtable chart to keep track of all the different tax rates in different counties. However, what I’m running into is this: When I go to formatting I get the response: Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date. Here is my formula: IF( SEARCH("Online", {Location}), "0%", IF( SEARCH("Wake", {Location}), "2%", IF( SEARCH("Durham", {Location}), "2.25%" ) ) ) I’ve tried both with and without the % symbol. To be fair, the return in that column works fine but I can’t then make a later formula using those values because it doesn’t recognize them as numbers. Here’s a screenshot of the table I saw in another thread that maybe doing a separate tax rates table would help, but I am unsure how to set it so that if I click “Durham” on my Location it would

Has anyone successfully set up the app “Address Cleanser by LOB”, from lob.com? I cannot get past the setup stage. When I submit the last of my setup details (page 2 of 2) I get the message “Sorry, an error occurred”. It recommends reloading the app, which I’ve done several times, then contacting Lob support. I thought I’d try the community first. Also, I’m using a test environment secret API key from Lob. Also tried the live environment secret API key but that requires a credit card (so I didn’t actually try it). Also tried the test environment publishable API key but it says a publishable API key cannot be used to authenticate with this end point (I’m in Australia – the end point at the end of the world!).

I use a service that exports a list of movies. Whenever there are multiple countries or directors it puts them into a new row below the main record. Is there any way to combine these additional rows of entries automatically so they all go into the same row as the movie title? Here’s the airtable in question: Airtable Films - Airtable Explore the "Films" base on Airtable.

I have a worksheet for each coaching session I have across various clients. I also have a column with a link to notes for each session. At the end of the month I would like to provide an email of “what we did this month”. I would love to have some of the data from the worksheet in a view I could share without fear that they see other people’s work. I know how to create views to filter and sort but there is no easy “cut/paste” way to put this in an email. And the sharing of the view would show everyone’s work. Any help would be appreciated.

Hi, my aim is to create a table with all my customer update details. I hope to archive when ever i send a survey to customer via Typeform or mailchimp platform. The answers will be create/add/update to my Airtable. The main identifier is by email address. Is this possible? Thank you

I would appreciate an option of when viewing in month calendar view that the day could list all records for that day without rolling them up to the default number of records viewable to 4. It would simply stretch the day on the calendar to include all records.

I’ve embedded an airtable form in a page built with Shopify. I wanted to prefill the form using the URL parameter, but I don’t know how to do it. I have embedded the Airtable form in a page built with Shopify, but am unable to get it to prefill the form values based on the URL parameter. I have seen a guide on how to do exactly this in Webflow here (screenshot also attached): How to implement prefill using URL parameter to airtable form embed in webflow - Custom code - Forum | Webflow Could anybody help me translate this into instructions for a Shopify page? Thanks so much!

Hello, I used miniextensions to take screenshots from an URL page. I set up the request but the screenshot doesn’t match exactly to the url linked. When I click on the URL, the page displayed is not exactly the same as the screenshot. I don’t know why ?

Je ne parviens pas à trouver comment créer un lien utm à partir du lien de partage de la vue, qui permettrait de mettre une campagne dans l’url, visible dans Google Analytics. J’ai trouvé l’option bitly, mais elle n’est pas reliée à mon Google Analytics. Est-ce que vous savez si c’est possible de le faire par un autre moyen ? :slightly_smiling_face:

Trying to install an API plugin for Wordpress and can’t seem to find it. I have the API Key, but can’t see an APP ID.

I am looking to run an automation or a script. I would prefer to use a button so a script would be better. Here is the scenario: I have a table with student information I have a table where I take daily attendance I would like to on a daily basis, preferably at the press of a button, copy my list of students from the name field in the students’ table to the name field in the attendance table. Notes: in the attendance table, where I want to paste the name is a linked field to the student table In the students table I want to copy the primary field

Hello, Any idea how I would transform monthly totals into a cumulative total over time? I’ve tried using an aggregate transform (presumably a count operator is what would do the trick?), but it keeps telling me wherever I insert it that is doesn’t belong :neutral_face: Basically, I would like to show two different versions of the same data; displaying the number of records created on a table over time by: Total each month (bar) Cumulative total over time (line) I’m able to layer a line chart and a bar chart of the month-by-month totals like so: { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Records Created", "width": "container", "height": "container", "layer":[{ "mark": "bar", "encoding": { "x": { "timeUnit": "yearmonth", "field": "Created", "type": "temporal", "sort": "x" }, "y": { "aggregate": "count", "type": "quantitative" }, "color": {"value": "#0000aa"}

I can’t get this field to sort properly. It sorts up to a certain point then seems to give up. I tried deleting/re-creating the sort rule, even manually sorting from the customize menu. I contacted ‘Support’ with this, they did not even respond.

Are there any update plans coming soon for Airtable: for example- being able to create forms from Ipad or mobile devices? I am aware they can be done from desktop-however most of my work is from my ipad and currently no “new form” views can be displayed in the IOS app yet. Just asking for any update plans to improve the IOS versions. Thanx :slightly_smiling_face:

Hi. I have been trying to reach Airtable to upgrade my system from Pro to Enterprise. It has been 3 weeks with no response. Not quite sure what else to do. Maybe I should beg them to take my $$.

There is no text on the field that is called something like “plot”, why is it disappearing? I have already written it three times but after reloading the page the field is again empty. I have already deleted the app and installed it again, but everything is in vain.

How do you make a primary filed unique?