Other Questions

const common_js_object = {COMMON_OPTIONAL: 'Optional',COMMON_NA: 'N/A',COMMON_AND: 'and',COMMON_TERMS: 'Terms of Use',COMMON_PRIVACY: 'Privacy Policy',COMMON_OR: 'OR',}}));console.log(newRecords);const batchSize = 50;const numRecords = newRecords.length;for (let i = 0; i < numRecords; i += batchSize) {const batchRecords = newRecords.slice(i, i + batchSize);await table.createRecordsAsync(batchRecords);console.log(`Created ${batchRecords.length} records`);}I written this script to create a new record inside a table from a javascript object. But I want to be able to update the entire table from this object instead of creating new records. I am not sure how to use the updateRecordAsync method. I am new to coding. I tried different approaches but showhow they all gave error could anyone help me. 

Hi all,I'm very new to scripting and am struggling with the syntax to write to a multiple select field. I have single select fields ("Monday AM", "Monday PM", "Tuesday AM", etc) that can be Y, N, or blank.I have formula fields ("First Monday AM", "First Monday PM", "First Tuesday AM", etc) that calculate a date based on a user-entered date.I have a multiple select field called "Availability". If "Monday AM" is Y, I want to pick up the date from "First Monday AM" and put it into "Availability."Here is my code:  let scheduleArray = [];if (r.getCellValueAsString("Monday AM") == "Y") {   monAM = r.getCellValue("First Monday AM");   scheduleArray.push(monAM);}if (r.getCellValueAsString("Monday PM") == "Y") {   monPM = r.getCellValue("First Monday PM");   scheduleArray.push(monPM);}await s.tableSource.updateRecordAsync(r, {"Availability" : scheduleArray}); Error:Can't set cell values: invalid cell value for field 'Availability'. Cel

In the record review of a table I have a field for another linked table. When I click the “+” I get an option to create new records (linked table). How can I customize the form that appears after clicking “new record”, for the linked table? I don’t seem to find that option anywhere in the interface designer.

Love the new "List View"I created a List, but I see no way to PRINT it.Also, when I download the LIST VIEW to csv, I get a LOT more fields than are on the List View.Anyone figure out how to print the list in List View?Thanks!Lawrence

I want to sort these groups 1->9 by the Sum. There have been a lot of questions on the topic but zero definitive answers. I will buy the full version of Airtable, but only if this can be answered. Thanks!

Hi Everyone, I’ve got a table that pulls Google Calendar events for my team into Airtable. It’s there to build an interface that breaks the events down and gives summaries as to how many days are spent On Site, Working from Home, in the Office etc… I need to find a way to be able to filter out, or mark with a checkbox, the records that happen on, or span a weekend. Google Calendar only brings in start and end dates of events. Any pointers would be fantastic. I’m quite an experienced Airtable user, but have no experience of coding but willing to try. Thanks!

It would appear that the URL for attachments is no longer showing the file extension, and the location has changed a bit as well. It’s breaking things for me :sob: Wondering if this is a bug or a new way attachments are being handled. Any thoughts on this appreciated.

Hello, What is happening when the "open form" button disappears for certain users? Attached is my view with the button showing, but for colleagues it is no longer there:  Thanks!

I use galleries to show selections of fonts and real-life projects using those fonts. Since the latest major app update, I have had numerous issues with the airtable app. The current one is that my gallery photos won't load unless I scroll through them all from the grid view first. Also, every time I change filters, the app crashes, and then I have to repeat the above process. Something that takes an average of 2 minutes every time. When I am working with a customer this causes a massive issue. Honestly, I miss the old app versions, but since going back to those is not an option, I'm wondering if anyone else had had he same issue; and if you have...were you able to find a way to fix it?

We use AT to manage our donors. I am trying to set up a reminder as I assign tasks to my team members. How do I do that?

Hi, I invited a new user to a base, however, the emails aren't arriving nor are the confirmation emails arriving.I emailed them the link to the base which arrived, however, they need to confirm their email but that confirmation email is also not arriving. AM I THE ONLY ONE HAVING  THIS ISSUE?@dashler78 @support12 

Is it correct that it is not possible anymore to add a new field within the mobile app? Or am I doing something wrong?

