Ask the Community

Hi guys, I created a simple CRM for a client on Airtable. The page for All Contacts have filters. My client would like to be able to set filters on this All Contacts page and then, from the interface, send an email to the subset of contacts she just had displayed (see screenshot below).  The solutions I have in mind don't completely meet her need:Setting automations to have emails sent to different groups of people doesn't solve her problem since she wants to be able to send emails spontaneously. So there's no event in the database that could serve as a trigger for possible automations.She could of course export the list of contacts into a CSV, then copy and paste the email addresses into her email provider interface. But that's manual mindless work that I'd like her not to have to go through. I think the first step towards finding a solution is the ability to select contacts directly from the interface. How can I do that? Thank you for your help.

Hello all, I’m trying to figure out a way to randomly generate a 6 digit randomized number for confirmation use on future bookings. So far I’ve come up with using ‘Autonumber’ and a formula to add six 0’s as a prefix. However, I’d like the number to be completely random. Does anyone have any input on how to achieve this or if it’s possible on Airtable? Thank you! Alex

I have multiple lookup fields with similar data but from different sources that i would like to have merged into one lookup field. Is that possible and if so how?

Hello All,I have been implementing new Form Interfaces for our candidates to fill out and I noticed that the banners and images have been getting removed; initially I thought it was because I duplicated the Form (which auto-removes the images), but when I checked on them a week later, all the images and banners were gone!Has anyone else experienced this issue? For clarity, I published and distributed 2 Form Interfaces, which I spot-checked and tested before and AFTER they were sent out to everyone. I can add screenshots if requested, but there's nothing really to show aside from the images.

I'm trying to create an automation to deselect the option 'language' from the multi-select field 'todos' in the table 'Post'I'm doing this through a combination of automation and scripts.I'm new to scripting and put together this by looking at some examples from the community and asking ChatGPT, but it's still not working.Anyone so kind to give it a pass and point me in the right direction? // Prompt the user to select a table and fieldconst table = await input.tableAsync('Select the table (e.g., Post)');const singleSelectField = await input.fieldAsync('Select the single-select field (e.g., todos)', table);const singleSelectValue = await input.textAsync('Enter the single-select option to deselect (e.g., language)');await main();output.markdown("# Done");async function main() {// get the recordlet record;while (!record) {record = await input.recordAsync(`Select a record in the ${table.name} table`, table);if (!record) {output.markdown('You must select a record to continue.');}}&nbs

Greetings Everyone,I would like to know if I can copy values from field to another field automatically without using formula or rollup.I have attached the screenshot of my table for your ref. I need to copy the values from the original fields to the helper fields automatically.Please advise.Regard,Thanveer

hello every one,so i set my trigger on "When webhook received" (i receive a webhook for every new order in shopify) the problem is i wont to create a line on airtable for every line item and it has to contain all clients detail and product info related to that line item, any help would be appreciated.

