Solved

Hi All, I have a base that acts as a Property Management System with multiple tables. Two of those tables are the “Contracts” table and “Bills” Table. I have been using the new scripting block to streamline all of the daily processes: Recording new payments received and issuing receipts, creating customised reports of income/outstanding bills reports, by City/Property/Tenant reports …etc. I am finally at the last step where i am attempting to create a script that prompts the user to insert all of the relevant contract information and creates a new contract record in my “Contracts” table, and then also automatically adds corresponding bills (in the Bills table) in the wanted frequency (i.e: 12 bills of monthly rental payments with due dates and amounts), and finally links them to the contract. However, I am getting a strange behavior when adding the bills. The creation of the contract record works just fine but when the script attempts to add the bills I get the following error: Syntax

Hi, I’ve shared a base for collaboration with one person. I’m also using this base as main database for my work. I would like to add a field for each line created (each line represents a new client, with a new job) where i can add some secret informations that i don’t want to share with the other person. How do i do that ? it’s text information. Thanks

I’m so confused using the Dedupe block. It doesn’t MERGE anything. It just keeps the primary record. Let’s say I have a table with Name, Email, Phone, Address, and Transactions. I select find dups records as Name and Email, 2 Records appear. has the phone and transactions. has the address How do I merge the address into record 1 or the phone and transactions into record 2. So I only have one records the with Name, Email, Phone, Address, and Transactions. What am I overlooking?

I have a script I run that manages task due dates. Using self linked table to setup predecessor tasks with manual start date and manual lead time fields, it calculates the end due date. The script pulls the predecessors end date and checks if the task start date matches or not. If not it will change the start date. My problem is right now is that when I press the button to run the script, it runs through the script once, showing me a result of all the tasks/dates it updated. Because at the time of running the script these are the only dates it found mismatching. But as a result of these updates, I have to run the script again to update any further tasks/dates that were affected. Then again and again until there is no more dates needing to update. What I want to do is have the script pause at the end, then run the script again on its own. I want it to continue this loop until there is really no more tasks/dates to update. Is there any way to do this?

Not 100% sure where this should go but: I am using airtable as a database for the teas we have in stock. However, when a tea goes out of stock, I would like to mark the item as “finished” and relocate it to a new table automatically so it isn’t included in the main count and doesn’t clutter up the table. While I know I can do that using a filter, people who are unfamiliar with airtable (or even spreadsheets/databases) have found this difficult. I don’t want to lose the information entirely since it lets me know if something we got didn’t go over well and we don’t want to purchase again or if it’s something we really enjoyed, I want to be able to quickly add it back to the main table. Please let me know if this is possible? I’d rather avoid manually moving this data but understand if that’s the only way.

I set up a database to help me organize battery cells and figure out which are good and bad. I have a table for each make & model’s rated specs, a table with the results for the each battery cell’s capacity test (each test is a record and a battery cell can have multiple tests/records) and a table for each battery cells’ details & summary. In the battery cells detail table I want a field for each battery cell that is populated with the average result of all it’s capacity tests from the capacity tests table. How do I achieve this? P.S. - The value in question from the capacity test table is a number/integer (i.e., 2400).

Hi Im following the many to many tutorial from Airtable Airtable - Support A beginner's guide to many-to-many relationships What sets Airtable apart from ordinary spreadsheet applications is its ability to link related concepts together. Knowing how to represent the relationships between different groups of objects can ... I’m stuck on the following step in the photo: I can create the first two tables (students and classes). In the bottom pic, they have created a 3rd table. It has got a list of the students and classes. In particular, I cannot find a field with the Icon show for both students and classes is different in the bottom pic I have tried to do this using the “Link to Another record” feature, but my version creates 2 columns each time (see pic below) I use link to another record. Additionally the icons are different to the one shown in the example. Thanks very much Amit

Hello ! I made a formula to get all the holidays for the current year automatically and I can’t use that value directly with WORKDAY_DIFF in another formula. I have to copy and paste. If anyone has the answer I would love to have it, thanks a lot !

Hey guys! Does anyone know if embedding a video on an airtable form is possible?

There are 2 fields: the time of the last modification of the line and just a number. (last_modified_time and time) How do I create a formula for the “result” field to add the minutes from the last_modified_time field and the number from the “time” field? That is, the example should get: 38 + 100 = 138 (the field “result” should be 138) (101 is there for an example, do not pay attention. Instead it should be 138)

Hello, I’ve been working with a script for a while to import some CSVs. The purpose of doing this is to cleanse some of the data prior to importing it and adding more controls around how these files are uploaded verses using the CSV import block which we can’t control as well. A question I had was, that when I try to import one of my files that contains a 16 digit tracking number, it comes in formatted as scientific notation and loses any data beyond where it is summarized. I understand that this is often regarded as an Excel issue, and there are workaround within Excel, but when I try those workarounds, save the file, and try to import it, I still get scientific notation formatted numbers. I was wondering if anyone had a potential solution to this or if anyone has run into similar issues. My current solve would be mapping where we currently get our data from, to an Excel file, and using the scripting import on an .xlsx file type instead but we would really prefer to have them stay in

How to get the modification time of a table item (in Kanban)? Example: You need to get what is highlighted with a green line (Using the API)

