Other Questions

Given a table which records [date, product, price] is it possible to make a chart that have search box to filter which product we want to focus on? My current approach is to double click from the legend, but even they aren’t sorted which kinda frustrating to me. Or were there yet considered approach to solve the exact problem (to make a dynamic chart of price by date for a specific product)? One of the first few thing in my head are to create a table for each product (which seems unscalable), tweet via automation a tweetable ascii art, or even create/update a google sheet everytime a transaction happened.

Hello, I have base with a resource having one user associated. I wish to list all the resources associated more than 1 user. For 1 user selection I use SEARCH( ,{Coloumn}) . What if there is an array of Users . [“Sam”,“John”,“Danny”]. I will to make an api call for the base to return all the rows where User is Either Sam or John or Danny. thank you Yash

Hello Community! I’d love some guidance on a script error that I am receiving while updating a record. I have a table that gets refreshed every day with physician work shift data. The refreshed records contain the physician’s NPI value (single line text) as a text field and I want to populate NPI Reference (Linked field) with this same NPI value using a scheduled automation script. When I run my script, I receive this information: CONSOLE.LOG “Copying NPI 1316340000 into record id recHQVgBpFoVSezTP” ERROR Error: Field “NPI Reference” cannot accept the provided value. at main on line 12 Here’s my script: let Shifts = base.getTable(“Shift Schedules”); let shift = await Shifts.selectRecordsAsync(); // loop through the records for (let record of shift.records) { if (record.getCellValue(“NPI Reference”) == null) { let recordID = record.getCellValue(“Record ID”); console.log(Copying NPI ${record.getCellValue("NPI")} into record id ${recordID}); await Shifts.updateRecordAsync(recordID,

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.