Other Questions

I have a table full of records. The records are added each week and stamped with the date they are added in a column. When I chart this, I get the total number added each date that is listed; but I want to show an aggregated chart which has the full number of records and how much each week has ADDED to it. I’ve seen a few linked reports with rollups that seems confusing and a bit overkill. In Excel charts there’s simply a “show aggregate” button on the graph… is this not a thing people do in AT?

I think this is a long shot, but I hope the community can come through. I operate a service business that requires me to travel to client’s homes. I currently have a client table that includes names, addresses, etc. that table has the Google Maps App installed as well and locations are shown on the map. In the same base I have a table of upcoming jobs which pulls in client names and addresses from the client table and a manually entered “sequence” field that numbers the sequence of jobs for the day. That table also has a checkbox field for when a job is completed. I’d love to find a way to create a public view that will show customer first names, maybe a house number (redacting other address info for security), and use the map app to calculate an ETA to the next job based upon when the previous job is marked complete and the distance to the next destination. I’m aware if isn’t a simple ask, but I’m not even sure it’s possible with airtable’s capabilities. Thanks in advance for helping

Hi all – Is there a way to force a sort / ordering of the columns in the matrix block? They appear in somewhat random order. I have column names representing months in a year, and I’d like them sorted chronologically. Ramon

Exploring using Airtable for naming. I have a table with a large list of name ideas (col 1). Other columns include category, notes and vote (rating / single star toggle). Only a handful of these name ideas will be voted for / picked, so I’m wanting those that are to automatically populate a second table. Is this possible? Or is there another way? PS filtering by rated is not a desirable solution.

Hi everyone, new here. Im trying to graph continuous dates on the graph block. Airtable only uses the dates on the record and skips any dates for which there were no records created.It’s very easy to do in Excel, but am unsure if Airtable Can do it. Help?

Anybody who was able to resolve the issue with or without contacting Airtable Support. Was Airtable support able to address is with a permanent positive result? My workflow in Integormat: Airtable > Remove BG > Google Drive > Airtable Drives me nuts. Just a few months ago it worked on 100 images fine when I was doing the uploads on one day. So I can’t tell if it worked for me other than the workflow worked in 2019 reliably. Nothing changed about my Integromat workflows (but as precaution I created a 2nd new integromat workflow to see if it fixes the issue…) The images are uploaded as images but for some reason Airtable considers them as garbage and delets them because it is unable to process the thumbnail. The uploaded file initially shows as a generic grey thumbnail. In most cases Airtable erases the file within a few seconds, in other cases it leaves there in the same pitty state. If I quickly download that generic icon file, and then manually upload it, the upload works f

Hello, Is it possible to create a modal dialog that shows over whole screen from SDK blocks? I can creade Dialog from SDK blocks but it shows only over my App on right side. I would like to create confirmation dialog that shows over whole screen, like delete record confirmation. Is it possible with SDK blocks?

Hello, We are using Typeform to collect responses, which eventually end up in Airtable. Responses come with image links, due to limited storage in typeform we want those images stored in some cloud server e.g. Amazon/Google and once stored in cloud we want Airtable record to update the links to cloud stored links. What solution would you suggest for this? Typeform links look like this:https://api.typeform.com/responses/files/9f880b3c05bfc8db096c4cf291a5f15feb37efd0a99378ce1eb00d6299ca7da8/IMG_8486.JPG We want to upload it to cloud and update Airtable record with the cloud path.

Hello people, hope you can help me to solve my problem. I’m currently using a formula to substitute some character for cleaning my cell : SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Telephone,".","")," “,”"),"-",""),"(",""),")","") and after this step , i’m using an other formula : IF(LEFT(Telephone,1)!=“0”,CONCATENATE(“0”,Telephone),Telephone) it works perfectly but the question is : how can i do the same thing in one formula ? For exemple : (06-07-45)43.56 26 i want 060745435626 (6-07-45)43.56 26 i want 060745435626 Sorry for my english, i’m french :grinning_face_with_smiling_eyes: and thank you for your answers.

Is it possible to export the data operated by airtable with CSV etc.? Is it possible to migrate to an external database immediately?

Hey, is there a way to sort the columns of a grid view by name? Best, Andreas

I have an automation that sends an employee a View. I’d like to give that employee permission to edit a single column in the view. How do I go about making that happen? What if I want them to be able to edit multiple columns in the View? Thanks for your help!

