Other Questions

Can I password protect a form?

Hey everybody. I recently got introduced to Airtable and I am currently setting it up for project management. For estimating when a task is completed I want to know whether a date time is after the end of the workday. E.g. Raven starts a 2-hour task at 16:30 with the workday ending at 17:00 - that should be picked up by the system. My intended approach is to add the raw time to the kick-off datetime and then compare this to the same datetime except at 17:00. This is where I have an issue: How do I extract the date, month and year from a datetime and then set my own HH:mm parameter? Virtual cookie to the wizard who can get me out of this nut :slightly_smiling_face:

Hi everyone, I’m pretty new at Airtable and I making a little testing project to see scripting functionalities. Is there any way to change the header value in some table with scripting app? Thank u all.

Hi everyone! We are currently setting up our social media planner in Airtable and we are wondering if there’s a way to automate the reporting. For example, would it be possible to automatically feed the performance of the individual social media posts (on Instagram, Facebook, Twitter, Pinterest) back to the Airtable sheet? If so, what’s the best way to set it up? Thanks! Jess

I suddenly am not able to use the app on my old phone (Samsung S4) even though it has Android 5.01 on it (it wont update to any newer version). its been fine for about 8 months, but today it wouldn’t show normal updates, and when i tried to do a reinstall, it says it cant run on my device. I understand this phone is obsolete, but its been very useful in my production environment to have this old phone to do production time tracking without tying up my regular phone or laptop which would be too inconvenient I also tried to run Airtable from Chrome, but it wont activate, sends me a magic link that is only applicable on a laptop or desktop. any work around? thanks

Is there a way to search for the appearance of a certain word that might appear in any of a number of fields? I know one can set up a filter and use “or” and list all the possible fields, but is there a simpler way to do that? Thanks, Robert

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 t

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

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

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/tablena

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

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?