Solved

I have had a form for the last few weeks that worked exactly as expected.  Today the linked fields in the form cannot be clicked to select from the list of linked records.  All the field settings in the underlying table and in the form itself appear correct.  I even tried creating a completely new form and the problem persists.  Here's a link to the live form:https://airtable.com/shr5M59mTF6jXrEUlAny ideas what's happening?EDITED TO ADD: I can add a new record directly into the underlying table with no issues - all fields work exactly as expected! 

Hi there,I'm experiencing a strange situation with a simple formula. Here's what i'm using:WORKDAY_DIFF({Date-test-1}, {Date-test-2})-1 I set date-test-1 to Today's date (Friday). If I set "Date-test-2" to next Monday, the result is correct: 1(Note that my dates are in european format) If I set it to next Friday, the result is correct: 5 It seems that it does it perfectly whenever Date test is a future date. I also want to calculate the working days between today and a past date, and here's where i'm getting strange results:Setting Date-test-2 to Yesterday, Thursday, the result is: -3, should be -1 Setting it to last Friday, the result is: -7, should be -5 Any explanation on why this is is happening? I could do an easy trick, and add +2 whenever the date is past, but I can't understand why this is happening, so i don't know if this fix would stay consistent. Thanks in advance! Javier  

I have recently been tasked with the goal to create an automation that allows the attaching of an extension result to an email. This extension lays out the information from an admin-only base into a pleasing format for people assigned to a certain job to be able to read the requirements for the job in a clear way. Is there a way for AirTable to take information from an extension (as in a file) and automatically place it into an automated email? Thanks!

I have a table with the fields "Title" and "Status". I want to automatically post to a Slack channel every 2 weeks, a list of the "Titles" that have had their "Status" fields updated to a particular value within the past two weeks. Currently, I can only generate a list of ALL the "Titles" with the particular "Status" value. How can I limit it to show only the recently updated ones? Do I need to write a script instead?

Hi AllWe have sensitive data that needs to be edited and updated but we want to remove the "Editors" ability to share outside of our organisation. Is this possible?So effectively removing the share button for editors

Hello, I'd like to add a filter to my running total script. I have a checkbox field and would like the script to only calculate the running total if the checkbox is checked. Any help appreciated.   let table = base.getTable('Resource Capacity Planning_Production'); let view = table.getView('Grid View'); let result = await view.selectRecordsAsync({fields: ['Pillar & Domain','FY Q2 23 - Demand (FTE)'], sorts: [ {field: 'Pillar & Domain'}, {field: "Stack Rank"}]}); let runningTotal = 0; let currentGrouping=''; for (let record of result.records) { if (currentGrouping !=record.getCellValueAsString('Pillar & Domain')) { currentGrouping=record.getCellValueAsString('Pillar & Domain'); runningTotal = 0 } runningTotal += record.getCellValue('FY Q2 23 - Demand (FTE)'); await table.updateRecordAsync(record, { 'TEST Running Demand': runningTotal, }); } 

I've got an events calendar and an automation set up so that event registrants will get an email 6 hours prior to an event, using a formula field and the TONOW formula:TONOW({Start})The automation sends an email when the formula field reads "6 hours".The trouble is, the field renders "6 hours" twice - once 6 hours before the event and again 6 hours after the event, so it triggers the automation to run again 6 hrs after the event.Can anyone recommend a better formula to get what I'm looking for here?Thanks!!!

Hello, I am still getting used to Airtable and am having trouble designing my tables and views. I am looking for some help from the community. Here's the scenario:I am trying to create a gallery view of approved real estate properties that I can share with my clients.Clients should be able to sort and filter the gallery view to help them find properties.The card view will show a couple fields but clients can click on the card to expand the record, to see all fields (with exceptions mentioned below).I have 2 people helping me search for real estate properties to add, so I want to create 2 forms for each of them to submit their properties for approval. The form for Person A and Person B will have the same fields except Person B's will have 3 extra fields.As the properties are submitted through the 2 forms, they end up in a grid view and their "Status" should be marked as "Pending" until I mark them as "Approved", at which point they should show up on the gallery view for clients.The

I have set up a form for clients to fill out. I want the information the clients give us to remain intact, so I am trying to create an automation that will copy over all the information from the form into a new record on a new table. Then once it's created a new record, we can go in and make corrections and adjustments.So far it's working fine except for number fields. I can't figure out what I'm doing wrong? We ask client the quantity for a product, they tell us. I want that field to be copied over in the new record. But when I select the "Quantity" field, it prompts me to enter a number instead of linking another field.I have experimented with changing the format of our "new record table" quantity field to "single line text" instead of number, and that weirdly lets me link the "quantity" field from the form. This is not that useful though because I need to do calculations with the number in the quantity field.Thanks in advance for any help! Attached is a screenshot of what I'm talkin

