Other Questions

Hello. I’m new to Airtable and want to know if anyone knows what is the best form to use if I want to create a daily progress report for a team of people. I would need to be able to keep/archive each person’s report on a daily basis. Thank you!

I have the following usecase where I am stuck in the implementation: I have two tables: Table 1 - Technologies. I have several entries in it e.g. Skype, Teams, GoToMeeting, etc. Table 2 - Disciplines I have several entries in this table as well e.g. Chat, Meetings, Planning Now I have added a new column in table 1, in which I can select the disciplines from table 2: e.g. Skype - Chat, Meetings So far so good, I got this far. What I want to do now: Counting entries: I want to add up in a column of table 1 how many disciplines of a technology are stored: e.g. Skype - Chat, Meetings - 2 What is the correct formula for this? CSV export: For export I group table 1 by name. If I now export the CSV I get the following structure: Colum 1 | Column 2 Skype | Chat, Meetings But now I need to get the following structure: Colum 1 | Column 2 Skype | Chat Skype | Meetings Is this possible, if yes, how? I have created the dataset so far, and could also provide this dataset via chat or screensharing.

New to Airtable so just finding my way around. I noticed when I installed the Scripting App it says the Scripting App is free until September 2021. What happens after that? I can’t find any further information. Will it still be available and at what cost? Will everything I create with the scripting app now still be available after that? Thank you

Hello, I’m attempting to integrate Airtable and Power BI to create reports. Using the API authentication key, I am able to connect to one of my tables in Power BI. However, the JSON string only contains 100 rows when connected. Airtable and Power BI - mpolino.com I have gone through this blog but still only 100 records are loading. Is this a limitation ? this is my query let Pagination=List.Skip(List.Generate(()=> [Page_Key = "init", Counter=0], each [Page_Key] <> null, each [Page_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null, WebCall = try if [Counter]<1 then Json.Document(Web.Contents("https://api.airtable.com/v0/mybasekey/tablename",[Headers=[Authorization="Bearer airtablekey"]])) else Json.Document(Web.Contents("https://api.airtable.com/v0/mybasekey/tablename? offset:""" &[WebCall][Value][offset], [Headers=[Authorization="airtablekey"]])), Counter = [Counter]+1 ], e

I’m trying to use a Airtable to track status on a project that has different potential vendors and customers. I need a way to bring status updates [notes from rich text]* into a field that is aligned with specific milestone [rows]. There can be multiple status updates in the same field e.g. Vendor A has status “xyz”, & Vendor B has status “abc” My approach has been to create a link between my project table and Vendor table, and then create a rollup field for Status. The issue I’m having is if I add more than one vendor, there’s no way to tell which status update is assigned to which vendor. I think the right approach is to have a formula that would enable concatenation of Vendor Name and the related text from lookup and can display the information in a more readable format "Vendor A Name + “Status Update” “Vendor B Name” + “Status Update” Etc. Would greatly appreciate help on solving this issue. *note ideally I could parse the rich text and take the entry from latest entry, or e

var Airtable = require(‘airtable’); var base = new Airtable({apiKey: ‘key*************’}).base(‘appW1Vv1p4IHxtiWQ’); var accumulator = ; let table = base.getTable(“People”); let query = await table.selectRecordsAsync(); console.log(query);

A customer has shared a table/view with us using a private link and a password. We need to retrieve that data automatically, preferably using C#. The customer will not be granting us API access. I see that we can download the data as a CSV, but only through the web interface. I would prefer not to make something so “brittle” as screenscraping. Is there an alternative process we could use to retrieve this data?

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