Other Questions

Hello! I try to get all records but can’t parse them . Could you help me? var Airtable = require(‘airtable’); var base = new Airtable({apiKey: 'key******************).base(‘app******************’); var accumulator = ; base(‘Table1’).select({ maxRecords: 15, view: “MainTable” }).eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { accumulator.push(record._rawJason); }); console.log ( accumulator); fetchNextPage(); }, function done(err) { if (err) { console.error(err); return } });

Hey Everyone - Quick question, but I am stuck. I have this formula to determine if my meeting happened this week or not WEEKNUM(NOW()) = WEEKNUM({Meeting Date}) I would like to use a similar formula to find out if it was last week. My assumption is that I would use the same beginning and the meeting date field, but if I say less than it will give me all the previous meetings. Any ideas?

Hello, I would like to automatically generate a formstack document when a new record is created via an airtable form. Today I need to open the apps bar, select a record, and then click the document name in the formstack block to generate the document. I would like the document to generate automatically and ideally not using Zapier. Is there a script I can throw into an automation that can handle this? TIA!

We’re likley to exceed the 50k record limit this year, and I haven’t gotten an answer from two queries to Airtable support. Should we migrate to another db, or is there some workaround?..we’re willing to pay more, but the biggest number I’ve heard is 100k records, even with the Enterprise plan. Someone said that Airtable could be a front-end for another db…any insights would be appreciated. thank you!

How can one disable the “Base Description” pop-up on first view (that is explained here)? It’s routing viewers to the [unintended] list view when they should be going to a Gantt chart view. This issue doesn’t happen on subsequent visits.

Hello, I would have liked to use my airtable database with a button executing a script directing to a directory of a server taking the variables of each line. Example: https://1111.111.111/VOLUME1/field1/field2/field3 Would it be possible to have this kind of button in airtable that automatically opens the MAc Finder or windows explorer to the directory given for the line in question?

Hey all. I’ve searched a handful of times but can’t seem to find another example of what I’m trying to accomplish. I’m looking for some help with an automation or script that can automatically add the correct inquiry number. We do this manually and it’s slowing down our response time and ability to, well automate processes. Our inquiry numbers syntax: YY-NNN or an example: 21-846 The next inquiry would be 21-847. This being the two-digit current year as a prefix and then just an integer of the number of inquiries. As others have noted, the “Auto-Number” field is not sufficient. The field name is Number in Table RFQ where we’d like this new number to go automatically upon new record creation. Our inquiries mostly come from an airtable embedded form. Sometimes we manually enter them too.

So, I’m building a planning base where I have a pricing table with 4-5 different columns setting criteria and the final column displaying the price for the product that fits that criteria. Demo data: Item - Critera1 - Criteria 2 - Criteria 3 - Price Mug - Blue - Tall - Decorated - $4 Mug - Red - Tall - Decorated - $4.5 Glass - Blue - Tall - Decorated - $3 Glass - Blue - Small - Decorated - $4 Now I want to use a lookup from the planning table to the pricing table where I’ve narrowed down the items (Tall, blue, decorated Mug) and have the calculated field return the value $4. I accept any suggestions that would assist me with solving this problem :slightly_smiling_face: thanks /elfur

I am on the pro plan but when I create a new workspace it defaults to Free why is that?

Hi Community, New user here, so apologies if I am not using the right terminology. I have a table with multiple records. In one record, one of the fields is a multiple choice list of camera brands. i.e Nikon, Canon, Fuji etc. In another record, can I somehow ask to show JUST those that have the multiple chose answer - Canon, for example. I have been playing with record linking, but it seems I then can’t retain the multiple choice option? Many thanks! David

I’ve tried to make conditional value lists, but so far failed. Is there a way to do this?

I have a “Source” base and a “Second” base. I want to do calculations in the “Second” base using data from the “Source”. The problem is that the data comes from a lookup in a table of the “Source” base. This seems to come forward as text not as a number so I get errors in response to the calculation. Bringing the data forward from the 2 original tables in the “Source” base doesn’t work since they need to be synchronised into one record. I need to do this because I do not want to do this work in the original database - which is already too complicated. I also want to keep it away from other users. Help please?

Hi, I’m totally new on Airtable and I’m searching to make an asset inventory to manage all our computers. Problem is : I have 20+ columns and i’m looking to compile the information to something like that : Any way to do that or something more compact than a table? (Gallery view may be an option but I can’t work with it to make 1 object per column) Thanks

My base has event dates and times listed, and I want the data to show up on Google Calendar. However when I added it onto Google, all my events were listed with wrong times… Although the iCal url Airtable provided for syncing stated my timezone, I noticed the calendar timezone was GMT 0. It seems to be the default and cannot be changed. Some questions: • Is there any way to overcome this timezone issue? It’s critical to have the event time listed in the calendar. • Does my Airtable base need to specify a start and end time? Right now it only has a date and time. Any help would be greatly appreciated!

I’m an experienced RDBMS developer, having a little trouble adapting to the Airtable scripting paradigm. Say I have two tables, Updates and Users. Updates has a field UserID, which links to the ID field in the Users table. Now let’s say I have a second Updates table, let’s call it UpdatesFiltered. I would like to know, using the scripting app, how can I copy a subset of records from Updates to UpdatesFiltered, preserving the links to the Users table? I’ve gotten as far as reading the Updates table and inspecting the fields in the records, but I’m not sure how I’m supposed to manage the linked UserID fields. If I understand correctly, it won’t do just to copy the UserID value from one table to the other (or will it?) Do I have to explicitly copy the record ID from one table to the other? I’m not even sure how I would be able to do that. Thank you.

I’ve been “shopping” Volunteer sign up/scheduling systems and I’m trying to see if there is a way to create one in Airtable. Here is what we are looking for: Volunteers to Check In for their schedule and check out when they are done Volunteers to sign up for a scheduled opportunity Track Volunteer Hours Schedule outgoing reminder emails Integrate with Google Calendar I know how to create a sign up form and track background checks etc. It’s the check in/out and schedule system I’m trying to create. Has anyone created anything like this?

I am attempting to populate Stripe Connected Account monthly revenue information into an empty row on already created Airtable records. Is there a way to use a field I am titling “Stripe ID” (which will be populated) as a reference field to populate the correct monthly revenue with the correct Striped Connected Account record?

Hi! I would like to create an CRM email system where I create two tables, one for People and another for Emails. The people table has individuals who need to be sent different kinds of emails depending on their status (new lead, qualified lead, etc). The Email table contains records for each type of email template, each with a field containing the HTML for the email, including bracketed information specific to an individual (ex: {First Name}, {Email}, {Last Name}, etc). The system works by linking an email template to a particular user, generating a unique HTML code based on the template and some of the fields unique to the user. The main problem is the SendGrid block seems to generate the HTML upon hitting “Preview”, not “Send”. That means it just pastes the HTML code as text, rather than generating the email as it should be. All I’m adding to the SendGrid block Body field is referencing the field that contains the HTML code in brackets. That means I can’t actually send different HTML

I am creating a calendar that shows upcoming customers that we will be meeting with throughout the month, but they are from all over the state, and I wanted to be able to at least see what city they are in when I use the calendar view. Is there any setting I can adjust so that I can see the customer name, and then underneath the city they are located in?

My Airtable has purchase order data, and I need to be able to present a single page, multi line PO for records and vendors. I have an excel doc that will “make it pretty” for me, as long as the data is present. If I was the user I would just copy/paste, Save As and move on. The person who needs the PO is very computer illiterate, so I need a print button or similar to “make it go”. All I need is to copy the data from a specific view into the Excel doc (preferably a blank master doc) and then either have it automatically Save As or at least pop up the Excel program so Save As can be done manually. Since this is an instant trigger I don’t think I can use Zapier/Integromat for it. I know that there is a script on here for pulling data into a power query (sorry, am on mobile. link later), but that seems to be button in Excel doc, not button in Airtable. Is it possible/effective to try a script? Is there something else I don’t even know is an option? Thanks for the help.

Hi, I’ve been searching for a way to create a button (either in the table or in an app block, I don’t care where) that will create five new fields and make them appear in the currently selected view or in one specifically selected in script bock. Again, don’t care which way it works, as long as I can make this possible. I have a team where we do call lists for different events and every time we make calls, we (meaning I) create four new columns Link to records field so people can select their name to say they are going to make the call A checkbox field for tracking whether they made the call A checkbox field for tracking if the person said they’ll attend A checkbox field for tracking if they fully registered on our registration site. A single line text field to use as a notes column. So far I’ve seen a lot of ‘no’ answers for similar questions, but it seems like this should be possible from the scripting documentation. There is the createFieldAsync function in the API. I’m not trying

One of the linked records in my table is linked to a synced table in my base. 3 days ago, when the table synced, all of the records that were populated in that field got automatically deleted. The source table still exists and wasn’t changed. How to get all the values that were deleted back? It also seems like I have no snapshots in my revision history even though I am on a pro plan.

Is it possible to change the displayed layout of buttons when using input.buttonsasync? I’d like to display them in a vertical list, if possible. Pictures included to better illustrate what I’m asking. Any help would be most appreciated, thanks!

Hello! New user here! I have a projects table and a tasks table. In my projects table, I have a record (a single project) that contains a linked records field from my tasks table (multiple tasks related to my single project). I would like to duplicate this record (single project) along with creating duplicate linked records (tasks). As it stands, the “project copy” does not create copies of linked records (“task copies”). Instead, the original linked records are associated with the “project copy.” Essentially I want to make a “project copy,” that contains “tasks copies.” How do I achieve this? Thanks! Edie

I have two tables, one showing teachers/trainers assigned to specific classes. For Example Colume 1 “Classes” (English, Math, etc). Too each class are assigned different teachers (in Colume 2) In a second table I want to plan concrete dates for classes. So I have three colums “Date”, “Class” and a third “Teacher”. Colums “Class” and “Teacher” are linked to my first table. For the colum “teacher” I want to limit the view depending on the choosen value for class (only display the teachers that can teach that class). The view function seems not to help, since the filter/view always depends on the choosen value for class and needs therefore to be dynamic. Basically in a data base i would use a Dimension Table but I could not figure it out in airtabel. Any ideas?