Other Questions

Hello!Is there a reporting tool that shows how many actions (edits/updates) reps have done in a work base? 

Hi fellow Airtable enthusiasts!Does someone know if there's a way to flag records created or update by the API? Currently, we have a few integrations using the API, that are authorised by a certain user in Airtable. I'd like to flag those using a formula (if possible, otherwise another suggestion is welcome). Records created by the API show 'User X created through API' but these records re indistinguishable from records manually created through the same user. We don't have the luxury of adding another fictitious account / user, just for API purposes. Would there be another way to extract that? Currently, we can only display the 'Created by' field, but this shows both categories of records in the same way.Thank you for thinking along! Happy to clarify the use case if needed 🙂best,ElvinBest,Elvin

Is there at the moment any formula, function, working script or any else working solution to deal with a rental activity? (we need do track what is available or not, when it is available or not, who rented what etc. not only checking calendar view, but automatically checking if and when an item is available or not.Thanks in advance  

I have shared an Airtable view with one of my clients. They work at a Blue Cross plan with high IT security. The person is trying to download the view as a CSV. Here's what she said: "When we have it up and then I try to download our report (using download CSV) it states, “Preparing CVS download..” but then nothing pops up/opens up to us to download the report." I've attached 2 images that she sent me showing how it hangs. I advised her to do the following (and the same issue is showing up, not only on her computer, but also a colleague's):1) Log out of Airtable and log back in, then try again2) Clear your browser cache and try again3) Restart computer and try again4) Try login on a different browser, like Google Chrome or Firefox.  Please advise if there is something I need to do, or instruct her on? 

Hi!I need to create and handle from one main account different projects. Each one of them may have different team members, and at the same time it can happen that I don't want all team members in a project to be able to see all the information. Also, I may want to organize the stuff in "areas", such as mkt, sales, whatever, and use that as the "filter" to provide or not provide access to a certain team member.Do you have any idea on how I can manage this? Thanks!

In a base I am working on, I'm using the timeline view for daily trip routing within our fleet. These trips are timed to the minute and are not always on the hour (eg, a trip may go from 7:59am until 8:50am). If I need to drag this trip to a new swimlane on the view, it does not retain the times entered.Based on what I am seeing, any movement other than perfectly straight up or down will move the trip to the previous or next hour (eg, it would move to start at 7am or 8am). It sounds like the times on timeline are only set up to be moved in one hour blocks.Is there a way to either lock the times in so they cannot be changed when moving, or make the level of detail such that the times are retained (eg, moving a trip that starts at 7:34am keeps it at 7:34 instead of forcing to 7 or 8am)?

Hi there,I'm trying to get an Airtable and Monday.com integration working with a basic 'if this pulse changes on a board, find the record in Airtable and update'.I'm doing this with Make.com. My first step is a watch trigger that passes items which have been changed.For the second step and to match changes between platforms, my search-by-formula looks like this:IF({{3.previousValue.name}} = {Project name},1,0)Where 3.previousValue.name is the name of the project before it was changed in Monday, and {Project name} is the primary field of the Airtable record. Any project name that returns true should be passed to the next step of the scenario.However each time this runs, it searches the second value literally and returns:IF(oldMondayProject = {Project name},1,0)But of course nothing matches {Project name} because it's a variable, not a value. My third step would then be updating the record found in the second step with the value from the first step (newValue.name).I'm not really sure wha

When I add new options to a multiple select field. They list in the order they are added. Is there a way to sort them by the order they are listed in the pull-down? To be clear, I’m not trying to sort the whole set of record rows, just the elements inside each multiple select field box.

I created this post a couple of years ago and we're still hitting a wall trying to figure out the best way to accomplish this: Dynamic formula to change output based on username viewing the tableI have started thinking about using an external no-code app interface designer to create a simple portal, where someone can login, search all of our PRODUCTS table (from an Airtable view) and get a custom URL with their Affiliate ID injected within the formula url, like so...https://website.com/cart/?ref=AFFILIATE_NAME&add-to-cart=PRODUCT_ID&quantity=1Note, I have another AFFILIATES table that identifies partners by their phone, email, and Affiliate ID.If this is too hard, what about an option where the user enters their affiliate ID, and the app, spits out a formula, like above but the app (SOFTR, Glide, etc.) takes an entry field where they enter their ID, and then provides a custom link for all products, using that ID they enter.What's the best way to accomplish this, so that ea

I've been trying to upload an excel spreadsheet and keep getting this error.  I've uploaded very similar ones (not as many rows) but have not got this message before.  Is this because I have too many rows than the platform can handle??  

Hello. I am new to airtable. I have created a base for a gymnastics club to enter competition scores. I would like to be able to create a form where the "name" field would be a drop-down list that would allow the judges to update the gymnasts' scores. Without changing the names, the category or the club. Just the scores by apparatus but I am blocked.

I’m trying to share a view of a filtered grid with other people with a shareable link (rather than creating logins for a few people that wont us airtable much). The issue I am having is when sharing this view, they are not able to see the detail of a linked field from another grid in the project. Is there a way for them to see that through a shareable link to a filtered view? Thanks for the help!

I have a massive multiselect field that needs to be in sync with another table, but I don’t want to have to type all the options all over again. Can I copy all the options and past them into another table? I thought I saw a solution somewhere, but I can’t find it.

I have multiple columns with service-dates for on product. Our products have to be serviced by one of our mechanics after specified periods (1 year / 3 year cylces). So every product-row has multiple date columns- each date column representing the date of a service which was made. So the columns are service-date 1, service-date 2 - etc… To calculate the next mandatory service for a product I need to extract the latest service-date to a seperate column and then add the 1 or 3 years (depending on product) by formula. I’m just not sure how to extract the latest date - since the products don’t all have the same latest service column. A new product may have only one entry - so for ex. 01.01.2019 in service-date1 - an older product has had more services so maybe 01.01.2015 in service-date1 - and 01.05.2019 in service-date2 etc… but I need to find the latest service date of all the products and put them in a new column to calculate the next service date. Looking forward to hearing creative so

Let’s say I have two tables, orders and products with a link between each. On my products table, I can easily see -all- orders involving that product, but what if I have a requirement to show only the latest order, clickable just like the order entries in the “Orders” column of the products table. I know I can use a lookup field (in the products table) to pull the output of one of the fields from the linked order, and filter that by date, but I need this clickable for easy reference. and editing? Is there any solution? Thank you!

I’m using Airtable to create product labels for my finished products and would like to use the Page Designer to create a barcode that could be scanned by either Airtable or Smartsheet. Anyone know a way to automatically convert my alphanumeric workorder number (B0194) to Code 128 (ÌBÇ!~ÅÎ) so I can use Libre 128 Font in Page Designer? Thanks!! Code 128 Barcode Generator?

I have a file with booking/reservation information, which is updated once a week.Since the export is different from the table (names, etc), I have to adjust the fields for the import every single time when I import the information again.Is there a way to simplify this with an external, 3frd party, integration?Thanks for your help.

One of my workspaces was on Creator plan and I believe it was upgraded to Pro Plan Trial once I added collaborator. On the Billing page it is now telling me: “This workspace has 18 days remaining on the Pro plan trial. It will automatically be placed on the Free plan once the trial expires.” I am wondering how I can make sure that this workspace is downgraded back to the Creator plan and not the Free plan. I’ve changed all collaborators to read-only so this workspace should still be eligible to be on the creator plan like it was before but I don’t see any option to make this. Similarly also wondering how I can make a workspace on Free plan into Creator plan if there are no additional collaborators on the workspace?

My goal is to use Airtable to manage orders of materials. The idea is to invite people in charge of the orders as full users in the paid plan, and create a shareable link to a form which could be used by others in our org to order materials - therefore they need the ability to create records through a form only.The people making orders do not need or want to use airtable - they just need a channel through which to make orders. They would be using these forms only very occasionally, like once a month or similar. Also the group of people is large, up to tens of different people with occasional needs.The people managing the orders would be active users of Airtable.Is it possible to use Airtable in this way or would we be billed for every single person who has access to the form? Obviously we don't want to pay hundreds of dollars per month for the ability to interact with Airtable forms every now and then.

Hey there, We have looking to set up Airtable as a CRM and it seems to be a great option with the exception of e-mail tracking. We’re still using Hubspot for e-mail tracking. However, we’re really keen to ditch Hubspot but I don’t think it’s possible to solve the e-mail tracking from within Airtable. Does anyone have any experience with any other CRM’s that offer email tracking and offer a clean/straightforward integration with Airtable? Any help would be greatly appreciated.

I need to upgrade my account. When I go to billing I’m being charged for a second collaborator… When I go to manage collaborators she does not show only in billing. Suggestions how to delete?

Hi! Im having trouble wrapping my head aroubd this but I am trying to duplicate records and assign then a random date inside the current month and then make them not to duplicate on the same date. So duplicate 1 = month/day 5 Duplicate 2 = month/day 7 And so on on a random fashion but checks not to create one on the same date as another duplicate. I will have them linked by month. Any help appreciated

I am trying to find a way to share tasks with a client without them needing to sign-in but with the ability to leave comments. As of now I like the idea of embedding a view but I have not found how to allow comments (say to give approval or feedback). I also tried an interface but that requires sign-in.

I run a team of 4 Collaborators and I need to share the information with them, but I want that each collaborator could see only the records linked with his name.As instance, I'm the sales director, I can see, add, change and update all the clients and records.Jonh is a sales, he can only see, add, change and update his clients (not the Mara's ones)Mara is a sales, she can only see, add, change and update her clients (not the John's ones) I can't find how to do it.

I want information in my base to be available to the public.  I (will) have a public website, within it will be a search page.  From there I would like users to access my base.  BUT, access must be read only; and upon opening the base, I would like the first view to be only the FILTER tab.  Users should never be able to see or have access to the entire base.  Is this possible?