n8n is taking nicely off the ground. It has few integrations yet but it has potential. Nice I found recently it allows me to download images in batch. I know I can do that with Integromat but n8n running on local machine seems a bit more handy once it is setup. It’s a chrome app but still good as it can get because it is free and doesn’t cost a penny when running on the local workstation or my own server. Anybody managed a better way to download multiple images at once with n8n? I described the workflow and a few issues along the way but their community is much smaller so no response there yet. Interestingly they run same community board software as Airtable. n8n – 5 Jul 21 How to download multiple attachments with Airtable node? I am trying to use the Airtable node’s List operation to get a record and download the attachments. I’m able to download a single attachment, but when I specify a second one, it doesn’t get fetched. The tool tip recommends “N

Hi all! Really liking airtable so far. What I’d like to create is an easy Presentation from one of my Views. Basically what I want would be, from a table like this: To create a view like this: That way I could just copy it straight into the presentation. I’ve created already in Google Sheets & it works dynamically, but I’d rather use Airtable. Is this possible? If so, would love to be pointed in the right direction as I’m a bit overwhelmed with all the apps. Thank you!

I use Airtable to manage workout programming and membership for my fitness class. I would love to be able to give users access to their individual profile so that they can view their attendance, workouts, people they have worked out with, and individual stats. I want them to be able to log in to air table to enter their data and stats for their performance in workouts. Does anyone have an idea for how to do this?

Hello everyone. Does anyone know if there is a way to bring the most recent activity from the recent activity column inside a record and display it in a cell in a table?

I am trying to create a formula that will change a column to say Active or Inactive based on the numbers of days before an item expires. For example: I have contracts that expire over the next four years. When one of the contracts gets within 6 months of expiring I need a column to change to Active or Inactive. All of the Actives will be within 6 months of expiring Inactives will be anything valid for more then 6 months. I tried to use this formula I found in the forums and changed my expiration date column to Purchase Date just so the columns would match and it keeps telling me that it is an invalid formula. IF(DATETIME_DIFF(TODAY(), {Purchase Date}, ‘days’) < 365, ‘Inactive’, ‘Active’). Thanks for any help you can provide.

Hello, I’m having issues with Autonumber. I have a simple sequential ID being created as an autonumber, starting with 1, through 2, 3, 4, etc. When a new record is created it automatically assigns a ‘number’ to it. So next in this sequence would be 5. However, for example if we now delete record five, and a new record is created after this, instead of numbering it ‘5’ based on the sequence, it starts at 6. This is a real problem because a bunch of records were created to demonstrate to a colleague, and were then deleted. So now the numbering is starting at much higher than the next in the sequence. Any reason why this is doing this and is there any way to ensure it’ll just create a new number based on the previous record number?

Hello, So I need to embedded several forms (to the same Table) on multiple pages on a website. These will capture roughly the same information. But, I need to know where the enquiry came from. For example, we have individual landing pages on our website for people coming from Google Ads, from Facebook Ads, direct enquires, etc. In Airtable I have a ‘Source’ field (Google, Direct, Facebook, etc) but I need this to be pre-filled BUT hidden on the form itself (so the customer doesn’t see it). This is so as the entries come into Airtable I know where they came from. I don’t want to use a separate Table (which I know would solve this) as I need all records in the same Table. It seems the prefill_ formula only works on visible fields, not hidden fields. Ultimately, Is it possible to differentiate somehow which records came from specific embedded forms on different webpages…? I hope that makes sense.

I have a Orders and Line Items tables that are linked together in the typical parent child relationship where an order has many line items. My question is how can I append the line item index (+1) to the order number in the line items table? For example: Order number 20001 has 3 rows of line items in the line items table. I already have a row for each line item in the line items table but I would like a column with 20001-1, 20001-2, 20001-3 ({Order #} + index). Thanks in advance for any help!

Is there any form that I can fill out for the website to be listed on the marketplace page? or email thanks

I’m using employee directory base, and it’s great, but what if an employee gets promoted and his/her title or even department changes? I can manually update the data but is there a way to keep track of that so I can view the history or know when an employee got promoted?

Here’s what I am trying to achieve: When a user submits data on our AirTable form it populates a row (as it is meant to). I’d like it so that when a user submits data the row has the sidebar change color to, say, “red” - this way I can quickly visualize the new data that has come into the AirTable Table Thanks!

I’ve always dragged photos from photos app directly to airtable Attachments field. Now, only some of the time it seems to work, and the rest it doesnt acknowledge my hovering cursor… and I instead have to drag them from Photos app to desktop, THEN from desktop to Airtable… what am I missing here? why is it only sometimes and not all the time

Hi Airtable! I am on the Creator Plan, and tried using the dedupe app, but it won’t open up. I was able to use it before, though. How can I use this app on the Creator Plan? Mary