Other Questions

Is there a way to write a formula that inserts the date when a change is made to a record? I would like to automatically show the date when I change a single select item from one selection to another. (I am changing from “in progress” to “closed” and I’d like to see the date I closed the record without having to remember to add that in a separate field).

I have a base that I’m using to track contractors, the projects they are working on, & all of the tickets they submit for payment. I have the project, contractor, and invoice tables all linked and that seems to be working fine. Each contractor will have multiple tickets per day that will be combined to generate one invoice at the end of the week. Would it be better for me to add a field for tickets and link it somehow or add a table for ticket information and then link that however?

Hi In Israel the week starts in Sunday. Is there a way to change the calendar view accordingly?

How can I capture selected text using CSS selectors. The use case is that I want to capture some interesting lines/quotes from articles that I am reading. I tried using the ::selection however it does not seem to work. I am selecting the text manually myself so, it’s not that difficult to make a copy and do a paste after opening the extension. But having the selection populate automatically would be cool.

I’m wondering if anyone knows of a way to link information in an Airtable base to a clickable festival map? I help coordinate a fairly large science festival with several exhibitors, performers, and activities. We are hosting a virtual event this fall and would like to crate a “map” where people could click on a square/circle/whatever on the map, to lead them back to an Airtable base. Would the 3D block work or one of the integrations? Thanks in advance for any ideas/help you can offer!

I struggled with the title of this, so some clarification: We are an animal shelter that has switched from in-person applicant processing to entirely digital applicant processing for people interested in adopting animals from our care (due to COVID). We just started using AirTable for this purpose, and have a table filled with records of Applicants (that automatically creates a record upon a Google Form submission [Zapier integration]). We have another table filled with records of Animals in our care. Basically, we are placing people in virtual “lines” for specific animals they are interested in. Right now, we link these two types of records with three separate fields labeled First In-Line, Second In-Line, and Wait List. Example: If Dave wants Bella, and no one else is in line for Bella, Dave’s record is assigned “First In-Line” to Bella’s record. Then, if Jeff submits an application for Bella, and Dave is still first, Jeff’s record is assigned “Second In-Line” to Bella’s record. If Ca

Hi. I’m looking to replace Trello with Airtable, but I’m struggling with Link (URL) attachments. Firstly, I cannot drag web pages onto a card to create a link attachment, like I can in Trello. Secondly, and most importantly, when I create link attachments manually, there’s no way to follow the link. Clicking on the attachment just attempts to preview the link. There’s no option to follow the link from the preview either. What am I doing wrong?

Hi everyone, does anyone know how to prevent other collaborators from seeing certain records on a table that we share?

I am looking for a developer to help build out an Airtable environment to use to manage our small group initiative at a synagogue. Key functions: Sign up/Request groups that have limited numbers of participants in each (or perphaps ranking choices and then assigning to the group) Assign people to small groups Allow group leaders to see who is in their group to communicate, track attendance, etc. Can you help?

Hello… I’m new to airtable. I have an app that’s synching my shopify inventory with airtable. I have exactly 50,000 products currently so I bought the pro plan allowing 50,000 records per base. However, it has stopped at 24,031. I was on the free promo plan so moved forward and entered my card for billing. But its still locked. Then I checked usage, and it shows me at 48,178 records. But my table only shows 24,031. Can someone enlighten me on what I’m missing and how to correct it? Thanks in advance for any insight. Dave

I’m noticing a blue line that appears next to the row number in certain grid views. Can anyone explain what this means?

Hi! I am interested in feedback on how to achieve this use-case. People (Clients, with relationship fields like “Executive” or “Administrator”) Subsidiaries Parent Accounts Subsidiaries are linked to Parent Accounts. People are currently linked to Subsidiaries. For People records, a Lookup field automatically populates the Parent Account based on link between Parent Account and Subsidiary. Goal: I would like to be able to see a list of all my “Executive” People that roll up to a Parent Account. (I could manually link People to Parent Accounts, but it seems redundant since we already have them linked to the Subsidiary). Thank you in advance for your feedback!

I’m trying to attach files from gmails into a base. This support page: Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. Suggests it’s built in but for the life of me I can;t find his function. Every search points to zapier which no longer works as google switched off it’s google/airtable/zapier integration. Any ideas where this built in function is configured? Cheers and thx in advance Neil

