Other Questions

I have a field that is in the first position and I wish to move it so it is in the 5th position from the left. Airtable is not letting move it as it may be a key. Is it possible to do this?

Hi Guys! I have a record in airtable with 1 image and another record with 3 images: I have a Zap(Zapier) that allows me to send a 1 unique image to a Basecamp To-Do as follows (for example to the field 2): And I get the desired result. But, in the case of the field 2, when I have several images, I can’t visualize them. So I want to know how I should modify the HTML code that I am using in the Description to be able to display the images correctly when there are several. Anyone know any way to do this? Thank you!

Hi Airtable community! I’m new here and am building out a budget table for work. I’m trying to create an automation that updates an entry to say a certain month in a field when the date in the field next to it is within that month. For example, if money was spent on a “photographer” on 1/15/22, we will enter the exact date in one field (with a date field type) and then I want the field next to it to automatically change to “January” (with a multiple select field type). Can someone help me figure out how to automate this?

Is there any way to prevent from creating an identical record?

Hello there, I’m looking for a bit of feedback on sorting rows / row order in timeline view. Right now my workaround for ensuring that I have the proper sorting is to append numbering to the ‘name’ data as shown in the attached picture. The data is grouped by name. So far, this works OK as it allows me to manually sort so that the swimlanes with data extending furthest forward in time are towards the bottom of the view. If there’s a better way to do this, I’d be glad to hear it. I did experiment with splitting out the ‘ranking’ data into its own column and grouping by this column, which does provide a similar view, except with a bit more white space on screen due to the grouping. Thanks for any feedback. Ps apologies for putting in Calendar view, there is no option for timeline view when creating the post in this section.

Hi, I’ve got a bit of a weird one that I am not entirely sure if it’s an issue of my database design or can be solved another way. I have two bases for a webstore, one which holds high level information (items for sale, vendors, master order records) and the other base has individual records for each unique item in each master order record. Excuse the awful drawing and writing, but the below diagram illustrates how I’ve structured things so far. Black lines with two arrows show linked fields. One arrow shows synced tables, and the blue line shows what I want to achieve. The end result I am aiming for is to be able to report on sales associated with each vendor (i.e. Vendor A has sold $500 of items this month). The problem I have is what seems like it would be the logical link of pulling the vendor detail in via the item doesn’t allow me to then total up based on the Vendor anywhere. I could add in a second link field, to directly connect line items and vendors, but then I’d need to im

I’m experiencing a strange issue when I use a date in a formula (yes, I’m using timezones). If I include the time field in the date, then it displays correctly in the formula, but if I do not include time, then the formula displays the date minus 1. I do not want time because this is an invoice date. Halp.

We have switched our airtable to a pro plan and would like to use it instead of the 14-day free pro trial because it has scripting in automation and we need it urgently. Please Help

How can I do so that it can track with clockify, try this guide but the button does not appear Airtable Time Tracking Integration - Clockify

The Vega-Lite app never gets past “Loading…” - no JSON. Any idea how to get this app operational? per the readme, I suppose I can try creating a new app with the SDK per the Vega-Lite github readme, but this seem rather obtuse :face_with_diagonal_mouth: Anyone know what’s wrong with the app, how to resolve or troubleshoot? Thanks!

I am relatively new to Airtable, former Filemaker user. I am trying to figure out how to replicate something I could easily do in Filemaker. I have a base. Each record is a school volunteer who answered a volunteer survey in Google Forms, which I then imported into Airtable. In it I asked them a number of checkboxable questions: What times would you be available to volunteer? Which jobs would you be interested in? Which committees would you like to join? Etc. I want to create a view where I can see an “index card” for each user, and it shows me what times they are available and what they are interested in. In Filemaker, I’d just create a new view, change that field to checkboxes, and be done. I don’t see an easy way to do this in AirTable, but there must be. What am I missing?

Is there a way to automatically reduce or limit the size of images that users upload to Airtable?

I am trying to open an app in the pc using the url generated from automation, which is working fine, but need to copy a field from the table before i paste this copied content into the opened app to print a label. I am not able to automatically copy a cell and keep in memory neither using functions nor automation. Any suggestions are highly welcome! Thanks in advance.

