Other Questions

I want to import a JSON dataset. I know I can’t import JSON, but I know I can convert the JSON first to CSV, which is importable. The problem with that is my dataset contains arrays inside the JSON object, eg.: "variations": [ 227, 329, 229, 190, 119, 123, 152, 155 ] In a JSON-to-CSV convertor, this comes out as multiple columns, variations/1, variations/2, variations/3 etc That is not appropriate since, in Airtable, I want the “variations” field to be a Multi-select. How can I accomplish this?

I want to allow members of the team to create custom views via a lookup form (without going into the base). For example, see all records that match a given criteria (type: flower, color:red). Is there a way to do this without pre-creating a view? example: on a form, user enters type:flower, color:red. It returns a view/table with: record1 - rose record2 - tulip miniextensions has a search page that does what I am looking for, I assume this is a form on their site that then uses the API to retrieve info from the base, correct?

Hi, all I need to define the formula for calculation employees` vacation days in total, not within one leave year. How it can be done? Is there a possibility to do the calculation without leave years at all?

I see a form view to collect data from users. I see a few form-oriented addons, but they are for printing forms. Is there a way to create a form-oriented view of a table where users can update the table and add rows?

Hello! I have a long text field with information captured as rich text: Achievement 1 Achievement 2 Achievement 3 I need these Achievements converted to a comma separated text field. How do I get the above, converted to the below?: Achievement 1, Achievement 2, Achievement 3 Appreciate any guidance!!!

Hello, I am trying to create a database using the barcode field. However, the barcodes that I have generated (type code 128) are not read by my phone camera, whereas a barcode scanner on my phone can read them perfectly. Can you please advise on how solve the issue? Thanks a lot, Marziye.

I’m reminding my team of tasks weekly, using a digest. Some weeks there are 0 tasks (although rare). If this happens, the run is considered a failure, and I’m sent a report about it. If there are no records to be found , I don’t want a digest to be sent. So in reality I don’t consider it a failure. Is there any way to adapt the automation to this? Or do I need to await a potential if/then feature?

I want to build a custom CRM for my inside sale team and other teams. I have a Master base that has all the leads data also that’s where we want to assign who will take care of these leads. After we assign a lead, our Sale Agent will see new lead appear inside of their own Sub-CRM. We could do that with Filter and Importrange in Google Sheet. Could we do the same here in Air Table?

Hello ! I’m :fr: and totally new there and with this extraordinary tool. I wanna use airtable for a social media calendar. A database where I can write FB, IG and LK posts, plan on a calendar and reports the results. I have 2 tables : 1) “contenu/posts” where I write the post, update status and decide which day we will post it 2)“évènements” (events in french) where I add differents events as christmas, mother day, mondial days… I would love to see the events that I added in the table “evenements” in the calendar view of the table “contenu/posts” like that Do you know a way to do th

Just wanna ask if this is possible… i’ve spent way too much time looking for a solution to what I want to happen already. So I have a column in table B called “version”… I want the color for each cell to change according to the cell value from table A that has all the latest product’s latest versions. Green if the version from both tables match, and red if they don’t match. That’s basically it. I can’t find a way to reference a record in the conditional coloring box.

Hi! Is there a metod to copy or move a record frome BASE 1 to BASE 2? Not between two table of the same base but between two differents table. Thanks

Hi Everyone, I have an automation that is triggered from a schedule, finds records in a view and then needs to email address using one of the values found in the view. The problem is that the email address in the view may appear many times (Multiple rows) so that using that field in the automation will mean the TO: filed looks like this: user1@test.com, user2@test.com, user1@test.com, user2@test.com This means they get the email multiple times. How can I get the unique values from the rows and use that for the sending on emails? Cheers

Im making a airtable system, for a friend of mine. It deals with quite sensitive data… Is there a way to make sure an editor can’t just duplicate a whole his base including all records into their own workspace, but still be able to edit records?

Hello, I am importing an Authors AirTable base table into Webflow. The name field is the primary field and it is a single line text. Why is it importing into Webflow as the slug, lower case and dashed? Any help would be much appreciated. I tried changing the field to long text and it did the same thing. The fields are mapped name to name and slug to slug. Thank you

Howdy folks. I have a table I’ve pasted some data into. One of the fields is certainly text, but if I reference it with T(), it says it is not. If I select the cell, there are no other characters hidden or otherwise. If I delete the contents with backspace and retype exactly, it is magically text. Any thoughts?

I need to upgrade one of my workspaces to a Premium plan and I understand that I get charged per collaborator (I have 4)- so I’ll pay X amount today. In the near future, I’ll need to add more contributors to that workspace- how does that then work/ will I have to additionally pay a fee per new collabroator?

Hi I’ve found a previous post which was answered by @Justin_Barrett about searching for Airtable rows based on the scheduled date and time. Thank you so much for that, that helped me out a great deal…however I need to get it to around 15 minutes and I can’t work it out. I used your formula but added H:mm to give me the minutes and hours DATETIME_FORMAT(Scheduled, “D/MM/YYYY H:mm”) = “{{formatDate(now; “D/MM/YYYY H:mm”)}}” I was hoping I could schedule a post for the that exact date and time and show the contents but it won’t. Once I had that working, my plan was to get the ‘now’ (date and time) from Integromat and add 15 minutes so it would check the rows for any thing scheduled for the next 15 minutes before Integromat makes the next check in 15 minutes time DATETIME_FORMAT(Scheduled, “D/MM/YYYY H:mm”) = “{{formatDate(now + addMinutes(; 15); “D/MM/YYYY H:mm”)}}” I ful

Hi! Thanks for software As title Steps to reproduce issue Open “Find in Page/View” (keyboard cmd + f) Enter query Navigate through found queries (keyboard enter or UI arrows) Close find tool (keyboard esc) Unexpected behaviour After finding the query or navigating to the cell I want I may leave the find tool open while navigate my view. Then later, when I decide to close the find tool, my view jumps to the last found query/cell - why?! Expected behaviour Simply close the find tool, don’t mess with my view – Tested in multiple browsers - same behaviour FYI

I previously used the Gantt app within a dashboard. The app allowed the user to click into a record on the Gantt app and edit the record. The user could also drag the bar on the app interface to set dates or duration for the record. After the Gantt app was changed to a view, we could no longer use the Gantt app. Instead we used the Embed app to make a Gantt view visible within a Dashboard. This works reasonable well with one exception. The user can click on the record and view the contents, just that no-one can edit the record nor drag the bar to change the dates. Is there a work around to make embedded view behave like the older Gantt app?

Hi folks! The team has really enjoyed seeing how you all have been using the web clipper block + extension, and we’ve appreciated reading your feedback over the past few months. With your feedback in mind, today, we shipped a couple of improvements to the web clipper block that should make it even more useful: Linked record fields are now supported, allowing you to select an existing linked record when clipping from a web page. You can now set a specific select option as the default value for single and multiple select fields. Collaborator fields now support clip action user as a default value. (That means that when you use the browser extension to clip from a web page, the designated collaborator field will automatically fill with your name.) Now, in addition to using CSS selectors to capture default valu

Hi all Is anyone using Integromat and uploading images from Airtable to Facebook? I can’t seem to upload a single image other than using the option ‘download photo from URL’. If I select upload a photo it just won’t work. Now ‘download photo from url’ is ok for a single image but it doesn’t seem to work for multiple images or at least I can’t work it out.

Is there any way to show if a record has a certain field already present in another record in the view/table? For example show that the Airtable link is present 2 times Thx

I have a time where an event starts and I want to set a tweet for each event 24 and 12 hours prior. Problem is when I use a formula for the Date -1 it gives me the right date but the time defaults to 12am and if I switch to not same timezone for all it moves it to the day before. Either way I want to be able to say event is 7/1/2021 at 10pm gmt. and I need a cell to tell me the time for the 12 hour or 24 hour tweet so I can run a NOW calc against it in the view to trigger the tweet.

I have a Automatoin to send Slack message. But, in some conditional(like last step’s output put a null value for “Send a Slack message Action”), I will not send the message? How can i do?

I’m new to Airtable (and totally obsessed) and I know enough to be dangerous. I’m certain there is an automated/quick way to rollup data from another table based on the criteria in one field… but I can.not.figure.it.out. Table one has financial data with one record for each week. I have a Date field for “Week Ending,” and formula fields for Quarter and Year. In Table Two, I want to have one record per Quarter with a Rollup/Count or something showing my totals from a field which I could then use for further formula fields. I’ve got something kind of working (see pic) but surely there’s a better way! Help!