Hi dear community 🙂I try to build a crowdfunding platform for real estate using Airtable.Users can choose the project to invest in and make a payment.   I am able to see all users and in what project they invested in Here are all transactions users made The struggle is to pay every user based on the amount they invested in each project because each project has a different dividend % and users can invest in 2-3 different projects in different periods. I somehow need to add to their profile what they earn every month. Any ideas on how to make it a reality? 🙂 Thank you 🙂

Hi all, I have set up a gmail automation and am sending an ISO Date time to the email recipient. The date time that is sent is 4 hours ahead of what is entered in my table. Any ideas as to why this is happening?In the screenshot of the table view, I do not have a time zone set for date_ordered. I tried with the proper timezone configured as well and it still has the same issue.     

Like the title says can you add a subscript into text in an automation email.    I have tried the following "CO<sub>2</sub>  but it doesn't work.   I have found that you can add lots of other HTML tags like <b></b> for bold and <p style:"blah blah;"></p> to achieve other formatting outcomes but the <sub></sub> tag doesn't seem to work.Is there a way to do this? 

Hello!I have a formula that calculates commission and I need to add an additional calculation that is tripping me up. I am starting with the following formula.SUM(IF({Commission Based On},{Commission Based On},{Purchase Price (Current/Final)})*{Commission %})+ {Commission Flat Fee}+{Admin/Office Fee}+{Other Fee}-{Concession}-{Referral Flat Fee}I added the following field to my table and need to add it to the formula.{Referral %} The first part of the current formula takes the purchase price and multiplies it by the commission % plus the commission flat fee.SUM(IF({Commission Based On},{Commission Based On},{Purchase Price (Current/Final)})*{Commission %})+ {Commission Flat Fee}But next I need it to take the result of the first part of the formula (which would be the total commission amount), multiply it by {Referral %}, add {Referral Flat Fee}, then subtract those two resulting amounts from the commission amount.Then I will add/subtract the remaining items.Any help would

