Solved

Hey, I have a problem with a repeating group, it does not accept my script as input source. // Load and filter table const table = base.getTable("Contact List"); table.selectRecordsAsync({ fields: ["First Name", "Last Name", "Title", "Email", "Phone Number", "Organization", "Address", "City", "Region", "Country", "Zip Code", "Marketing Consent", "Tags"] }) .then(queryResult => { const queryRecords = queryResult.records.filter(record => ( record.getCellValueAsString("Marketing Consent") === "true" && (record.getCellValueAsString("Tags") === "Fliese des Monats") )); const dataArray = queryRecords.map(record => ({ "firstName": record.getCellValueAsString("First Name"), "lastName": record.getCellValueAsString("Last Name"), "title": record.getCellValueAsString("Title"), "email": record.getCellValueAsString("Email"), "phoneNumber": record.getCellValueAsS

It seems like it should be a simple solution, but my brain is tired! I am using a rollup field to show the total discount so I can highlight it on a quote which I have made with page designer. If there is no discount ($0.00) I don't want it to show on the quote. So I am trying to figure out how to leave it blank when there is result is $0. I tried adding another field with a formula, but then I can't get a positive number to be in currency format, just a string. I tried doing an IF Aggregation formula but kept getting an error. I made sure that the source field (Amt Saved) does not return anything if the result is 0 hoping that would follow through to the rollup, but no luck. Can someone please help? 

