Other Questions

Trying to print a view in landscape but at first it previews in portrait, with the data. So I cancel and try and select print view again, click landscape, again, then when I select next I see blank pages in portrait, and many, many blank pages. Am I missing something. Thank you.

We have an Airtable form, where people can upload documents. When someone uploads a pdf oder jpg image, we can see the image and download it. But someone uploaded a HEIC file, and we can neither see nor download it. The download button does not show up. PS: I found a not very straight forward way to fix the problem. It’s possible to download the file in the iPhone app. But there should be a fix to allow downloads of these files on a Desktop.

Hello, I am using the CSV import app to update my airtbale base, but one of the values from the CSV keeps returning this message when trying to save the records “The following values won’t be imported”. The value is a percentage, and I tried to change the format in excel to number, general, percentages… but no matter what I do, the same message comes. Does anybody know why the value is not recognized?

Hi team, Is there a way to create a stacked bar chart that goes to 100%; i.e. showing the % split of records instead of simply the absolute count of records. I have this chart to roughly measure conversion rate from various sources; But it would be even better if each bar extended to 100% and instead showed the percentage of records from each source that either booked or were lost. Is it possible to create something like this; either by manipulating the data via formula, or with a chart/app option that I’m missing?

I’m getting an over limit warning in a base with only 1,034 records. (Nothing is filtered.) It’s not a problem — I’ve been thinking about splitting up this base anyway. But, what gives? Is the limit 1,200 or is it something less?

I am getting this error many many time a day only with Airtable Site I have 32 GB of Ram, Chrome 64 What can I do to avoid it?

Hello! I need to get the number of each row in the table. I tried to use the Autonumber for this and it worked until I changed the number of rows in the table. In this regard, i have a question: Is there a way to automatically update the Autonumber every time a new row is added or removed? Or perhaps there is another way to get the current row number?

Hi, I’m using for the first time the Jira Cloud App. It simplifies a lot of step. But I’m missing on simple field and I don’t think it is a custom one. I’m looking for a Resolved field. Like the Created or the Updated which are imported fields with date and time. Is there a way to get this field in airtable through the app? Regards, Christian

Hi there ! I have been using airtable for 1 year now and I can"t figure out a solution for the problem I have right now. Here is the thing : I would like to develop a form in which people can process internal orders for suppliers, products and quantity. In the form we would have : Existing client, if not, create one Then select the first type(s) of product(s) from the supplier A Select product(s) from supllier B etc … I have 15 suppliers and +/- 20 products per suppliers I tried many things, but does not seem to work … Should I use a third party tool or something ? Do you guys had the same issue ? thanks !

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 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,