Hello, please dont be too harsh with me I am starting with this and have a simple question I cannot solve by myself though trying different combinations of formulas. I have 3 fields : possibleloan1, possibleloan2, loanoutput. I want a formula that defines loanoutput. Loanoutput is possibleloan1 if possibleloan1 is greater or equal possibleloan1. if possibleloan1 is minor possibleloan2 , loanoutput should be possibleloan2. I tried for loanoutput: IF(possibleloan1 > possibleloan2, TRUE(possibleloan1), FALSE(possibleloan2)) Do you know what I did wrong? Airtable is not accepting the formula itself though I wrote it in accordance to the guidelines. Thanks in advance!

hi, i’m from Moldova, our contry code is +373, i want to enable two step authentication but it’s not possible for my country, i need to enable 2fa using mobile app, why you don’t give option to enable 2fa, and give a list for emergency codes, like other services! error: Error submitting phone number; please try again.

I have a table with 8,000+ records that include email addresses (source table). I have a list of 200~ e-mail addresses being updated manually (table 2). I would like to create a grid view in the source table that filters to only include the list of 200 e-mail addresses, without having to manually search for each or create a filter. The end result being that my source table has a column that indicates if the record’s email exists in Table 2, and I could create the grid view based on this. Anyone know if a script exists for this? Originally asked the question here: Filter for a long list of values

Hello, I’ve posted a related discussion to this one, wondering if there was any way, through the scripting block, I could break out numbers that were in scientific notation into long strings from .csv files that I was importing. Unfortunately, none of my potential solutions worked out. I’ve started trying to figure out at what point these files get converted to scientific notation. When I view the .csv as text, I can see the long numbers as I would expect them to be uploaded. But when I upload the file via the scripting block, they are formatted in scientific notation. This is starting to make me think that the parsedContents function takes some liberties with the data and converting it. While it is tremendously helpful for a lot of my purposes this is a roadblock I’m not sure how to get passed yet. My question would be whether or not there is a way to prevent the automatic file parsing in the scripting block from changing my fields and data? If there were some way that the file could

Hey, Im looking for a way to link multiple tables to one record. I want to be able to assigng sub tasks in 1 record in master table ( I have many tables) from different tables so person whos reposnsible for the project could quickly see where we are failing.

Is it possible to create a formula that sums values in other rows based on a filter with the current row’s other column value? For example, let’s say I have 3 columns: Topic (Primary Field) Owner: Person object (other table) or email address Score: Integer field I want to calculate the sum of all Score fields where the Owner is the same. From a table perspective, I was thinking about adding another column with a function like the following: SELECT SUM(Score) WHERE Owner = this.Owner This will result in the same value for all rows where Owner is the same, but I’m okay with that. What’s the best way to accomplish something like this?

In my base, I have a column called Authors. I would like to make a formula so if the Authors field has “Hoch” in it, it will say Author, and if it doesn’t, it will say Not Author. How do I do this?

I have a field with a value "feather29sum"cxa. I need to extract the feather29sum only and ignore everything else. Can someone please help with this formula?

Hi everyone, we are building a little CRM inside Airtable and I am trying to do something that seems to be almost impossible. Perhaps I am just not seeing it. So, would love some help to get this going: Setup: One table called Customers Another table called “Health Score Reviews” The first table is self-explanatory. The second one, has a series os “log entries” for every time someone from our Customer Success team interacts with a customer. In that interaction, they can add a SCORE to the interaction from 1 to 3. Objective: We want to show the LATEST Health Score for that customer in the Customers table. The first part I was able to do, which was to retrieve the max(id) for the Customer Health entries and pul that number to the Customers table. The problem is that I want to Lookup in another column what was the Score that was registered under that ID. I am trying to use a Lookup field. The idea is to retrive just the latest Score. But it doesn’t work and it brings up all the Scores a

How can I keep my numbers field from rounding? This seems somewhat simple, but I’ve searched and found nothing. I’m in publishing and trying to add page counts. My numbers field keeps updating 1.75 to 1.8 and I don’t know why. Even if I fix the decimal view, it will do 1.8 or 1.80 or 1.800 - not 1.75. I have done it with simple text but then I lose my sum feature. Any help is appreciated!

Hi, We have two separate paid workspaces that we want to combine into one. Is there an easy way to transfer bases from one workspace into another workspace that is under a different account?

I’ve been banging my head against the wall for a few hours, I can’t figure out why my selectRecordsAsync() does not pass anything into queryResult. I think it has to do with me using an async function, but not sure why it wouldn’t work? let poTable = 'PO/PI Paperwork' let poView = 'test' let btnPO = 'Client' /////////FUNCTIONS //Show PO list by client///////// const poList = async () => { let view = base.getTable(poTable).getView(poView); let queryResult = await view.selectRecordsAsync(); return queryResult } ///////////UI if(btnPO === 'Client'){ console.log('Client') let test = poList() console.log(test) }else if (btnPO ==='Number'){ console.log('Number') }else if(btnPO === 'Yarn'){ console.log('Yarn') }

Hi – I may be in the wrong place, but if this is possible, am guessing it will be a script. I have a single multi-select field with 450 options like: United States, Automotive, P&L, Canada, Manufacturing My team has gone through and categorized these into 3 new fields which would be: United States, Canada Automotive, Manufacturing 3 P&L We have about 1500 records tagged in the first way. Is there a script I could run, that would redistribute those tags from the single field to the three fields, without creating new options? Please let me know if this should be elsewhere. I searched for similar requests and didn’t find this. Thank you!