Solved

I am trying to prefill a form field from a long text field with rich text enabled. The rich text does not carry through to the form and is rendered as plain text. I have check boxes in the text that I would like to carry through to the form - is this possible? Help hugely appreciated!

I’m trying to us the example script, and keep getting: airtable recordid should be a string, not undefined I am using the script as is, except I changed the table name on line 2. I followed instructions on how to configure input variables using the left panel. I added recordID field to my table, using the recordID function in formula field. When that didn’t work, I changed to a short text field, preserving the generated record ID values, but I still got this error. I’m out of ideas. Can someone help? “TypeError: Invalid arguments passed to recordQueryResult.getRecord(recordId): • recordId should be a string, not undefined” TIA, Sharon

Is anyone experiencing odd problems with view controls (filters, sorting, etc.)? They’re suddenly not working correctly in my bases, and none of my records are appearing at all when any filter is applied. Only if a view is unfiltered can I see any records. I’ve recorded a Loom video and sent it to support, but I’m curious if this is isolated to my account, or if it’s something more widespread.

Newbie here. Are attachments/photos linked to the original place when they were attached? i.e. If I have a folder on my hard drive called XXX and that folder contains photos. I attach my photos to my table. Do I need to leave those photos in the folder on my hard drive?

Is there a way to embed an Airtable into a Mailchimp newsletter? I am trying to get rid of the “click here” in the newsletter and just have the table itself show up in the newsletter. Thanks!

Hi, I’ve been using Airtable to manage and automate registrations for events. I set automation to confirm the registration. The trigger was a “When a record is created”, i.e. when someone completed the registration form. After the event, I did not switch the automation off, and I inserted a new column into the same sheet to indicate who participated in the event (checkbox). Problem: Registered people who could not participate at the event complained about receiving my automated message confirming his/her registration after the event a second time. Previously, I assumed a record was when someone completed my form. Please help me to understand what happened. If the inserted new column was a new record/trigger, why only just a part of registered people received the automated? With thanks

Hello there, I have been using Airtable for a few years now and I absolutely love it. I am creating a basic HR system for a startup and I want to create a formula for the employees’ paid leaves. Basically, each employee should receive 2 days off for every month they work for. it should be added by the end of each month. How do I automatically make it add up in Airtable, using the joining date only? Is there a formula for that? Thanks in advance.

Hello, I am using the CSV import app to update my airtbale base, but one of the values from the CSV keeps returning this message when trying to save the records “The following values won’t be imported”. The value is a percentage, and I tried to change the format in excel to number, general, percentages… but no matter what I do, the same message comes. Does anybody know why the value is not recognized?

dear all, we would like to create an email with Gif attachment that plays automatically when you open the mail how can I do it ? I tried via GIPHY website & embed code, but didnt work :frowning: I do not have any super deep computer knowledge, so please answer like you would explain it to a complete noob thank you for your help :slightly_smiling_face:

I’m looking to leapfrog some work by seeing if anyone has an existing base of all Countries that I could duplicate. Ideally some additional properties would be: Region, Image, short description of the country - anything else (population statistics, governing country, language spoken, etc) would be gravy. Let me know if someone has this base already made up that would be willing to share, thank you!

I need help writing the following script: Tables: Classes Students Grades (junction table) Each time an Enrollment form creates a new record in the Classes table, the script creates a record for each Student in the Grades table. Grades table is a junction table linking Classes and Students tables. I know there are several community scripts regarding junction tables but I need one that works from just one Class record at a time.

Hi everyone! We are currently setting up our social media planner in Airtable and we are wondering if there’s a way to automate the reporting. For example, would it be possible to automatically feed the performance of the individual social media posts (on Instagram, Facebook, Twitter, Pinterest) back to the Airtable sheet? If so, what’s the best way to set it up? Thanks! Jess

I am using Airtable to send data through to another platform (Formstack Docs aka Webmerge). My base has a main record with a number of linked records per main record. The use case is that each item from the linked records will be a new row on a document. In order to do that, I need to send the data through to the document in JSON. Is there a way that I can produce the JSON of the linked records with a script within Airtable? Ideally I could put that JSON into a long text field. Failing that, is using a code step in Zapier the only other option? Thanks Shaun

The situation: I’m setting up an attendance function on a sheet. Name, date, checkbox. Easy. I need other uses to be able to click that checkbox as well as myself. The problem: Any other user has to be promoted to the level of “Editor” to click the checkbox. We’re a really small non-profit and I just realized that promoting six people to editor so that they can check a box is gonna charge us … a lot. I’ve already emailed support to say “Whoops! Please don’t charge me for my idiocy.” The solution? Obviously, I could do this quickly in, say, Google Sheets. But my data in Airtable is synced, so the pool of possible attendees is live and could grow or shrink depending on data in another sheet. I can’t afford to promote 6 folks to editor for a few months while we are in-season. Is there a way around this? Is there a way to create a front-facing document where a user can click that checkbox without them being an editor? I feel like I could turn this into a form that has all the possibilitie

