Solved

Is it better practice to pass only the values you need from the base into child components or is it okay (performance-wise) to pass down the whole record object? For example: function ParentComponent({record}){ const status = record.getCellValue("Status") const date = record.getCellValue("Date") const otherField = record.getCellValue("Other field") return ( <ChildComponent status = {status} date = {date} otherField={otherField} /> ) } vs. function ParentComponent({record}){ return ( <ChildComponent record = {record} /> ) } I’ve been doing the former but its gotten kind of disorganized when I’m using a lot of fields from a record. Does the record object actually contain all the data in its fields or just the method to retrieve them from airtable? Thanks!

Hi everyone, For the freelancing part of my making-ends-meet endeavors, I have started tracking tasks. Usually, that’s no problem with Airtable. But once in a while, I’ll forget to enter a task when I start it, and, instead, enter it when I remember to do so. That means CREATED_TIME() in the primary field gives me that later time, and that’s not helpful. I tried to get around this by using this formula: IF({Manual Date & Time},{Manual Date & Time},CREATED_TIME()) But if I toggle on “Use the same time zone…,” the CREATED_TIME() goes wonky. And if I don’t toggle on “Use the same time zone…,” the {Manual Date & Time} goes wonky. How can I get the time zone to be consistent in this formula field whether it’s autogenerated or manually entered? If someone could help me figure this out, I would be really grateful!

I am using Automation to send messages from Airtable to Slack. However, for example, in Airtable, the value of “$10,000” in the Currency field is simply displayed as “10000” in the slack message (with no $ sign, no 1000 separator). What should I do?

