Other Questions

Hi, I want to write a formula that will return ‘Yes’ if a record has been modified before a specific time of day. I have my team ticking a checkbox, which if checked before a certain time will mean a yes result. If the tick box is ticked after that time the result is no. I’m using the ‘last modified time’ field type as the time stamp to use in the formula I tried Is_Before with TimeSTR but not sure about how to specify the deadline time. Any thoughts?

Hi! I’m trying to figure out how to get the gantt view to display a background grid of column & rows so it’s easier to read quickly. Is there an option somewhere for that? Just a plain ol’ outlined set of cells, basically. Thanks!

Hello!! Is there versioning for the sheet/table you made in Airtable? if so How to do versioning for the sheet you made in Airtable? your cooperation in this question is greatly appreciated. Thank you Ahlam

I have a simple table with Attendance columns by date. 5/21 5/22 etc. I have secondary grid that limits the view 1 date at a time. My goal is to have a student take attendance at the door on an ipad. However, when I test, when ever I try to click on the check box for marking present, it opens the entire record and the recorder has to scroll to find the current date. It is not hiding the fields I don’t want them to see. What are my options. This works perfectly on the Desktop, but need this to be portable. EDIT: Upon research, it looks like hiding in the expanded view isn’t possible on the app. SO…What about not opening the record and just editing in Grid view on the app?

When i disable “Allow viewers to copy the data in this base” or “Allow viewers to copy data out of this view” and try to copy the data. If I copy a batch of cells i receive “Sorry, the table’s owner has disabled copying” but if it is still possible to copy one individual cell. Is there anyway to disable copying one individual cell?

I’m using BravoStudio (a No Code tool) to design an App. Random content can be obtained by clicking. I use Airtable as a container for random content, but I am currently stuck at this step: I don’t know how to get random records. What is the solution? I tried to use a third party such as Integration, but I didn’t know how to do it. Can I write an App script to achieve it? Who will teach me… :cry: :sob: :cry: :sob:

Is it possible to log/record the active filters for a given view of one base to a separate base? Essentially I want to create a log that captures the filters/queries used for the saved views.

Is there a template for organizing photographs? I have thousands of digitized photographs and would like to organize them.

There are two linked tables: Posts (ie. an index of blog posts, with dates) Companies (a list of companies who author blog posts) Companies already has a Count field column to display the total Posts by given Company. However, I’d like also to count the posts by Company within the last seven days. One view of Posts is filtered to show records with dates within the last week. But how do I utilise this or similar on the Companies table? Thanks.

Hey all ATers. I was wondering if there is currently an “alert”/email, etc that is sent to the main creator whenever an editor or less does something in one of the workspaces, bases, tables etc? I’m the Admin/Creator and need to be made aware of any changes, deletions etc. that are made so that I can check them immediately. Does AT do that? Thanks!

Good day again ATers! Quick question on AT rights. Is there a way to set various users beyond the “creator, editor, etc” to only allow them to edit certain fields? I have a set of teams, including my own internally, that will be working in various tables, and instead of creating duplicate views for each user, is there a way to just give each a different access/lockdown? For example, All users need access to the full “course” table, Each user needs to be able to create, edit(but not delete) a course, they can leave memos in the expanded field if they need that. Each user can only edit THEIR courses, not others(if this isn’t possible, that’s fine). So basically, needing to limit user access to not screw up the huge database :). I think that’s it :). Any suggestions, comments, ideas? Thanks!

I have spent hours and hours on this thing. I am not able to copy paste the records to new table ( it has the same structure ) It doesn’t show the option of Dialog box of Expand cells etc. Please help.

Hi, I discover Airtable, it’s a very good tool I’m trying to make a summary that summarizes the number of rows in my tables on a table dedicated to that Could someone help me on how to do this? Thank you

