Solved

I have a script that retrieves data from a google photos library using google apps script and writes the data to a airtable base, I have no coding experience and have generated the script through Chat-gpt. The script retrieves all the album names and the number of photos in each albums.          What I want to achieve is that a script should delete all the existing records in the specified base before writing new records to it, using google apps script. Can someone please help me by modifying the script for me?Here is the script that i use to retrieve data from google photos library and write the data to an airtable base: function syncAlbumData() { var apiKey = "apiKey-accessToken"; //paste your api or access token here var baseId = "Base-ID"; //paste your base id here var tableName = "tab3"; //paste your table name here // Get albums from Google Photos var albums = []; var nextPageToken = null; do { var pageData = getGooglePhotosAlbums(

Hello Airtable Community,I have 2 tables: Attendance and Performances. People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc.  This gets recorded in the Attendance table under their school name and quantity goes under "Number of Tickets." I also have a Performances tab that tracks total number of tickets available for the performance. I want to use a rollup or formula to connect the two tables and deduct the total SUM of tickets claimed from a Total Tickets Available number that I set (right now it is 1,000 tickets.)Ideally I am able to make this appear in both tables: Attendance and Performances. Can you help me?   

TLDR; how to I grant 'conditional' creator permissions within a paid workspace?I've built up some pretty robust Bases for my company to track our projects.  We're using airtable as a stop gap solution on the way to a larger ERP software rollout.  I built an interface for every department to use that allows them to view and update relevant information (process tracking, shipping address etc etc), and prevents them from viewing sensitive information (employee addresses etc etc).  No one has access to the Base except for me, everything is done through the interfaces.All of this is happening through a paid PRO workspace, everyone with interface access is a billable collaborator on my workspace.  It just so happens that we've hired a guy who's very fond of airtable and wants to build his own base for his own workflows, and sync a selection of my tables into his base.  I'm fine with that, but I'm not sure how to grant him creator access to the workspace (thereby givi

Is it correct that it is not possible anymore to add a new field within the mobile app? Or am I doing something wrong?

Hello ! I document the sales of my stores everyday on Airtable - each sale is entered with its date of transaction.I would like to get the sales average per day of the week (i.e know on which days we sell the most on average), ideally with a graph with the X axis being the days of the week. Is it possible ?Thank you ! 

Hi everyone,I'm trying to do a multi-step automation, where I :find records (questionnaires) using the "Find records" step*feed the records I found as "input variable" to a scriptuse that script to compute values, based on the field "grade" of each "questionnaire" in my "questionnaires" listMy problem :When I try to use the input as "list of record", the input is in fact an HTML string with which it's hard to work : console.log(questionnaires) => And it's the same if my input variable is a "grid", the only other option available.Is there a way I could get a nice, clean JSON as in input instead of this nightmare ?Thanks 🙏  * I do this instead of scripting my query because the database is huge, and I get out of memory errors when I try script it

Hi all,I try to run this script :"when a button is clicked in an interface this script is running. It's pointing to another automation triggered by this webhooks to create a new record in a table.  const URL_AIRTABLE_WEBHOOK = 'https://hooks.airtable.com/workflows/v1/genericWebhook/XXXXXXXXXX/YYYYYYYYYYY/ZZZZZZZZZZZ' let config = input.config() let response = await fetch(URL_AIRTABLE_WEBHOOK, { method: 'POST', body: JSON.stringify({'dossier_record_id':config.dossier_record_id}), headers: { 'Content-Type': 'application/json', }, }); console.log(await response.json());  But It returns :ERRORThere was an unexpected error while executing your script.I'm tired and I don't see my error... After all I want is to create a new record in a table when a button is clicked... is there another to do that ?Thanks !

I have start dates and end dates for each project in a list of about 50 projects. I want to create a filter that will only show me records that were active between the start date and end date during specific fiscal years (where I set the FY date parameters). Some projects span multiple fiscal years, so "on or after" or "on or before" doesn't cover everything.

This is my data, inclusive of images, and the ensuing results I'm obtaining from Airtable on Make.com are clearly visible.However, there seems to be a slight issue. Instead of receiving the value 1014.40 as expected, I'm getting 1014.4000000000001.Could you guide me on how to rectify this discrepancy?      

Hello, Is it possible to have numbers in a base with more than 8 significant figures? We sometimes work with very small numbers ranging from -E10-11 and the current method rounds the numbers/cuts off at 8 decimal points.  Thanks

Good afternoon. (UK)Yesterday, I happily copy/paste content from rows to the Comments when a message with an error popped up to refresh. I did, only to have to redo the unsaved Comment I was working on. This happened a few times, so I checked on AT state, and no issues were reported. I experimented with another entry as that was saved I concluded there is a limit on the number of words or characters for each comment. Is that so?  (I managed to save the comment by split the content into several separate Comments, but that's not ideal)Also is it possible to re-order the Comments or insert a new Comment in between existing Comments?   

Hello!I am trying to create a formula which gives an output of difference between two dates (Premium date & Last month from Today date - as seen in the last 2 columns). The base is primarily used to manage my Insurance payments, so keeping that context in mind if its helpful. The issue is - I have two Premium dates in my table (because some times Premium might be half-yearly frequency payment). So, in order to get the difference in dates for only 1 date (Yearly premium) - I used the following formula:IF({Plan status}="Active", DATETIME_DIFF(DATETIME_FORMAT({Premium pmt date},'DD-MMM'),DATETIME_FORMAT(DATEADD(TODAY(),-1,'month'),'DD-MMM'),'DAYS'),'NA')And this is working fine.But, when I introduce 2 dates into the formula - I also need to use a MIN() function that gives me the lower of the difference values.Here is the formula I tried using for it, but it returns NaN -IF({Plan status}="Active",MIN( DATETIME_DIFF(DATETIME_FORMAT({Premium pmt date},'DD-MMM'),DATETIME_FORMAT(

Hi! I want to build RMA base and I'm struggling with the basics.. do I create one base with multiple tables or just one table? Can someone share their template which can help me build the structure?Thanks.

I've built a Slack automation that posts notifications to a channel when user requests are fulfilled. I would love it if it would "@" mention the requester to notify them when it's posted, but in testing I found that while it would show the display name (e.g. "@Anna"), it isn't activated and doesn't trigger a normal Slack notification. Has anyone found a way to make this work?

I'm new to Airtable and would love some help! I have a general inquiry form on my website. Once someone completes that form, I eventually need them to complete a second, more in-depth form. Is there a way to link the responses of the in-depth form to the original "general inquiry" record? Essentially, I'd love to be able to have all information related to a potential client connected. I hope that makes sense! Please let me know if I need to clarify anything. 

Hi,I'd like to know how I can move specific rows of data to another table. I have already created an auto move using the extensions however I'm not 100% sure if this will move all data or if I can select what gets moved.Thanks.

Trying to accomplish this simple formula but it results in an error???Using a Single Select Field and a Currency Field.{Toe Kick LI} * {Toe Kick Cost Per LI} Thanks in advanced for your assistance!

I've got a table with People informationNameGenderEthnicitySallyFemaleBlackJohnMaleWhiteMarkNon-BinaryWhiteAnd a table with events:EventDateParty2022-01-02Service Project2022-02-03And a third table with lookups that pair people with events:Master ListIDEventPerson1PartyMark2PartySally3 Party John4Service ProjectMarkSo, what I need is a way to summarize the attendees, like how many white people were at the Party.Seems like I should be able to do that with rollup fields on the event (since it's linked to the people on the Master list) but while I can get a list of the "person"s who were at the event, and get a list of those on the "event" table, I don't see how to probe the people table to get the info I want...Do I need another table?

Hmm, I feel like this should be easier, but I'm running into a stumbling block.I have a Multiple Select column {Dubbing VO (all languages)} that has a list of VO actors. Each name begins with the two letter code for what language they are working in. i.e. ES for Spanish, HI for Hindi etc. There are multiple actors for each language.Then I have another column that is the VO artist per language. i.e. {ES VO actor}. I'm currently using the formula below to pull in the selected name that begins with that language's code. The problem I'm running into is when there is more than 1 ES actor on a project. It only returns the first name it comes across. The code I'm using as an alternative returns all of the names in the {Dubbing VO (all languages)} field.Code that works for 1 name:IF(FIND('ES', ARRAYJOIN({Dubbing VO (all languages)}&',')) > 0,TRIM(LEFT(RIGHT(ARRAYJOIN({Dubbing VO (all languages)}&','),LEN(ARRAYJOIN({Dubbing VO (all languages)}&','))- FIND('ES', ARRAYJOIN({Dubbing

I have a table created like the one on the picture and would like to create a concatenate field with the name of the columns that have stars associated with. Is it possible?For the first record the formula should return (M&A, IPO, Turn Around, Financiamento/Captação), for the third record the formula should return (IPO, Planejamento Estratégico) 

I have a table that collects user reviews, and includes a multi-select field as one of the elements for their reviews I want to aggregate the data from this table to generate average ratings etc. I wan to generate an aggregated summary of the multi-select field content, so that the summary field will contain a single instance of each element in multi select fields belonging to the various reviews. I’ve tried using a Rollup field with this formula : ARRAYUNIQUE(values) but I get repeated instances of values that appear in more than one of my original reviews. What’s the right way to distill this down so I see only 1 instance of each multi-select option in my aggregated record?

Hi everyone!I have two lookup fields, each one of them with a list of dates, and I need to merge them in the same field, keeping the date format. I've been testing with some formulas like concatenate, arrayjoin, dateformat... but I haven't been able to solve this problem. Do you know how to do this? In case more detail is needed, I have a table with employees, another with Time Off Request and a third one with Holiday Calendars. Each line in the Time Off Request tab is linked to one employee who has requested that day off. Each date in the Holiday tab is assigned to several employees who are going to be off that day. Then, in the employee table, I have a lookup field for the dates from the Holiday Calendar tab, and another lookup field for the dates from the Time Off Request tab. I need to have all those dates in the same field and in a date format to be able to use it in a Timeline view. Is this possible?Thanks for your support!!Best regards,Mar

Hi! I'm new to creating formulas. I can create two IF formulas in independent columns, but am struggling to combine them into a single formula to communicate a task is due in ___ days, but to also make this countdown stop when a task is completed.This formula is dependent on two fields: Due Date and Status (Not Started, In Progress, Done).I need this formula to create 3 potential outcomes:BLANK, if no Due Date was entered. __ DAYS, if a Due Date was entered and the task is not complete.✔️, if a Due Date was entered and the task is complete.I achieved #1 and #2 with this formula: IF({Due Date}, DATETIME_DIFF({Due Date}, TODAY(),'days') & " days")I achieved #3 with this formula: IF(Status="Done", "✔️")But I am not sure how to combine these into one single formula, in one single column. 

Requesting assistance with the following formula I am unable to get to function properly. IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}<=20, {Document Received}=BLANK(),"Pending")(IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}>20, {Proof of Service (Differential - Proof of Service+(x)Days)}<50, {Document Received}=BLANK(),"Delinquent"),(IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}>50, {Proof of Service (Differential - Proof of Service+(x)Days)}<60, {Document Received}=BLANK(),"Submit Complaint to Review Board")))))) Objective:If (Differential - Proof of Service+(x)Days)}<=20 and State="Florida" and {Document Received} attachment field is empty, fill the formula field with "Pending Document" If (Differential - Proof of Service+(x)Days)>20 but <50 and State="Florida" and {Documents Received} attachment field is empty, fill the formula field with "Delinquent Document"&nb

Hi all, I have a record picker in an interface. I need it to automatically do certain actions taking the name or ID from the record I click on the list. Does anyone know if there is a way of retrieving the identifier of the record being clicked? Does some trigger type detect that a record in the picker was selected? I failed to find something searching through support articles. Maybe someone can confirm whether such a feature was actually implemented in interfaces, or can suggest some smart trick. Thank you.