I have the following code that runs fine if I put it in the main body of my App but not if I put it in a function. I’m baffled, hoping folks here can enlighten me as to why. When in the main body, it runs through all of the records in the Teams table. When in a function, only the 1st record is updated. The portion I’d like to have in a function is the code inside of the if (allUsers) block. I have other functions that update in loops, what is so special about this one? let teamsTable = base.getTable("Teams"); let teamsRecords = await teamsTable.selectRecordsAsync({ sorts: [{field:"active members", direction: 'asc'}], fields: ["active members", "Included Players"] }); if (allUsers) { console.log("rebalancing"); let lowestActiveCount = teamsRecords.records[0].getCellValue("active members"); console.log("Lowest active count: " + lowestActiveCount); let included = lowestActiveCount - 5; for (let team of teamsRecords.records) { console.log("Changing I

Hello! One of my apps is crashing (showing the “Sorry, an error occurred”) screen intermittently and I don’t know why. What I know: It usually takes a minute or so of refreshing the app before it is able to load. The airtable record data the app references is changing a lot throughout the data so it might be related to that I have been unable to reproduce this error when I am ‘block run’ mode via the CLI. So far I have only seen it happened on the ‘release’ version of the app the browser console says Error: comment count out of sync a ton of times when I open it after the app crashes Does anyone have an idea what’s going on? Thanks so much for your help. Here is a screenshot:

I’m hoping to use JotForm to add some functionality for recruitment applications, and having some trouble with Airtable’s attachment field when mapping the fields using Integromat. Jotform is sending the attachment data as a URL, which I’m mapping to the attachment field in Integromat, as below: This successfully adds to Airtable: And creates a record with the attachment. However, it seems that the Airtable is then immediately deleting the attachment! I doesn’t do this when I manually enter the same attachment URL, only when it’s mapped from JotForm. Any ideas or prior experience would be appreciated!

:wave: Hey there! Im trying to learn more about Airtable best practice in terms of overall schema/base design and structure. My question is: How can I more quickly add data to tables and cut out some manual work? Here’s the specific context. I currently have a document with three tables Students (Database table, one record per student) Classes (Database table, one record per class) Enrollments (Junction table, handling the many-many relationships between students and classes) Currently, the junction table only has three columns (Name, Student, Class) But to add a New Enrollment, it feels very clunky and like there is a lot of manual work. You have to select both the student and the class each time. What If I need to add a lot of students to classes at once? Is there any easy way to do that? For example, could I batch select 35 students and with one action add them all to a target class? What if I want to continually add x amount of students to the beginner class? Is there an ea

Hi, Does anyone have a formula to format a date to include the “st” “nd” “rd” “th” ? For example, I would like 3/21/2022 to read as Monday, March 22nd I can only figure out how to do Monday, March 22 Thanks! Tom

I am adding records for user profiles. Records are only going to be name and email address until the user logs in to update with additional information. I have one field set up as an attachment, and a user can upload an image to use as an avatar. I would like to set up a default image as a placeholder. I have a view in the user table as ‘attachment field is blank’ to filter out the new records without an avatar, and created a separate table with one record that contains the placeholder image in an attachment field. How do I set up the automation to pull the placeholder image over to the blank attachment field? I was thinking to trigger ‘when record enters a view’ but I can’t figure it out from there. Thanks for the assistance :slightly_smiling_face:

I’ve built an app that allows users in my base to select a record in a certain table. I’m using GlobalConfig to store the ID of that record. However, when I first publish the app to my base I get an error because the GlobalConfig does not yet have an ID stored. So when do useRecordById, I get an error like this: “getRecordById expects a string” because there is no record ID stored in GlobalConfig, since a user has not yet selected one. When I tried putting useRecordById inside a conditional, I get an error because you can’t put hooks inside a conditional. What is the best way to get around this? Thanks!

It’s getting pretty insane with these new features being rolled out long enough to be excited about them then rolling them back. About to leave the platform and stop pushing it to clients over the BS Games. Really hope we get that great formula editor back some time soon. @Jordan_Scott1

Hi all, I have the last modified showing up as “Unknown” in a synced table and not sure what is causing this. Is this possibly the record coming from the other base not showing the creator, until someone updates possibly? Cheers

I’m experiencing a strange issue when I use a date in a formula (yes, I’m using timezones). If I include the time field in the date, then it displays correctly in the formula, but if I do not include time, then the formula displays the date minus 1. I do not want time because this is an invoice date. Halp.

The Vega-Lite app never gets past “Loading…” - no JSON. Any idea how to get this app operational? per the readme, I suppose I can try creating a new app with the SDK per the Vega-Lite github readme, but this seem rather obtuse :face_with_diagonal_mouth: Anyone know what’s wrong with the app, how to resolve or troubleshoot? Thanks!

I had a formula that was working until this week and has now broken for some reason. I looked into the basics (did the field names for the formula change, synced fields change, anything like that) but literally nothing about the components of the formula broke, so I’m unsure why it’s now resulting in #ERROR rather than the result. Formula below, it’s honestly incredibly basic. Any ideas for simple things I could be missing? DATETIME_PARSE(ARRAYJOIN({Release Date_static}), ‘MM-DD-YYYY’) Where {Release Date_static} is a lookup of a single line text field with a date in ‘YYYY-MM-DD’ format.

How can I replace decimal number with two decimal places to hourly like number. 2.42 > 2:42h

Dear community, can two unrelated conditions live in the same formula? Do they need to connected by the same first argument? I want "Sample Availability to read “Shop only” when there is no value in “SignOutIcon” In writing it would be: If SignOutIcon contains no value, return “Shop only”. If SignOutDate contains a value and ReturnDate contains no value, return “not in stock”, otherwise “available” With first argument the same, it would be If SignOutIcon contains no value, return “Shop only”. If SignOutIcon contains a value and SignOutDate contains a value and ReturnDate contains no value, return “not in stock”, otherwise “available” I used “&” but this returned a mess: IF(AND({SignOutDate},NOT({SignOutComment})),“not in stock”,“available”) & IF(NOT({SignOutIcon}), “Shop only”, “available”) Could anyone give me a hint? Any help highly appreciated. Best, Sisi

Getting into formula’s a bit more as a novice lately, but struggling to get this one right. Anyone able to help me out on this one? What I want is to change the Multiple Select Field as per below. small instead of s average instead of a tall instead of t Was thinking in the direction of wrapping the exiting formula in a Switch( ) to change the select options small, average and tall to s, a and t for the the output.

Anyone can help me make a formula to write out the below numbers in a Single Line text field (A) that are styled like below, to full digits in a Formula Field (B)? Field A 1 10 100 1k 10k 100k 1.1k 10.1k 100.1k 1M 1.1M Etc. So far I’ve come up to this formula. But it’s very lacking. SUBSTITUTE( Views, REGEX_EXTRACT({Views}, "\.\d+k"), "00") It outputs 100 when its 1.7k and doesn’t work at all for entries like 1 to 999 and 1M upwards.

So I have a base with 2 tables - one containing the funding round details (FRD) which includes name of Startup, amount and investor And another table solely for investors - which I wish to import data from Investors column in FRD table. Now, the investor in FRD is input as a long text which is comma separated. I wanted the Investor table to automatically import this data from investor column - and import it into separate rows - with startup name on the side. I know something like linked record exists, but even there I have to manually select the investor - whereas I simply copy and paste data from the net, thats why I want the investor column data to automatically be imported in the other table. How can I make it happen? Sharing link for sample base for your reference, please guide. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious out

Hi, I have a list of cities and states, and I want to extract only first state initials. How can I do that? Thanks

Hi all, I’ve been using Airtable for a few years and have finally decided to try my hand at writing a few scripts to streamline our workflow. I’ve coded a fair amount before but am new to JavaScript, so please excuse my ignorance. My current project is writing a script that will be called from a button field. This script will make a request to a taxonomic database, retrieve classification data for a single creature, and populate a series of self-linked columns within the table. I have a working script that gathers the data and reformats, but I’m stumbling across the last step of assigning data to the linked fields. Throws this error after the last line: Can’t set cell values: invalid cell value for field ‘kingdom’. Cell value has invalid format: must be an array. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id. I understand that the issue has to do with needing the data to be formatted as an array for linked fields, but I’m

I’ve been fighting this and researching long enough. here is what I currently have that doesn’t work: IF({Referral Name}}, “Field is Not Empty”),{Commission}{Referral %},"")* Explained: If Referral Name field is not blank or empty, Calculate Commission field multiplied by Referral % Otherwise, leave return a blank field. Help! :slightly_smiling_face:

Hello! I’m relatively new to Airtable, but I’ve been digging to figure out a solution and haven’t come across anything workable yet. What I’m trying to do is set up skill profiles that contain different proficiencies in each profile. Example: I have 2 skills, Reading and Writing. I have 2 profiles, Researcher and Author. I have a proficiency rating, 1-3. Researcher profile has Reading at a 3, Writing at a 1. Author has both Reading and Writing at a 2. Right now I have a table of skills and a table of profiles with skills linked to them, but no way that I can find to do unique proficiency in each profile. Is there a good way I could set something like that up? The biggest challenge is I’m creating this for about 40 different profiles containing different mixes of about 300 skills. I’ve a feeling it’s not a possibility or if it is, maintenance would be a bear.

I want to set an automation that duplicates a record every time the original record is updated to status DONE. But I’m finding trouble. How could I set for TOMORROW the DATE FIELD of the new record created by the automation?