Hi there. I am currently a admin for an alumni organization. I use the Airtable to manage member database, and trying to find out how I can use this member data to automatically sync to a list or table on a website using wordpress. Before Airtable, I was using excel to manage member data, and had to update the website (member introduction list) manually using wordpress. I was hoping by using Airtable, I would not have to update the website manually, but instead focus on maintaining Airtable so it will automatically update the web at the same time.

Hi everyone, I am trying to get my head around how to structure an inventory location app. I see there is one that I can clone which is great but the secondary level of complexity is that we track multiple locations in the warehouse. This template has the ability to track multiple locations but not multiple quantities in multiple locations. As you can see in the screenshot below I have added 3 locations for the first product but I need to work out how to structure a quantity for each location. Here is the Locations image below, so how can I add a qty for each location? Thanks so much for your help folks in advance.

I would love to use airtable i think it is a fantastic product :relaxed: :relaxed: however i live in Skandinavia and apps created with it Just seem a bit slow to load. Are you guys considering serving airtable from other places than the States?

My team would like to build a simple Employees base, that mirrors our company’s Active Directory. Has anyone had success in either syncing the two, or scheduling a CSV export from AD that can then be imported into AT? Open to any/all solves! THANX.

Hello! I’m setting up a form where respondents would include their email address. I’d like to set up an automation that would use that email address to select a linked field based on the email addresses matching. Possible? Thanks!

Hi, I sync my google calendar with my Airtable, everything works fine so far. the only thing I couldn’t figure out is, how do I filter or set to pull only the events that I mark as ‘yes’ to the invitations. In airtable it shows all the calendar events even the ones that I’ll not attend. I’d appreciate if I can get some help with that. thanks in advance! Baran

So when I create an Attachment Field Type, I can add various attachments and I can access One Drive to upload documents BUTI cannot access my Business Account…only my personal One Drive. The Air Table system is pointing to live.com for the upload and not microsoftonlinecom. When it points to live.com, it asks for a login and passcode but will NOT allow me to use my Work Account. If Air Table could use the microsoftonline.com as the link into One Drive then I can select to use my Work or my Personal One Drive as the source. Please, can this be done Air Table ?

Hi all, Just wondering if anyone had any suggestions as to how best to set up the following workflow. We are wanting to bring in info (sender, date, subject and main body message) from emails received (across a number of different email accounts). Once the above info has found its way into Airtable we are then wanting to send information from these new records to 3rd party email address or phone numbers. Not really sure where/how best to start tackling this so any advice/guidance would be appreciated. Cheers

Hi, I’m wondering if the following situation is a bug or not. Currently, when we create a linked record field, the “card” that is shown once a record was actually linked, shows the fields in an order that belongs to the very first view that linked record’s table belong to. What I found, is that when you configure the linked record field, to be limited to a particular view, then the fields arrangement from such view is not used to render the “card”. Is this correct? Thanks

I am trying to push content + an image from Airtable through Zapier and schedule a post in Hootsuite. The issue I am running into is that in Zapier, it’s asking for a media URL for my video or image. But my image in Airtable is a jpeg. Do I have to convert my image to a URL in order for this integration to work? Thank you in advance for your help -Newbie Airtabler

Hello! I’ve created a gallery that I’d like to embed on my client’s website, but there are a few issues: The title of each record is cut off in the preview of the gallery cards. Upon clicking the cards to get the expanded view, the title shows up twice: once large (which is nice) at the top of the expanded view, and then again below that as a field. The gallery of course uses associated images as the “cover field,” and I did not click “image” in the customized list of fields to include on the cards, yet the images show up at the bottom of the expanded view — oddly, under a banner that announces “1 hidden field” (so why show them, if they’re supposed to be hidden???) I wish I could customize different fields to show between the preview and the expanded view, but I’ve read elsewhere this is not possible. I’m just mentioning it here in case there’s a solution I missed in my search of the forum this morning. Any solutions here, either native to Airtable or through 3rd party apps?

Hi! Here is my set up for importing Jira Due dates into my airtable. What am I doing wrong? Jira Due Date Chooser: Is it Formatted Wrong? Airtable Column Jira Mapping