Other Questions

I have 5 teams and an Admin reporting to one person in the org chart app. I want to change the way they are ordered from left to right. For example, the Admin is currently in the middle of the org chart and I want this person to be on the far left or right. I don’t see an option for this and I can’t determine what logic is being used to set that order. Does anyone know how to change the order?

I believe I saw a 5-seat starter pack for Airtable Pro for $29/mn. This sounds perfect for us, especially while we’re developing Airtable as it is much more affordable than the $20/user/mn standard pricing. However, I can’t figure out how to find it again and purchase it. Has anyone else seen this deal who can point me to it?

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

Hi all, I have a formula with a date field. The strange thing is that users can’t choose any day in May 2021. Furthermore, I can’t choose it also in the field from the backend of the formula. Do you know why does it exist and how can I solve it? Thanks in advance

New feature request. It would be very helpful to have an editable field order number next to each item in the field visibility dropdown. This would show the current order of the field in that view, and then to change the field position instead of drag and dropping you change the field order number. So instead of being field 23 you change it to 4 and the field then moves to the new order. I have a table with 300 fields and when I need to rearrange for new views, it takes a lot of time to do. Yes I know, need to reduce the field count, working on it. :grinning_face_with_sweat: If anyone has any tips or can point me in the direction of a tool to speed this process up, it would be much appreciated. Apologies if asked before I couldn’t find it to +1.

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

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?

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