Other Questions

For video editing purposes, how can I input timecode into a field? The format could be either: H:MM:SS (hours:minutes:seconds) MM:SS (minutes:seconds) In the article Supported format specifiers for DATETIME_FORMAT I found “Preset timestamp format”, but that’s a timestamp. My desired format is time duration, similar to a stopwatch. Thanks!

This community has been invaluable for me learning about all the cool things Airtable can do! My question was asked nearly identically on this post and I almost got my answer, but I’m having a bit of trouble on how to add a single select field to my template task creation. Everything works until line 20, where I tried to plug in ‘Category’–a single select field in my Tasks Template–in all manner of combinations , to no avail. Here is the script that works entirely well except for that one line. Can someone tell me what I’m doing wrong here? Perhaps @JonathanBowen since he’s the one that came up with this. :slightly_smiling_face: let eventsT = base.getTable(‘Events’); let tasksT = base.getTable(‘Tasks’); let eventTemplateT = base.getTable(‘Event Templates’); let tasksTemplateT = base.getTable(‘Task Templates’); let tasksTemplateQ = await tasksTemplateT.selectRecordsAsync(); let event = await input.recordAsync(‘Pick an event’, eventsT); let eventTemplate = await input.recordAsync(‘Pick

I don’t quite understand the api documentation for how to retrieve one particular record. You can’t send a body in a get request can you so it all has to go in the url. I’m not sure of how to format it. I have an emails table. I want to do a GET request when a user enters their email address to see if we already have it in the table. The api documentation says to retrieve a record I have to set the url up like this but I can’t get it to work. Please could somebody tell me how to construct the GET request url for this so i can pass in my api key and the email that i’d like to search for?

Hi all, Just wondering if it’s possible to have the Google Maps app as a view rather than an app? I remember the Gantt chart used to be an app only, and is now available as a type of view. Can we do the same with Google Maps app? If not, can the dev team look at this as a future update? Cheers, Andrew

This is so simple, and yet no matter what I try, nothing works. :confused: I want the due date to be 2 days after the creation date. I’ve tried a hundred variations of: DATEADD({Created},+2,‘days’) …to no avail. What am I missing??

I see this was a problem before and was fixed. Well it’s back. Fix in the works? Thanks

The categories no longer show up color coded on my app, does anyone know what to do about that?

Hi Airtable Community! I’m building a base to track musical artists that I am booking for a benefit concert series I will be hosting and I’m having trouble dealing with a specific issue: Right now I have a list of artists with their booking prices, and I need a quick way (through a formula ideally) to take those prices and place the artists in different price brackets (with $5000 increments) to understand how I can pair artists from different price brackets together to meet my estimated budget for this event. For example: If I have an artists who has a rate of $750, they would be in the bracket of $0-5000 If I have an artist who has a rate of $5500, they would be in the bracket of $5001-10,000 If I have an artist who has a rate of $10,1000, they would be in the bracket of $10,001-15,000 ect Basically the idea is that I can use airtable’s grouping function to be able to view artists that are at similar price points. Does anybody know how I might be able to do this? PS: I have also alr

I would like to show the start date, planned or original end date (that was missed) and NEW planned end date. And ideally showing different colors between the dates. Is this possible? Heather

Hi, I want to use record specific webhooks to automate when people click a personalised link related to their own data that record is updated. Click external link > record updated > email sent The code I have is CONCATENATE(“https://hooks.airtable.com/workflows/v1/[etc etc]”,"?RecordID=",RECORD_ID(),"&M=TRUE") Which creates the URL https://hooks.airtable.com/workflows/v1/[etc etc]?RecordID=BLAH&&M=TRUE I want to put this into a button to click but nothing works. IF I put it into a browser it doesn’t do anything. What am I missing here? Do I have to do something like MAILTO:HTTPS …

Hi everyone! ) Say there’s an Airtable database with 50 000 records and restricted to public. We use a script to retrieve its data via Airtable API: php sdk GitHub - sleiman/airtable-php: A PHP client for the Airtable API. This API has limits: 5 requests per second & 100 items per request. If we try to get the data in a faster pace we go over limits and get blocked for 30 seconds by the server (429 status code and 30 seconds cooldown before subsequent requests will succeed) Is there a way to get around these API restrictions and recieve the data quicker? Thank you.

Hi, I have a table with two “linked record” fields, connected to another table on my base. I need to compare the arrays in these two columns, and show a specific value in a third field (formula) if these two arrays contain the same record. Is there a way to compare two arrays using a formula? Again, I don’t want to check if the whole array is equal to the other array, but - to check if the two arrays contain an equal record. Thanks :slightly_smiling_face:

Hi, How can I hide data in column for specific colleagues with editors role? For example, my table have columns A, B, C, D I want that editors can view and edit A, B,C columns But column D will be hide for them And only I as a creator can view and edit data in column D

I’m working on an app that will have a free tier and a paid tier, and I’d like to add a button to let users sign up to a paid tier from inside the app. What are the general guidelines regarding building sign up and payment features into AirTable apps?

When I create new records and pull in information into my fields, I make individual changes on the fields, however the records are linking with previous records, I selected unlink and it doesnt seem to help

I need to import data from a .bentodb file. How can I do it?

Is there any way to set up any sort of vertical stacking within a kanban view? e.g. to categorize Project Status columns by Users or by Sub-status? I’ve seen this set up in other project management software and it would be incredibly helpful for workflows if I could set this up for my team.

I have an inventory base that I am creating with multiple tables for a hotel. Tables are as follows: Inventory Table with linked fields for “Measurement” Table & “Department” Table. We would like to limit record selection in the Measurement linked record field based on which Department has been selected in its linked record field. For example: Maintenance department has the ability to select Feet, Inches, Pound, ect. as a selection of measurement when adding a new item to their inventory While Food & Beverage department would only see Gallons, ounces, pounds, ect. Limiting record selection by a view solves the problem if I only had one department but in our case we have 9 departments to plan for. I would greatly appreciate anyones suggestion on how to handle this situation.

Hello guys, I have a workspace shared with 10 collaborators (all of them with the same permissions as Creators), in it they have created 15 bases. Is it possible to know which collaborator worked on a specific base? Thank you.

Hello everybody, I was wondering if anybody knew how to build a wordcloud based on long text responses to a survey that appear in Grid View? I have various Views from a growing dataset and code the responses under a “Multiple Select” field to generate a Chart in my dashboard. However, it would be great to have a wordcloud generated within a dashboard from another long text field as the data is too broad to code into clean categories? I saw a conversation here from 18 months ago and wondered if there was any newer ways of doing so? Thank you in advance!

We are using AT to track student information across the multiple courses we offer. Each course or set of courses(up to 6) has a different facilitator. We simply want the facilitator to see all the students enrolled in their courses or courses and then input one piece of information in a field from a dropdown: complete, incomplete, NA. It seems Forms would be overkill for this and we would have to prefill too many other fields. What might be a better solution? We don’t want to give them edit rights for their view unless we can lock the other fields like the student names, email, etc. Thank you for any help!

Hi All! So here is what I’d like to do. I have a base with four tables. All look precisely the same in terms of fields (types and names). For your understanding, the first three tables are lists with data about particular individuals. And the last table includes all individuals. My goal is to create a field on the fourth table that will let me know by the person’s “Name” (which is the first field) in which table he/she is located. But, some of the records repeat themselves in different tables, so I’d also like to know if the record is in “table1” and “table 2”. Thanks In Advance, -Bar.

Hi Guys, I’m wondering if anyone has had much success syncing with Primavera P6? I’m particularly keen to know if its possible to to create Projects & Activities in P6 from records in Airtable. Any info is much appreciated. Kind regards

I know this question was asked here earlier and yes I can use browser spellcheck. It was asked here… Add Spell Checking to Desktop App Product Suggestions The Airtable Electron app—like many others, but not all (see Slite’s app)—lacks support for checking spelling errors as you type. Look, I’m gunna level with you… I suck at spelling. But, I’d rather not have everyone else know it. If you could add spell check support you’d be doing me a solid. Thanks! and here… Spell Checking within Fields Product Suggestions Would it be feasible to have optional spell checking for fields? This needs to be optional to allow for columns which would regularly have values which would not pass a check. and here about Grammaly… Grammarly doesn't work Ask the community As I mentioned before, I only saw it appear right away on one site that I use (Evernote), with nothing showing up here. After seeing the green

I didn’t receive the upgraded version even though I paid. I have had money deducted from my bank account and have transaction information