When you sync a table that has a Linked Record. It comes out as a CSV on the synced table. Is it possible to create an automation update a linked record with the CSV information that’s linked.

I have the Airtable Pro Plan and have two timeline views in my base that I can access on my desktop, however when I try to view my timelines in the Airtable app on my iPad a notification pops up that says that the view cannot be displayed in the iOS app yet. Is it possible to view it somehow? Thank you.

Hi all. I am new to Airtable. I would like to create tasks list for my team members. Each team member can only create, edit and delete ONLY their own tasks list, and there will be a master list of all tasks list. What is the best way to approach this? Because from my understanding I can only create permission for Workspace and Base. How about permission for certain tables? Thinking of to combine two tables (each table one team member’s tasks list).

I am trying to set up a reminder to do something on the first day of the second quarter after an event. So, for example, said event happens on February 6 (or January 27, or March 30, etc.), the reminder triggers on July 1. Likewise, if said event happens on October 20, the reminder triggers on April 1. I’m familiar with switch statements, but there has to be an easier way than writing out a switch for every day in a year (plus I also need to repeat the reminder for the third and fourth quarters, so that would be 3 times!) Hope that makes sense. Thanks!

I was wondering if it is possible to export a specific view from a tab in Airtable as CSV directly from the scripting block. I’m a little bit rusty with JS and have been trying to import stuff and I learnt that AirTable doesn’t allow any imports. Could anyone give me some directions on how to transform a view into CSV and authenticate unto my S3 Bucket? I’ve seen multiple threads related to this, but was wondering if there were a modern solution.

Since the native functionality of building reports and dashboards is very limited in Airtable what is your favourite external tool for this?

Hi Folks, Is there a way to create a field that lists all the records the link to that record? In Salesforce this would be easy, its part of the parent-child relationship and a related list. I’m having trouble wraping my head around what the corollary to that would be in airtable.

Hi, I’m new with Airtable and I’m wondering if it’s possible to see and customize the Airtable Search App? I’d like to see the inside of that script/app so I could get a more “complex” exemple and I’d like to add the possibility for a user to add more than one value to search and get a list of records. Regards

Hi all, I have two formula columns, both pointing at one date field (“Date”). The formulas in the two fields are: DATETIME_FORMAT(Date,‘W’) and WEEKNUM(Date) For some reason, the week number in the WEEKNUM column is always 1 more than in the DATETIME column. So if the DATETIME column translates the week as 11, the WEEKNUM column translates it as 12 and so on. Does anyone know why the week numbers are not lining up?

I am trying to get a formula to display the time of a date field, in 12 hour format. Example: I have a date field set to 03/18/2022 6:00pm. I have a formula that is pulling just the time of that field : TIMESTR({Start}). This produces 18:00:00. But I’d love to get this in a simple: 6:00pm, or even 6:00. I tried this wild formula, but that produces an error: DATETIME_FORMAT(TIMESTR({Start}),"hh:mm"). I’ve also looked around at some of the other solutions, but most require 2-3+ fields to get the number. Is there a simpler, “all-in-one-step” formula to achieve this?

Hi Guys, I had a field that is text file but is format as 1,1,4,2,10,1,4 from Zapier data and what I want is the format them as a total of 1+1+4+2+10+1+4= 22 Is this possible in the formula? like total the number?

Dear community, can two unrelated conditions live in the same formula? Do they need to connected by the same first argument? I want "Sample Availability to read “Shop only” when there is no value in “SignOutIcon” In writing it would be: If SignOutIcon contains no value, return “Shop only”. If SignOutDate contains a value and ReturnDate contains no value, return “not in stock”, otherwise “available” With first argument the same, it would be If SignOutIcon contains no value, return “Shop only”. If SignOutIcon contains a value and SignOutDate contains a value and ReturnDate contains no value, return “not in stock”, otherwise “available” I used “&” but this returned a mess: IF(AND({SignOutDate},NOT({SignOutComment})),“not in stock”,“available”) & IF(NOT({SignOutIcon}), “Shop only”, “available”) Could anyone give me a hint? Any help highly appreciated. Best, Sisi