Other Questions

Hello, we have some inspectors out in the field and have recently upgraded their tablets and phones. Previously (on their older devices) the images they would upload were 1mb or less, wouldn’t take long to upload and wouldn’t use too much data. Now that we have upgraded (ipad mini’s and galaxy s10 for example) the photos are generally 5mb+ causing longer upload times and using all the data very quickly. Does anyone have ideas about how to make the photo quality lower? We don’t need high resolution photos. We have tried adjusting the resolution in the camera apps but they don’t go anywhere as small as the previous devices. I know there are ways to reduce the image size/quality after the photo is taken with other apps etc but that’s not really practical if they are taking 10-20 photos an hour and need to line the photos up with some other data when inputting into airtable. thank you in advance for any ideas.

I want to connect basic pageviews/unique pageviews from GA to our AirTable Editorial Calendar. The edit calendar has full URLs https://www.oursite.com/path. GA, of course, only has /path. How can I automate matching these records? Is there a way to bulk edit all URLs to insert or delete https://www.oursite.com? Something easier?

Hi - is it possible to color multiple columns using the conditional logic? For instance, we have 8 columns: Budget 1 Spend 1 Difference 1 Budget 2 Spend 2 Difference 2 When setting up the conditional logic, we’d love to be able to say “if the difference is less than x, make the field green.” If isn’t possible, are there any workarounds that you would suggest? Thank you!

I share different data with outside organizations. Should I setup a Base for each organization? If so, how would I track activity globally among all of the organizations in the same workspace?

I created a base for artists, all of whom will have multiple pieces of art listed. Each piece has an (attachment) image field, and 3 other text fields: price, dimensions, and medium associated with it. I need to link those fields (columns) together, but unique to each artist (listed in rows). (Otherwise, we won’t be able to match up the details to the art image, if not linked together). How do I do this?

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!