Hi. I want to develop a Zap that will update me on a user progress based on their username. I have a table that tells me which user belongs to which group by name, and I have a table of info for each group. What I would like to do is search (in Zapier or Airtable) for the relevant table based on the user’s username and then update the record. Is there a way for me to do so? Or should I create a dedicated zap for each case? Thanks.

In my first table, I have Projects: A, B, C. They are single select tagged as Locations 1, 2, 3. They are tagged with Persons (a Linked Table). In my second (Linked) table, Persons. All the Projects are automatically combined into one column. Users will input data in the first table. In the second table, I need each Location to be a column header, so that each Project is parsed across those location columns. In short, I need the tags in the first table to be the column headers in the second table. Help would be appreciated!

I currently accept user submissions via a form into an Airtable base. I collect name (fname, lname), email, and Twitter profile and although I’ve created a view with just this data, I think it’d be useful to have a table of “People”. Is there a way to do this automatically? Is this advisable? Ultimately I would like to use these inbound submissions to populate a kind of basic CRM, and having a People table seems like it’d be useful to have as I build out my base.

Hello, If record is added under a given column, can it be automatically tagged? For example, If I add a “John” under a column titled “Founder” for the “Companies” table, can John be automatically tagged as a “Founder” under the “People” table (to which the “Companies” table is linked)? Thanks :slightly_smiling_face:

Airtable Time Zones: Working with multiple different time zones in Airtable - Airtable... This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in... I’ve created a sample base & accompanying training video to solve the dilemma of working with multiple different time zones in Airtable. This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in their own local time zone. My sample base gives a properly-converted local time for any event — based on the event’s original date, time, and time zone. This base could also be adapted to solve the problem of managing ANY resources that involve multiple time zones: employees, tracking packages, project deadlines, etc. This solution is based on these 2 goals: Each event uses its own local t

Is there a way to label unread items in Calendar view? Our planner is populated by a form and it’d be great to have a way to star or colour new items submitted by others outside of our team that haven’t yet been expanded. We’ve just started using Airtable a couple of days ago and so far it’s great. Appreciate any help you can give us :winking_face:

Can a form designed in Blocks be saved in Word? I find it difficult to work within the Blocks template and would like to import or export the document and then work with it in another program. Thanks!

I am wondering, if it is possible to create a form, where the fields are located in a 2nd or 3rd column? Instead of Firstname Lastname Birthday City Country I am looking for Firstname Lastname Birthday City Country

When I share my Form with people, I do NOT want them to see “airtable” in the URL. So, if I embed the Form into my website, will users still see “airtable” in the URL? Or will they only see my company name in the URL? Thanks for any help you can provide!

Hi! I am trying to do a summary table of the daily logs I have in another one. By week, I could potentially link to, and then select the 7 days I need to (see image), but it would become very burdensome for monthly, quarterly and yearly overviews. I am already using the group by week and other views, but I would need another table to add custom notes to the week without making the daily log rows dirty. I am sure there is a quicker way, but not sure where to take it from. Thanks a lot in advance!

Hey there, Wondering if you all can help me with a Timezone issue I’m having that’s driving me nuts! I think it’s to do with GMT/BST but I would like any help in solving this because I can’t get it right. Trying to pair a Mentee and Mentor with each other, and they will live in different timezones, I can get the calendar invites to work, as it’s all based off nice and simple ISO time, but I can’t for the life of me get the timezone conversion to work in Airtable for local time (which I need for numerous other reasons related to communication) I’m using this formula to convert the time as follows: IF({Event Date + Start time}, DATETIME_FORMAT(SET_TIMEZONE(DATETIME_PARSE({Event Date + Start time}), {Mentor Timezone}), 'MM/DD/YYYY h:mm'),"") However, I’m getting a delta across Mentee and Mentor, as shown below in both tables: Can one of you kind folk help me work out what’s going on? Mentor View Mentee View As you can see, there are 6 columns in each, and the problem is that the Actual

We have an event table that keeps track of our client’s events around the globe. Each event takes place in a different time zone. But Airtable doesn’t allow us to attach a time zone to a date/time field. We need to view this time in 2 different ways: The “local time” of the event. This time should always remain the same in the system, since it is the “local time” of the event. The “translated time” to each user’s time zone when each user logs into the system, so they know what time the event takes place in their own time zone. How can we successfully use Airtable to accomplish this? Is this even possible in Airtable?