Solved

Hi there :slightly_smiling_face: I have a very simple code involving if statements and buttons but it’s not working. I’ll explain further below my code: let sale = await input.buttonsAsync("Is the vehicle set for another service or will it be sold/scrapped before then?", ["Yes, another service date", "No, will be disposed"]); if (sale = "Yes, another service date") { let plan = await input.buttonsAsync("Is the next service on a date or at a specific mileage?", ["Date", "Mileage"]); if (plan = "Date") { let date1 = await input.textAsync("What is the date of the next service? ( eg: May 1, 2022 )"); let format_date1 = new Date(date1); let format_date2 = new Date(format_date1.setDate(format_date1.getDate()+1)); let final = format_date2.toISOString() let field = table.getField("Next Service (if Date)"); let confirm = await input.buttonsAsync("Are you sure you want to update th

How to remove the calendar-view’s button tooltip?

Hi all, I’m trying to email multiple people in a record with a button field. I’ve almost got it but when I can manage to get both email addresses to show up, they are joined together and the second email address is a bit off using a % instead of the @ (although I think if I could separate them it would resolve). This is what I’m using: “mailto:”& ENCODE_URL_COMPONENT(ARRAYJOIN({Seller 1 email})& ENCODE_URL_COMPONENT(ARRAYJOIN({Seller 2 Email}))) & “?subject=” & Property I’m trying to paste an image but I can’t see in this email draft… How do I get the addresses to be separated? I’ve tried all I know how to do, quotes, commas, semi colons…I’m at a loss. The other piece is the cc portion which I’ve only seen gmail examples and they aren’t working in a generic email. Thanks in advance for any help!!

Hi there, I’m new to the Airtable. I’m wondering if it’s possible to store JSON data in a cell ? For example, if I have a User table, and inside this User table, I want to store an array of objects for every user about the videos the user has watched. Is it possible ? :thinking: :thinking: e.g. Can I store the data ( similar to the code below) in a cell ? { data:[ {videoId: 1, videoTitle:"some thing", videoDescription:"some text"}, {videoId: 2, videoTitle:"some title", videoDescription:"some text"}, {videoId: 3, videoTitle:"some other title", videoDescription:"some text"}, {videoId: 4, videoTitle:"fourth title", videoDescription:"some text"} ] } What’s the easiest way to create this relationship ? Do I have to create another Video table? :thinking: Any suggestions ? THANK YOU !! Scenario: e.g. User Amy watched video#1, video#2, video#3, and video#5 e.g. User Bob watched video#1, video#4, video#5 ( I have a total of 100 videos )

Hi- We’re trying to get Airtable to sort a list of records by the most recent linked record. Basically, we want Airtable to ‘understand’ dates in a linked record. Here’s the basic flow: One table we have is the ‘Sponsor’ (advertiser) who has purchased a ‘Sponsorship’ (advertisement) The ‘Sponsor’ is linked to every individual ‘Sponsorship’ that it has bought Each individual Sponsorship is its own record, with a Date field as the primary field in the linked Table What we want is for Airtable to know what date a Sponsor’s most recent Sponsorship ran (or, what is the latest date of a Sponsorship linked to a particular Sponsor) With this, we’d be able to allow our users to sort by Sponsors who’ve run an ad recently (say, in the last 30 days) The problem is that even though each Sponsor has all its Sponsorships linked to it, I don’t see any way to get Airtable to use the linked Sponsorship records to sort Sponsors. We’ve tried a Lookup field of the date of the Sponsorship, but Airtable tr

Hi Airtable Community, With sample scripts that I found here, I was able to create a script to duplicate a record, and I’ve set up the script to run on a button. [So, thank you for all those how-to scripting posts!!] However, I was hoping to be able to limit access to the button, so that only the right people could click and run the script. But, on the button field the option to set “Edit field permissions” is grayed out. I know I can hide the button from certain views, but my users do know how to copy a locked view and hide/show whatever fields they want in their personal or collaborative view. Is there another way to prohibit who can click a button, since field-level permissions are not an option? Thanks for any help provided.

Hi, I’m currently developing a WhatsApp chatbot using Node.js. I’m implementing a functionality where the bot stores the specific responses from the users in airtable columns. But when I was going through the community I found out that it’s not yet possible to create columns programmatically. So for time being, I wrote a program that updates the field say Responses The problem I’m facing is when I call the update function it overwrites the existing record. Is there a way I can append the new value to the existing record without overwriting the old value?

Hello community, I’m using Zapier to send data from other apps to Airtable The zap starts with a CRM called Streak, it includes a variable “company helper” with value “Diamir” The Airtable action is writing “company helper” into the “company” field: The data in is correctly shown “Diamir”. But the data out becomes “recPLcGiYMFsYsWPT” Which equals FIT and not Diamir Can someone help illuminate me as to what may cause the difference between in and output? Thanks!

Hi guys, Need your help in scripting. I want to concatenate month and templateName to another table using scripts as individual records. My desired output is e.g. templateMonth; templateName 2022-01; HD-HD1460, TR144 | 1 x RM-HD 2022-01; HD-WHITE | 5 x RM-HD, 1 x RM-WHITE How do I achieve this using a button? Thanks.

For example you send a form to a client, they complete, save and send the form back with only half the information. They are then able to revisit that same form link at a later stage and see the fields that they can then complete at that later point in time? Thanks Brian

I’m trying to bulk upload records from an excel file. the columns match. but whenever i finalize the upload, airtable creates my new records AND it also creates a boatload of blank records. this is particularly irritating because i am doing an initial upload of many records into a table that has automations that create records in a different table whenever records are created in the current table. so now i have to delete the blank records from the one table, and go delete the blank records from the other table too. is there a way to set limits on what airtable imports from excel? i assumed it would stop importing when there wasn’t data in the cells. but this is not the case.

I apologize if I missed this out there, but I tried searching for a similar answer but couldn’t find one that matched exactly or I could learn enough from. Unfortunately my knowledge of script language is borderline zero. High-level explanation: I have a multi-stage project process that I am starting to build in Airtable that I am curious if am automation is possible, where a button can automatically create tasks from templates as you work through a project. Details: Currently my process has 2 main components, the Submission/Review process and the Launch process, with a task table for each process linked respectively. The tables are laid out like this: Submission/Review Captures new requests from a form and has data fields for review steps Fields related to this automation: Vendor; single line text (primary field) Stage; single choice Assigned to; collaborator Stage tasks created; multi-select with same options as Stage Submission/Review Tasks Houses the standard tasks for each

If I am over my extensions limit, do I need to delete them from my dashboard, or can I simply disable them? I have some that I use very infrequently, but I’d like to keep them around if possible, enable them when I need them, and then disable again.

I seem to have access to a new feature that let’s me build a filter based on an exact linked record object. But the way I get access to it seems to be a bug. If I try to build a filter by chosing a linked record field, I only have the options of [‘contains’, ‘does not contain’, ‘is empty’, ‘is not empty’]. However if I start my filter on a different field type, such as a formula or text field, I can chose the filter option ‘is’. Once I have selected ‘is’, if I then change my filtered field back to a linked record, I have a new option to filter my linked records with ‘is exactly’, and I am presented with a standard lookup list to choose from. Unless I have missed something, this is a huge new feature that I can put to good use. I have added some screenshots, let me know if others have the same thing.

Hello everyone, I am having an issue with a pretty simple if statement with !=blank(): If({Date}=blank(), “Blank”, “Not blank”) - this returns “Blank” if the field is blank and “Not blank” if there is something is entered - as it should If({Date}!=blank(), “Blank”, “Not blank”) - this returns “Blank” no matter if the field is empty or not Am I missing something? Thanks, Jordan

I am creating standard project tasks from a template and am stuck with writing a formula that creates a comma-separated text string from the names of linked records but also adds the project name to the front of each record name in order to make it a unique name. For example: my linked template records are Cat Dog Cow and the projects are Project 1, Project 2, etc. I want the resulting field to be Project 1 - Cat, Project 1 - Dog, Project 1 - Cow, and so forth. That way the “Cat” in project 1 is a unique record from the “Cat” in project 2. Any help would be greatly appreciated!

Hi all! I have a formula field that calculates a variety of numbers into an average and then translate them into star ratings, here: REPT("⭐", ROUND(AVERAGE(IF({Overall Review NUMBER not accepting 0 rating (from Reviews)}, {Overall Review NUMBER not accepting 0 rating (from Reviews)}, 0)), 0)) This works great, except when there is no star rating submitted, then the “number” is seen as NaN, and the formula spits out “#ERROR!” Can anyone help update this formula to say: if result=“#ERROR!” then leave field blank ? IF it really needs to be done in the number sequence calculation step, I’ll give you that info: My formula for creating the number sequence in “Overall Review NUMBER not accepting 0 rating (from Reviews)” from above is this: AVERAGE({Work/Life Balance}, {Pay & Benefits}, {Culture & Values}) I previously tried to turn NaN into 0, but then it factored in “0” into my average, which I don’t want because it brings the average down inappropriately. That code WAS: ROUND(AVE

Hi, I have a list of Jewelry Stores that contains all the pertinent information about the store and also my contact at the store. I have imported this list into a table but would now like to create a separate table for just my contact at the store so that i can put more information (email, cell, social media). Is there a way to do this?

Hi, struggling with a formula / best approach for calculating dates based on a condition. Fields in scope are as follows: Meeting Type = Single select option Date = Date Meeting to take place Request for information = calculated date based on meeting type selected. So if for meeting type I choose ‘x’ I want request for information to populate a date 8 days prior to the ‘date’ field (which is already populated with a date) If for meeting type I choose ‘y’ I want request for information to populate a date 11 days prior to the ‘date’ field within the request for information field. Previously the calculated dates were identical regardless of ‘meeting type’ and the ‘DATEADD’ formula worked fine. Now I need to make it conditional, I cannot seem to get an if statement formula working correctly. Any help would be greatly appreciated.

Newbie here (with the obligatory “newbie here” intro lol): I have a problem I can’t seem to solve despite reading multiple version of what I think are similar problems with solutions that don’t seem to work. I will try and describe what I have and what I want: I am an artist looking to track collectors and paintings. I have successfully created 2 bases: 1. Base 1, Artwork: This base contains 3 tables. Each table is a category of art. Each table contains title, price, availability (sold or not) etc. 2. Base 2, Clients & Collectors: 1 table with list of clients and fields that include name, address etc. Successfully implemented: The bases are synced. In base 1 of Artwork is has a table that is a shared view from the client base. In each art work table I have linked a corresponding client. So if I go to Base 1 Artwork, go to the Landscape table, go to a painting that is sold, I can see who the collector is. If I open a collectors record I can see all the paintings they have purchased

Currently in REST API - Airtable for my base, I see this in description for creating a record: Your request body should include an array of up to 10 record objects. Each of these objects should have one key whose value is an inner object containing your record's cell values, keyed by either field name or field id. But when I use this code: table.create([{ "key": { "id": "45673157744282"}, "fields": { "purchase_date": "2022-01-08T01:49:22Z", "orderID": "155-5041239-4465010", "order_status": "Shipped", "sales_channel": "Amazon.com", // ..... } },]).then(result => { console.log("Result=", result); }).catch(err => console.log("Error=", err)); I get this error: AirtableError { error: 'INVALID_REQUEST_UNKNOWN', message: 'Invalid request: parameter validation failed. Check your request data.', statusCode: 422 So all I need to do is to be able to pass the key (id of the record to be created) while calling the .create(). How do I do it?

Hello all, my Friday afternoon brain just can’t get my head around this. I have a large database set up for our members and need to add new functionality to it. I have duplicated the base to try and nut it out. I need a column that is for ‘past groups’, of which people could have been in several. I then need another column that relates to current or non current member based on these groups. So Member 1 was in group 1, group 2, group 3 Member 2 was in group 2, group 3, group 4 Member 3 was in group 4 if group 1 ended 2016, group 2 ended 2020, group 3 ends 2022 and group 4 ends 2023 So the current member should only be showing yes if the member is in either group 3 or 4 I am not even sure if that makes sense. I need to set up a view for current members but don’t want to manually change each, I need a way to automate it based on the group they are in. I have tried looking at classroom-type databases, but just can’t work out how to automate that current & past option based on a group d

I’m using a Timesheets table to record employee timesheets. I’m then using an Employees table to rollup the ‘Time Worked’ durations. I only want to see the ‘Time Worked’ for today. I have my rollup conditions set as follows: “only show linked records from the Timesheets table that meet certain conditions: Date is today” However, I’m in Sydney Australia which is +10 hours GMT. I don’t see any way of offsetting this time (as it’s only a filter within a rollup field). How can I make the rollup filter ‘today’ line-up with Sydney’s ‘today’?

Hi, This is my current formula for an If not blank > do this OR if blank > do this: IF({Discount}, {Brand} & " Discount Code: " & {Discount} &" off -", IF(NOT(Discount), {Brand}))& " "&{Product Title} But I would like to add another option that if {column} contains “FREE TRIAL” or “FREE SAMPLE” to do the same as the first line but without the '“off -”. So far I have this: IF({Discount}="FREE TRIAL", {Brand} & " Discount Code: " & {Discount} &" - " & {Product Title}, {Brand} & " Discount Code: " & {Discount} &" off -" & {Product Title}, IF(NOT({Discount}, {Brand}& " "&{Product Title}))) But it’s glitching and I know the formula isn’t correct but hopefully, someone can please help! :grinning_face_with_big_eyes: Thank you!

Hello! I’m looking to create a “Daily Company Dollar Report” using interfaces. So far it’s been great showing projected and closed orders and revenue and popular servies… however, I just realized these will show “to date” records. We would like to look at this daily to see where we are for the month. Is there a way to filter the elements to show me records from x/1/2022 to x/31(28 or 30)/2022 to show THIS month’s status?? I see you can filter “in the past month” but if I’m on 6/15, that’ll show me data from 5/15-6/15 not 6/1-6/15. I don’t want to have to update the filter every month either… a “since beginning of the month” to “end of the month” would be GREAT, but I don’t see that filter or work around just yet. Thank you!