Based on an earlier post on connecting airtable data to Power BI, some folks, including me, have problems reading Airtable fields/columns that have blank/missing values for some records. Based on an note from a user in the early post, I am able to revise the Airtable M Query code from the Airtable support site (https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query). I added the "List_fields"= line near the end of the query. Now the new M Query can read in all columns / fields of an Airtable table even if they have blank/missing values.Here is the revised M Query. Hope this can be of help to you.let Pagination = List.Skip( List.Generate( () => [Page_Key = "init", Counter=0], // Start Value each [Page_Key] <> null, // Condition under which the next execution will happen each [ Page_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null, // determine the LastKey for the next execution WebCa

Hi guys ! I work in a Shopify ecommerce and we are in the process of integrating Airtable into our environment. We have started to synchronize our data (Products, orders, customers, etc …) in Airtable using the AirPower app. Airtable seemed like the perfect platform until the data limit was exceeded (50,000 for the pro plan). We looked at the business plan but the 100,000 data limit seems very low. We have 63,000 customers right now so we should hit the limit sooner or later. We want to have the orders table linked with the customers table. Do you have a solution so that we can store all our data? Thank you in advance !

Require some help on moving/changing data between Airtable and Shopify, using integromat. Reason? We have items where stock is managed in Airtable and Shopify. Shopify is used for items sold online, the Airtable system for items associated with jobs within the business (the items are automotive parts, so we sell some, and use some internally). The reason the items are managed on Airtable is for integration with other data/information requirements. Stock is managed in Airtable by having 1x table that is a list of items, and one times table where a stock adjustment record is added. Example, Item A exists in the list table. On the stock adjustment table, if stock is removed, a line is added that links to that item, with ‘1’ added to a Stock Out field, likewise for stock in. On the list table, the stock amount of Item A is calculated as a simple In minus Out roll-up. We have put together an Integromat automation that watches Shopify orders, and can add a new stock record when an order is p

I already posted some order integration code before: https://community.airtable.com/t5/development-apis/shopify-order-integration-code/td-p/198332This time it's a simple script to sync products from Shopify to Airtable, if anyone is interested. The code can be found in this repo:https://github.com/codeupify/functions/tree/main/shopify/airtable-product-syncThe code is in Python and using Flask as a webserver that you can host somewhere. There is also a serverless solution available here if you don’t want to spin up your own server:https://codeupify.com/f/gl9av2maG1

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remain separate would be ideal, but otherwise, it could just be text formatted like this "MM/DD/YYYY, MM/DD/YYYY").Then I'd like to have another column that shows the oldest date and a column that shows the most recent date.Another column that just adds the number of times the content has been published, so counts the number of fields with a date in them.The error you see currently in the far right field had the formula that I tried on my own which was:DATETIME_FORMAT({Publish Date 1}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 2}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 3}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 4}, 'MM/DD/YYYY')A screenshot is attached. Thanks in advance!

how could i use zapier sync the Unsubscribes that can remove the record from Airtable?

Trying to connect Airtable to MailChimp using Zapier but keep experiencing errors that no email address is found. Goal is to enter contacts for local business owners in Airtable and also have them automatically added to our email list. Anyone having good luck using Zapier to update a MailChimp list who might tell me what I’m missing? It appears that when we enter a name of a person in Airtable it’s creating a record, which triggers our zap in Zapier. Well, if the email is not the first thing we enter it seems like it’s too late, the zap is already triggered and the email is not sent to Mailchimp. So my question is how to make a record create zap work where it’s not so quick to send the data that some of the data isn’t there yet.

Hey!I am trying to update a record based on the user's id, currently, I have this code but for some reason it errors saying: TypeError: Invalid arguments passed to table.updateRecordAsync(recordOrRecordId, fields): • recordOrRecordId → recordOrRecordId should be a Record, not a number (5) or recordOrRecordId should be a string, not a number (5)Basically I am trying to update the field URL for the user based off their user id, the text I want in the field URL is from the "strHash" stringlet table = base.getTable("Participant"); let record_id = inputConfig.record_id; await table.updateRecordAsync(record_id, { "URL": strHash })   

Is there any way to create a view with specific fields in Airtable, and sync it with Asana so that when a record is added to that Airtable view, a new task will be created in Asana, including those specific fiels from Airtable? I know a premium Asana subscription is necessary to add custom fields to the tasks. But does anyone know a way to sync these fields between both apps? Thanks.

Hi All,I hope this message finds you well!I’m currently working on a project in Airtable that involves two different bases, and I need help ensuring that when a record is marked as "Complete" in one base, it also reflects as "Complete" in the other base without the person manually marking 2 separate records in different bases. Here's a loom video - https://www.loom.com/share/fdb6298730f3446cb3f74afe0979669c?sid=5744e56b-d093-47d5-bf70-15f75bc4773d.If anyone has experience with this or could offer guidance on the best approach to set this up, I would greatly appreciate it!Thank you so much for your assistance!

I have an interface with a dashboard with two pivot tables tracking budgets.I have a dashboard page set to allow printing; however, every time I print, one of the two pivot tables are cut off although they both fit on the page, and there is no horizontal scroll needed. I've tried to expand the table and print them one by one, but then the same cut-off still happens.This is how the pivot tables look on my screen only - only 5 columns to print: This is how it looks on an A4 page - where the two last columns are cut off:Does anyone know how to get these two pivot tables to actually print out so the printout is usable, or is it a bug?

I am trying to integrate airtable to make.com to do outbound calling to vapi. I'm having an error message / not getting a connection option. In make.com to Airtable connecting my airtable OAuth connection is empty error message is showing - the base error value must not be empty.

I have a base and a Main View for Selection. I enter the main view and select a few things.   The go to the view selected items.the latest selection don't show up and they are not just out of order etc.  Going back into the Main View for Selection and then going back to the View Selected Items now shows the selected items.Why do I need to go back and forward to see the selected items.The filed is a tick box in the form which works OK but the view selected only updated on the second enter.Thanks for your help,Peter Wallis

Hello,I am using actionable messages in slack to approve or deny purchase requests, holiday requests etc. Usually when I use interfaces for this I have buttons which update a field with the user who approved the request. I'm not sure how to replicate this using the slack actionable messages. There seems to be a token for 'user that took action' but I can't get it to populate either a user field or a text field with anyhting

Hi there,I'm trying to build automations for updated a multiple select field. The records in my table all have a "last updated date" field, which obviously changes every time a record is updated. There are two scenarios I am trying to solve for:1. When it has been over 12 months since the last update, I would like to add a tag in a multiple select column for "Last updated >12 months". I have figured this out using these instructions. 2. The next scenario I'm trying to solve for is when a record whose last updated date was >12 months ago (and is tagged "Last updated >12 months" is updated, therefore changing the "last updated date" field, and wanting to remove the "Last updated >12 months" tag from the multiple select field. How do I accomplish #2 with an automation? I can't figure out how to do this by either removing all of the options in the multiple select field (not ideal) or removing just the "Last updated >12 months" tag. Help please!

Hi allI have an orders table, an order line items table and a products table.In interface, i want my staff to make orders using the products table where they 'add product to new or existing order'.So when they click on the product this should bring up order line items form to add quantity, sell price etc of selected product and then either create new order (parent table of order line items) or link to existing order (order ID, vendor, consignee etc)Any ideas? Thank you!

Hi, I want to update the choices a singleSelect field has without adding a new record.I tried this approach, but that yields the following errorTypeError: Cannot add property 2, object is not extensibleHere is the relevant code (MtypeName gets its value from a singleLineText field)let MtypeName = Mtype.getCellValueAsString("Meeting Type") let Types = MeetingsTable.getField("Meeting Type") Types.options.choices.push({name: MtypeName}) I this possible without residing to API calls?If this is only possible using the Rest API, I suppose I cannot use this without providing the authentication details, right ?

I am tracking two kinds of activity related to a list of locations that I keep in a table called LOCATIONS. One kind of activity (programming) has very specific dates. The other kind of activity (development) is hard to pinpoint in time so I do not want to assign specific dates, but I do want to know what calendar and fiscal year activity is happening. My question is, should I create one table for all location activity, so I can see it all in one place for each location (when grouped by location), or should I create two tables and then look at my LOCATIONS table to see all linked activity? Or maybe just track development activity in the LOCATIONS table? Thanks!