In the following top portion of my pre-fill code, everything works fine except when there are duplicate records in the Asset Name field.All the other pre-filled items work fine. But when there are duplicate Asset Name values, the form displays nothing in the Asset to Update form item.This duplication is expected and I was thinking I should somehow refer to the Record ID as well so the code will grab to correct record:CONCATENATE(IF("Prefilling [Update Asset] view in [Assets Updates] table in base with id 'appZyoL5fNNYcN6dv'","https://airtable.com/shr7hLXk437tBSfOb"),CONCATENATE("?prefill_" & ENCODE_URL_COMPONENT("Asset to Update"),"=" & ENCODE_URL_COMPONENT({Asset Name } & "")),CONCATENATE("&prefill_" & ENCODE_URL_COMPONENT("Original Module"),"=" & ENCODE_URL_COMPONENT({Module COPY} & "")),What code should I use to clarify the Asset Name to pre-fill when there are duplicate Asset Names?Thanks for any ideas. Charlie

The Miro integration was announced almost a year ago and works great - for one way integrations: https://community.airtable.com/t5/announcements/new-feature-announcing-airtable-s-miro-integration/ba-p/128357However, I would really need a two way sync, or at the very least a smart hack to achieve something similar.The best solution would obviously be a two way sync of the Content field. (This being the primary field I guess it could cause issues.) The second best option (pending better ideas) would be to have a second Content field. One possible ugly hack (for my use case) would be to use a huge number of Frames (acting as IDs)  and have the Content field editable from Miro. This could work but since I need 180+ Frames for the current case I don't really think it is feasible.Think of building an org chart in Miro (where names can change) and still wishing to link these to more data in Airtable.

I want to use this mathematical formula to calculate the "average" diameter at breast height (DBH) of a tree with multiple stems:DBHavg = SQRT({DBH1}^2 + {DBH2}^2 + {DBH3}^2 + {DBH4}^2)This is the formula I used:SQRT(POWER({DBH 1 (cm)}, 2) + POWER({DBH 2 (cm)}, 2) + POWER({DBH 3 (cm)}, 2) + POWER({DBH 4 (cm)}, 2)) This formula returns an error for most records because most trees only have one or two stems. Only trees with numbers in all six fields will correctly calculate a value. How can I change the formula so it calculates the square root of however many DBH values are present for a particular record?

Hello,I am working on an Airtable script to flag dupliacte records in a table and automatically flag them. But for some reason when I run the script, nothing happens. I have tried the script in another Airtable project and it works just fine but its not working here. Would be glad to know what I am doing wrong and how to fix it.Here is my scriptvar tables = base.getTable("📊 Impact Data");var query = await tables.selectRecordsAsync({sorts: [{field:"Time",direction:"desc"}],fields:["location_id"]}).then(result => result.records.map(rec => ({id: rec.id, field: rec.getCellValue("location_id")})))let uniqueRecords = query.filter((rec, i, arr)=> arr.map(el => el.field).indexOf(rec.field)!==i);console.log(uniqueRecords);let updates = uniqueRecords.map(update => {return {"id" : update.id,fields: {"Test": true}}})console.log(updates);while (uniqueRecords.length>0){await tables.updateRecordsAsync(updates.slice (0, 50)); uniqueRecords= uniqueRecords.slice(50); 

Hi Fellow Community Members, I get these inventory summary sheets from my vendors that I first have to run a macro on in Excel to transform the summary to individual records to update my inventory in airtable. The sheets are for dresses so each row has the style and color and then the columns have the sizes and under each size is the stock amount. Each style color and size is an SKU in my base so I cannot import the data directly before transforming it in Excel. My question is there a way for me to automate the importation process without having to run transform the data each time or is there an easier way to do this process?I have attached an example of the sheet i get from the vendor and a link to my base. I would greatly appreciate the community's input.    I attached a sample file and a link to my base https://airtable.com/shrRSgvhQ1Y1naavE

Hi,I have written a script that is triggered within an automation that essentially builds out a junction table. The issue is that it frequently fails with the error "Script exceeded execution time limit of 30 seconds". Does anyone know of ways I could edit this so that it will more likely run within the 30sec time limit?Many thanks in advance! let classesTable = base.getTable('Classes');let clientsTable = base.getTable('Clients');let attendanceTable = base.getTable('Attendance');let attendanceQuery = await attendanceTable.selectRecordsAsync();// Get the record ID from the automation inputlet triggeringRecordId = input.config().recordId;// Retrieve all the records in the Classes tablelet classesQuery = await classesTable.selectRecordsAsync();let classesRecords = classesQuery.records;// Find the triggering record using the provided IDlet classesRecord = classesRecords.find(record => record.id === triggeringRecordId);let classDate = classesRecord.getCellValue('Class');let scenesTo

Hey there. I am wanting to make a field auto-fill depending on whether another field is empty or not. E.g. If someone enters a voucher number in the ‘voucher number’ field, the field ‘cost’ is automatically $0. If the voucher number field is left blank, the ‘cost’ is $100. I’ve tried using the IF function and making it blank but it is saying invalid. Thanks!

Hi everyone!This Script is working greate to send a webhook containing table fields in an automation.I'm trying chaneg it to send a only fields from a specific view.I tried to change and adjust it to fit a certain View. I added "let view = table.getView("MyView");" and changed all the Table References to View References but I get an error message:"TypeError: Cannot read properties of undefined (reading 'length')".As I am new in coding, Can you tell what is missing?

HelloI am quite new to airtable and data fetcher having as well no programming knowledge. Would need somebody helping me to set up API links in data fetcher.You can message me on e-mail: myactivities@bluewin.chBest regardsklemensl

We are looking for someone who can convert our excel sheets into airtable. We have it all mapped out and know the flow and how we want things displayed but do not have the experience to set up the automations etc on air table. We have 100s of clients we have that we need to manage account balances for and store information about and also create a sales pipeline so we can track them from  becoming a lead to a client. Looking for someone who can take this paid project and bring this to life fairly quickly for us. We have started playing around with AirTable and have some base tables setup with fields, need to be able to link them so records update. Setup bulk upload templates and other automations. 

Hey community. I'm putting together a new CRM, and I'm wondering if it's possible to send chart elements (graphs) in a slack message or email on a regular weekly cadence. Any thoughts or insights appreciated!

I'm creating automation that needs to be triggered every two weeks on Monday.1. If I set the starting date as today (Tuesday, 4/18/2023), when will be the first date that automation runs?2. If I need to make the automation run for the first time on Monday, 4/24/2023, how should I set the starting date? What if I need to run it on Monday, 5/1/2023 for the first time?