Hello! Currently for a school project (Software Development and Design) I am making a game in unity complete with an online highscores leaderboard through Airtable. The leaderboard side of the project is now done but I wanted to add a replay system to the game. Much like demo files from the old doom games my replay solution is a JSON array that contains the positions and rotations of the key game objects over the lifetime of the game. The file that is generated is only about 1mb in size and such shouldnt take very long to upload if sent with the rest of my run information (such as the players username and their time) The issue I have run into is that im getting an INVALID_REQUEST_BODY error every time i try to put the entire JSON string into a Long Text feild on airtable. I beleive this may be due to the fact that it is a JSON string inside the rest of the JSON request that is sent to irtable. Is there a way to isolate the string so that airtable doesnt try and parse this data? Alterna

I accidentally erased 140 records! Yikes. The undo function isn’t remedying it. Is there another way?

Hello! For a school assignment (Software Development and Design) I am creating a game and using airtable as the online highscores database. So far its been working really well, as soon as one of my friends completes a run a record is added to my records table and it can be sorted so that I can see who is ontop of the leaderboard. The only issue with my current setup is that it has become hard to see any of the other players becuase a few particular users have filled up the top 300 slots or so as shown in the image. (Please ignore my friends “creative” choice of usernames) So what I think would be a good solution would be to either 1) Have another view/table that only shows the best run for each username or 2) remove/hide all of the runs that are not the best run Thanks, Tom Howarth

I’m working with an API that returns a JSON object from the the function below: await remoteFetchAsync(url, getLabelOptions) .then((resp) => resp.json()) .then(function(data) { pdfstring = data.label; }) .then() .catch(function(e) { output.markdown("ERROR!"); output.markdown(e.message); }); Considering the pdfstring is my base64 encoded pdf, how can I convert to pdf and save as an attachment?

Hey, People! I have two tables- Table 1 & Table 2 So I need the data from Table 2 to be automatically pulled into Table 1, once it has been marked verified. Will the IF function work here? or is there any other way? Please help.

how can i show linked records for a selected table record that changes dynamicly when i select/deselect rows? i can get selected row ids from cursor, but i am struggling to to select and show linked recods

I noticed three records missing from a table, which had been created via an API call. The API call response indicated success, including a response object containing the same number of records (and with recIDs) as had been POSTed in the call. However, these records do now not appear in Airtable. There is no record of manual deletion in the base trash, and the view is not filtered. I was wondering what could be going on and so decided to look at an automated Airtable snapshot taken on the same day. The records were not in the snapshot, but I did notice that the snapshot was taken at the exact same minute that the API record creation POST call was made for the missing three records. Is it possible that the snapshot process has interfered with the record creation call in some way (perhaps a DB transaction lock or similar), resulting in the Airtable API response to prematurely report successful creation?

Hi there, I have a question that I can’t seem to wrap my head around, so I would love to have your input. Let’s take a look at the following screenshot: As you can see, I group records based on a name. In this case, we have “K” and we have “T”. I would love to create a sum of the points for each person. So K would have 1 point, where T would have 5 points. There is indeed already a SUM, but I’m not able to sort on the SUM of each group (if I can, please let me know how, meaning that T would be on top of K). So, I would like to create a field that is able to calculate the SUM from all the records for each name separately. I would not mind if I would see that same result in each record, but the idea is to create a scoreboard, where the highest sum of points for each person is on top (currently, when I sort, it just sorts on the individual point). Is this possible, and if so, how would I go about this? (Basically, I want to do some kind of count if on each name separately and on each mon

Hi community! I have a very strange issue here… I have a lot of duplicates within the same field, a lookup field (I’m not so sure why, but that’s for a different question) In order to try to create a field with no duplicates, I created another field with the formula: (ARRAYJOIN({Most recent First Name :zap: },", ")) It works fine for most of the records, but in some it creates a a comma in front of the name, which I couldn’t get rid of. It happens only in some of the records, and only those that are not duplicated to begin with For the full picture, the next step is a field that takes the string that I created and find the name to the left of the comma which gives me just the name. Any idea what is it that I’m doing wrong? Thanks!

Community experts, Sorry for the long title. I am very new to coding of any kind and without the community I would have never gotten this far. Basically, I have a synced table in my base and I have a automation script to link the records based on a field, “Part Number” in one table and “Part#” in the other. The trigger for the automation is “When a record enters a view”. I am linking the record in the synced table, Orders, to the Inventory table. I am able to make this happen with the following code. var mainTable = base.getTable("Inventory"); var mainView = mainTable.getView("Vendor Source Inventory"); var mainTableRecords = await mainView.selectRecordsAsync({fields: ["Part Number","Vendor_Source_Usage"]}); var lookUpTable = base.getTable("Orders"); var lookUpView = lookUpTable.getView("Completed Vendor Sourced Orders") var lookUpRangeRecords = await lookUpView.selectRecordsAsync({fields: ["Part#","Order Qty","Updated"]}); for(let record of mainTableRecords.records) { let look

i have set up nodejs and did block run. then i copy the url in App Url field and i get Can‘t connect to your local app, did you block run ? https://localhost:9000/ on local comp is working