I have written this formula a few different ways and in each case, I get the result but am unable to format as currency. Error: 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 the two most successful attemps:IF(AND(OR({Channel} = "Print",{Channel} = "Digital"),{New | Repeat} = "New"),IF({Channel} = "Print","$" & VALUE("450"),IF({Channel} = "Digital","$" & VALUE("75"),"")),"")IF(AND(OR({Channel} = "Print",{Channel} = "Digital"),{New | Repeat} = "New"),IF({Channel} = "Print",450,IF({Channel} = "Digital",75,"")),"")Any insight is greatly appreciated!!!

 I have a table with two columns: Url and QR Code.  I would like to run a script that will modify the QR Code field when the Url field changes.I created an automation that fires a script when the Url changes.  I'm trying to determine how to modify the QR Code in the row that changed.The script: /** * Generate a QR code from text, using QuickChart.io (https://quickchart.io/documentation/qr-codes/) * @param {string} text The text to be converted. * @returns {string} The QR code's URI */ const getQrCodeUri = ( text ) => { const serialize = function(obj) { var str = []; for (var p in obj) if (obj.hasOwnProperty(p)) { str.push(encodeURIComponent(p) + "=" + encodeURIComponent(obj[p])); } return str.join("&"); } const settings = { text: text, size: 150, margin: 4, dark: 'f00', light: '0ff', ecLevel: 'Q', format: 'svg' } const qs = serialize(settings) const baseUri = 'https://quickchart.io/qr'

Hi community,I can't tell if I made a mistake or if something changed on Airtable's side.Regarding direct URLs to records in shared views (which we communicate in our newsletter):yesterday this link was working:https://airtable.com/shrWJrPQd2lifr4L3/tblJhdIMn9FcFICXU/viwTjYmLJJpWjS63I/recZEI7ZRdrSRMpkP?date=2023-09-28&mode=undefinedThis morning, not anymore. It says "The private share link you tried to reach is not available."The link to the same record that works today is: https://airtable.com/app1HxCoK9bV1SDUV/shrWJrPQd2lifr4L3/tblJhdIMn9FcFICXU/viwTjYmLJJpWjS63I/recZEI7ZRdrSRMpkP?date=2023-09-23&mode=undefinedDifference is the base ID "appXXXXXX" that wasn't needed yesterday apparently?Anyway, yesterday's link is out in the world now, but doesn't work.Anything I can do?I found this article related to the issue, but dates back dec 2021.Thanks for any light you might shed on the topic.

In an email automation, I am trying to populate the "From" and "reply to" fields from a user card (see attached screenshot). However, when I preview the message, both fields are blank even though the field has a user card that is associated with both a name and an email. Is it possible to populate the "from" and "reply to" fields in this way?

I have a formula that works as is today, but I'm trying to add a condition to it and it keeps erroring out?  Was hoping to get some extra eyes on it?What we're doing today is taking 3 different date fields, convert them to a #, and then display the max of the 3 fields.  This might be a weird way to get where we need to go, but it has worked for us.  All the "correct" fields are date fields in our base.Formula today:IF(   OR({Correct Lift + 45}, {Correct Clamp + 45}, {Correct Date Mod}),    DATETIME_PARSE(      MAX(         IF({Correct Lift + 45}, VALUE(DATETIME_FORMAT({Correct Lift + 45}, 'YYYYMMDD'))),          IF({Correct Clamp + 45}, VALUE(DATETIME_FORMAT({Correct Clamp + 45}, 'YYYYM

Hello - Is it possible to add a signature card image (see attached) from my computer to an email in an automation? 

I am trying to create an automated email with inserted % fields. However the percentage is not showing up correctly.For example, the % for the record is 55.50% and it is showing as 0.55% in the email.I've attached screenshots of the Automation Email, Email Preview and the actual Record. Thanks!

Hello, how can I rename all the "Web" addresses to a "Link" for a cleaner user experience? Thanks!  

Hey Y'all!I'm struggling to figure out how to do the following and would love some help!I've built a base that tracks registered and onboarded people in a "People" table. "Registered" and "Onboarded" are options in a single select field. The end result of what I'm trying to build is a simple graph that has day on the X axis and a record count on the Y axis. I want to have daily snapshots of total number of registered and onboarded people as my Y Axis. I want to automate this somehow. I think I should make a new table with dates as the primary field and then one field that is the total registered people for the day and another field that is total onboarded people for the day.But how can I automate this so I don't have to check and update daily?I figured automation would work, but the options are so limited with a time as a trigger.I'm thinking I might need a script that runs daily?Can someone help me out here? Thank you!-Taylor

Hello,I can't find the issue here that is preventing what i thought would be a very simple table calculation.I have a table called Deals with many different fields but one of them is a currency field that i want to use a rollup field in another table to calculate the sum of the values in this currency field.I'm stumped as to what i am missing here but all i get are zero values. I tried to workaround the currency field by making a formula field that just turns the currency values into normal integers but no luck.I attached a few screenshots for context, hopefully someone can see what i'm missing.Thanks,Alec

Looking for a simple formula that spits out that last Friday of the calendar year. I'm trying to avoid needing to make this a manual update so would love to find a formula that just spits that out without me having to update it at the beginning of the year.  Thank you! 

Hi there, I am trying to calculate a formula for a discount. The discount category is single select (10% or 20%). I want to calculate what the total revenue will be with the selected discount. The current formula for revenue is (price * quantity) 

Does anyone know if contracting the TEAM plan you can create and synchronize more than one wokflow? Or is it $20 for each workflow?

Im not sure how to ask this in order to look up suggestions. I have an order form that I created on a workstation. Based on the photographer, the client is given the options offered by that photographer. Once they select the options/services they would like I am hoping to have a field that auto adds the selections they made. Is there a formula or script I can create where each selection they choose can be given a designated price that can be added up for a grand total much like an invoice?I am attaching an example of one of the photography options 

Hi, I'm having trouble regarding updating record from my Airtable App. I was using it just fine yesterday, but today I can't update the record from Airtable mobile app. I tried updating the record on web version and it works just fine. Does anyone know how to fix this?

Hello! Is there a way to create a notification (using the color function) highlighting an expiration date in my Airtable to alert me five months before an asset expires?

I use the free version for my card making inventory. I've been uploading images to my base and I'm concerned that I might be getting close to the new storage space limit of 1 GB total storage per base.How do I tell how much attachment storage space I'm using?

On Table A I have a linked record field that allows multiples. It pulls records from Table B. These records on Table B include a Date field. Records on Table B are not necessarily entered in chronological order. For example:Table B Record 1 - 1/1/2023Table B Record 2 - 3/1/2023Table B Record 3 - 2/1/2023On Table A, I'm trying to pull the most recent record linked using a Lookup field with the "limit the number of items shown" option turned on and set to "last 1" but I believe this is giving me the date of the linked record that was most recently created rather than using the date field of the record to give me the most recent. I believe I could play around with an automation that could accomplish this for me but before diving into that, is there a more simple way to achieve this?

Has anyone created an API between Workfront and Airtable? We currently use Airtable for project management/planning and sharing of projects, but creative requests/approvals go through Workfront… would be looking for one-way communication from Workfront to Airtable (specifically relaying dates from Workfront tasks and moving final assets/creative files from Workfront to Airtable once they are approved in the Workfront system). I’m only familiar with Zapier to connect platforms and unfortunately Workfront is not available there, so wondering if anyone has had success connecting these two with a custom API? TIA!

I am struggling to get a Formula that would return my age, where the number after the decimal point indicates the number of months in duodecimal format. For example, my current age is 34 years and 3 months, therefore I want to see 34.03 as the return.So far I've managed to only get this:the formula I am using is:(DATETIME_DIFF(TODAY(),{DoB},"Y"))&"."&((DATETIME_DIFF(TODAY(),{DoB},"M"))-((DATETIME_DIFF(TODAY(), {DoB},"Y"))*12)) It is pretty close to what I am looking for, but how do I get 2 digits after the decimal point by default?*I understand that it may be a weird request asking to combine decimal and dozenal numeral systems like this, but would really appreciate if somebody helped me solve this one 🙏 

Hello, I'm encountering an issue with a formula I'm using to calculate video aspect ratios in my Airtable base. I would appreciate any assistance in identifying the problem or suggesting an alternative approach. The formula I'm currently using for {test3} is: {test1} / {test2}Here's the expected behavior of the formula I'm using for aspect ratio calculation:- If the value of the field {test3} is 1.78, I want the formula to return "16x9".- If the value is 1.00, I want it to return "1x1".- If the value is 0.56, I want it to return "9x16".- If none of these conditions are met, I want it to return a blank result. The formula I'm using for this is:IF( {test3} = 1.78, "16x9", IF( {test3} = 1.00, "1x1", IF( {test3} = 0.56, "9x16", "" ) ) )Please note that {test1} and {test2} are numeric fields that store video resolutions.  However, the formula i

Hey everyone! Im using a script (that I found here in the community, thanks btw!) to pull data from Airtable to Google Sheets in order to make some weekly reports for employees in a company. Problem is, it seems each time the script runs it retrieves the Fields in a random-ish order, which is a problem because those fields are referred to in the reports. Using Zapier is not an easy option since we have more than 400 fields. Here is the script var api_key = "XXXXXX"; //ADD YOUR API KEY FROM AIRTABLE HERE var baseID = "XXXXXX"; //ADD YOUR BASE ID HERE var tablesToSync_fromSheetRange = "A14:B15"; //UPDATE CELL RANGE HERE (for tables that you want to sync) ////////// add items to UI menu /////////// function onOpen(e) { SpreadsheetApp.getUi() .createMenu('Airtable to google sheets sync') .addItem('Manually sync all data', 'syncData') .addToUi(); } ////////// function to trigger the entire data syncing operation /////////// function syncData(){ //fetch table na

TLDR: I'm trying to mark employees as "OOO" if they are OOO for 3 or more days of the week (vs if they are only OOO for 1-2 days of the week they still show up as available). I have a system set up where I have created an "open space" record for every week and previously I had it set up so if the employee was OOO for any part of the week (even if it was just one day) the open space record will show up in red as "unavailable". But I want to adjust that to only showing up as unavailable if they are gone for more than 3 days of the week.I have created fields in my table that shows all the days of each record,  so for the Open Space records it lists out all 5 days of the week vs for any OOO records it lists out all of the OOO days.I'm looking for a formula that compares the two. When the person is only OOO for one day, the formula below works great (as you see for my 12/1/2023 example) IF(FIND({[Prototype] Daily Dates 🧮 🏳️}, {[Prototype] Daily OOO 🧮 &#127987