Other Questions

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

We own a company where we have a Done for you team member placement service and we want to track if they have filled in their End of the Day report every day. Right now I have: 1 sheet where we collect our team members names 1 sheet where we collect the EOD reports I would love to automate the manual work of finding out who DIDN’T filled in the EOD report by the end of the day (11:45PM) so I can follow up with them the day afterwards. I tried the automation, but I get a bit stuck here. Can someone help? :slightly_smiling_face:

Hello team. Once upon a time, I stumbled onto a report that shows me every shared view my base or table was using. I am looking for that type of report or list in my account dashboard, and in the specific base that I am trying to pull that list from. Any idea if there is something simple that displays this type of information? Thanks.

So I have a base with 2 tables - one containing the funding round details (FRD) which includes name of Startup, amount and investor And another table solely for investors - which I wish to import data from Investors column in FRD table. Now, the investor in FRD is input as a long text which is comma separated. I wanted the Investor table to automatically import this data from investor column - and import it into separate rows - with startup name on the side. I know something like linked record exists, but even there I have to manually select the investor - whereas I simply copy and paste data from the net, thats why I want the investor column data to automatically be imported in the other table. How can I make it happen? Sharing link for sample base for your reference, please guide. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious out

We have Enterprise account and I’m trying to do date ranges in Calendar/grid views - is that possible in Enterprise or only in Pro? I would think Enterprise account has all the features that Pro has, right?? Thanks!

I’m creating a field (with createFieldAsync) but it is defaulting to hidden. Does anyone know how to change that? Thanks.