Table (A) includes names of 1000s of candidates applying to our program. This includes 20 columns with all their info. The final column has the decision “Accepted” or “Rejected” I want to create a different table - let’s call it Table (B)- whereby it only includes the names of the “Accepted” candidates so that I can continue to track them on other metrics. How can I get the first (or second) column in table B to check those tagged as “accepted” in table (a) and then list selected data points (e.g. their the names) in table B? Any ideas how to do that?

I am trying to send data from Looker, emailing it to my airtable email address, and then have it create a table in Airtable. I’ve been able to do it a few times but my recent attempt gives me this error message: “Column names must be non-empty strings. Ignore this email and wait for a different one” I’ve tried to change the layout, etc. but nothing seems to work. What does this mean and how can I fix it?

Table A = projects, with a linked record of “Property” to table B Table B = property, with a collaborator field Previously had a rollup field in Table A to pull a Property based collaborator into a project, then have an adjacent field in Table A to override this rollup with a manual collaborator as needed, and then an automation to update the actual collaborator field with the final result (override, or standard assignment). Total = 3 fields and 1 automation, and no single field for easy management. Preferred setup: When property is selected for a project, automation runs to lookup the collaborator in the Table B, and assign on the single collaborator field in Table A. If the project lead needs to change this assignment, they can then just remove and reassign collaborator. Total = 1 field and 1 automation. HOWEVER… when I go to setup automation: Trigger: when property is updated Conditional Action Condition: When property is not blank Conditional Action Actions: Find Records - searc

Good afternoon. (UK)Yesterday, I happily copy/paste content from rows to the Comments when a message with an error popped up to refresh. I did, only to have to redo the unsaved Comment I was working on. This happened a few times, so I checked on AT state, and no issues were reported. I experimented with another entry as that was saved I concluded there is a limit on the number of words or characters for each comment. Is that so?  (I managed to save the comment by split the content into several separate Comments, but that's not ideal)Also is it possible to re-order the Comments or insert a new Comment in between existing Comments?   

I am on Pro plan  and share my base with one person (editor) and paying for him as well.Now I need to share another base from the same PRO workspace with the same person. Will it incur additional $240 a year or since I am already paying for this person there won’t be any additional charges?Thank you!

I'm new to Airtable and would love some help! I have a general inquiry form on my website. Once someone completes that form, I eventually need them to complete a second, more in-depth form. Is there a way to link the responses of the in-depth form to the original "general inquiry" record? Essentially, I'd love to be able to have all information related to a potential client connected. I hope that makes sense! Please let me know if I need to clarify anything. 

Hello,I work on a marketing team and we were wondering if it is possible to have multiple people work on the workbook, enter and view information simultaneously? Like google docs where multiple people can be working on the same document entering information simultaneously.Thanks

Hi everyone - I can see that this has been asked a few times before but I can’t seem to find an answer. When accessing a shared grid view, if you apply a filter and try to print the view, the filtered fields still show. I need the person accessing the shared view to be able to apply their own filters, and then print the view based on that, but it doesn’t seem to be possible. Is there a solution to this?

I have a table that collects user reviews, and includes a multi-select field as one of the elements for their reviews I want to aggregate the data from this table to generate average ratings etc. I wan to generate an aggregated summary of the multi-select field content, so that the summary field will contain a single instance of each element in multi select fields belonging to the various reviews. I’ve tried using a Rollup field with this formula : ARRAYUNIQUE(values) but I get repeated instances of values that appear in more than one of my original reviews. What’s the right way to distill this down so I see only 1 instance of each multi-select option in my aggregated record?

Hi everyone ! When I click on 'Group by Date" it keeps grouping it in different groups because of the hours difference. Is there a way to make it as it only group the entries per date but without taking the hour in account ?Thanks !  

Hi everyone, First post on here. If you could show me how I can add a URL hyperlink to a button. This would link to an external website. I tried for hours and am not getting anywhere. Please help! Appreciate any insight here!

So I have a Phone Number field containing phone numbers in this format: (123) 456-7890, and I want to automatically convert those numbers to links so that users can click on them to dial.

I have a table where I want all new entries (rows) to have a default value for a single select column. Is that possible?