Other Questions

Hello all, great to be on here, am loving the power of Airtable!! Is there a way to do the following : In a table, I have a “Single Select” Field with 5 Options, “Pitch 1” “Pitch 2” “Pitch 3” “Pitch 4” “Pitch 5” If I create a new record, the first field is a Date field, so I select a day, eg 11/01/2020 I then want to assign a “Pitch” from the “Single Select Field”, initially all 5 pitches are available to choose from. I select “Pitch 1” for this record. Record Complete. If I then create another record with the same date, there should now only be Pitches 2-5 available to choose from. i.e. the database has looked at this date and knows “Pitch 1” is used on this date so the single select will only show you the remaining Pitch options (Pitches 2-5) ? Does that make sense? I hope Im explaining it reasonably! Many thanks in advance for any info! Cheers Jon

Hey - I would love to figure out a way to use the Kanban view to show if two or more records are incompatible. I’m using the Kanban to display different categories of concrete ingredients that can lower the carbon content/climate impact of concrete mixes. Each ingredient has its own tile. Some of these ingredients can be combined, others cannot. Wondering with conditional logic if a special kanban column can be added where different ingredient tiles can be dragged, and if one is not compatible with others, all incompatible tiles turn red. Here’s a 40 sec video of me laying this idea out. Any ideas on if this is possible, and if yes, how it could be pulled off would be super helpful and appreciated! Thanks in advance!

Summary: I’m working on a basic sign up process. I’m sending a POST request with the user’s UID to a table called “Sessions” to create a new record. I wish to have a certain value returned if that UID exists on another table called “Users”, and a different value returned if it doesn’t exist. ex: So if I create a new record on “Sessions”, and the UID exists on table “Users”, on column RESULT I will get “User already exists on Users table”, and if it doesn’t exist RESULT will return “This is a new user”. I’m at a loss here at this point. Any ideas?

Hey Everyone: I am trying to set up a Send Summary button for my team so after a meeting it sends out the notes. I am trying to use the Open URL Action but the button stays greyed down and not active even though the button saves properly. URL Formula is this - “mailto:” & ENCODE_URL_COMPONENT({Attendees}) & “?subject=” & ENCODE_URL_COMPONENT(Meeting) & “&body=” & ENCODE_URL_COMPONENT({Meeting Summary})

Is there a way to export the list of billable collaborators a workspace owner can see in workspace settings? I’m looking for a way to pull a csv listing billable collaborators and the bases they have access to, similar to the workspace settings page, just in an external file.

Hello! I am new to Airtable, and I am hoping I can get some assistance. I am in charge of managing hearing lists for a law firm. I am looking for a way to take information from a .csv and list it in a way where you have the date of the hearing and then all of the hearings listed for that day and some additional information. They want it in a list, not in a calendar form. I am trying to figure out a way to automate it by creating a template where all I have to do is import the monthly CSV and run the app and the template auto-generates. Does such a thing exist? I have no problem doing the coding / generating the template (if it is not too complex… I know some basics, but I am by no means a coder), but I have no idea where to start. Thanks you for all of your help in advance!

I’d like to use Airtable to do production / batch / inventory tracking for a manufacturing company. We currently use digital logs (google sheets) to track our raw material intake, bulk production, secondary production, & product packaging. In a perfect world we would like a simple system that take that data and does a couple of things: Track production / packaging output based on batch number, product name, or product type Report on-hand inventory, filterable by product type or name Report production / packaging by date range Pull reports of total production / packaging based on batch ID Pull reports of total production / packaging based on vendor (multiple batch IDs) I looked for some templates that were close, but didn’t find something out there that was easily modifiable. So I guess I’m really looking for someone to build this for me (for pay, of course). Any takers?

Am I going crazy? As of this afternoon, when I double-click on field headers, only the field title goes into edit mode. Until now, double-clicking the field header would open the customize field type modal. If anyone from Airtable HQ is seeing this and this was an intentional decision, PLEASE change it back. It’s killing my workflow when building bases with many, many fields.

Or better yet, a daily report of all the records that were deleted yesterday?

Hello, Me and my friend playing “neighborhood” soccer and we want an automatic mechanism that will build equal teams, based on a score for each player for these stats: Speed, Pass, Shoot, Defense. We are 20 people and we play 5X5, so its 4 teams. Each player will receive a form and he will fill each stat (Pass, Speed, etc) for every player from the group. What do I need to do for creating 4 equal teams based on this score, and how do I create the form to be the most comfortable for filling (I don’t want that every player will fill 19 different forms)? In the end, I want to create 4 equal score teams that will be created automatically :slightly_smiling_face: Thank you!

I use Airtable as a CRM but I need to fill more data of my customers. I want to ask them to fill those fields that are missing using a web form. How can I make it?

Hi there, I am new to Airtable and loving the capability however I thought that it would be simple to display the table that I am creating with particular columns visible in a clear A4 printable document. It is proving impossible or I have to sign up to multiple apps just to do it that is way over budget for the few that I may have to do per month. Basically I just need to print a table with columns visible and an image in each column for my business. It is to show clients what item they are having (for instance and oven) then a clickable link, some sizes/specs etc and then a tick box to approve. I have set it all up but cannot work out how to get this table to print to PDF that is legible and dynamic so the columns arent cutting off half of the images etc. I may only get 5 or 6 lines per page and the document may be around 30pages long, but I definitely need a print option. Page Designer doesnt seem to be the right tool, unless I am mistaken? I am also looking at solutions that can be

I am looking to pseudo-automate a stand-up/status message from about 25-30 people on a team. My plan is to schedule a slack automated message weekly at a certain time that links out to an airtable form. The form is linked to a status collection table that would collect these over time. The person would select their name from a drop down, a general status (choice of 4, linked to single select in table), the projects they’re working on (linked to a projects table), and a few notes fields. Ideally I want to show the latest update from a person. We’d then have another view of this data, filtered to show the updated entries. Currently I’m doing this by using Date of Entry > last seven days. However - the question I have - is there a way to instead simple show the latest record by person? For example currently if a person fills this form out 3 times in a week, the view will show all three records. But I only want the last update from a person.

Hi. I have a google sheet with students roll numbers, names, subjects & marks. My questions is: If I shift all this data to airtable, will it be possible to create a form which can be shared with students. The particular form will have only one field, roll number. Once the student enters it and submits the form, the next page/section they receive their marks for the particular semester. Is this possible?

Hi. I have one large database with clients. At different stages of the sales funnel, different managers interact with the client. I want the manager to be able to see the client card only when he became a collaborator. Is it possible?

Hi Since I assign jobs to our team, I end up getting tons of Airtable email notifications for all the back and forth comments that occur with that job. Is there a setting I can select to ONLY receive an email notification when someone @ mentions me? Looks like current settings only allow to fully turn on or off all email notifications. It would be extremely cumbersome for me to have to go into each task and “unwatch” every one I may have commented on. I’m hoping to fine tune that and only receive emails for @ mentions or when a job is assigned to me. Doable??? Thanks

I am using Airtable to organize/display entries in a video competition. Applicants will submit a video as an attachment in a form, and entries will be displayed on the competition’s website. I’m not able to use Youtube or a similar hosting site. I’m seeking inspiration if this has been done nicely before: Are there examples of using Airtable to organize videos (or other media) to be displayed on a website? To display the videos on the site, I’ve set up a gallery view with the attached videos as a visible field, and embedded it into the competition’s website. I’m interested in learning if there is a better way to obtain a similar display. Ideally, we would provide some kind of comment section, where viewers (not on our Airtable team) can submit questions about the projects, have them displayed publicly, and have someone respond to the questions. Has Airtable been used to organize comments in this way? I could link out to a different site for this (e.g., utilizing Google Docs), but I

I have a list of names of people enrolled in my class. Is there an easy way to place them into randomized groups of 5? Ideally, I could do this to have gender-balanced groups. Any suggestions would be welcome.

I’m trying to create a from that will search within the aitrtable DB anf return that result. I want to embed it to my website. Please help Thanks in advance

Hi Guys, I’m new to Airtable. I recently created a linked table where based on the code it will look up on the second table for a zone. so Centre Country is a formula referring to Centre cut and then I made it as a link to the Zone table Zone is the Value I return from the Zone table It works if I manually type the data in the Centre Country but I want it to automatically refer to the Centre cut and then pull the zone number. Every time a new value comes it doesn’t update. I know I can create an automation to update but is there a way to do without creating automation or using any integrations?

So I have a bunch of projects, in excess of 15. Most of them run for 3-6 months at a time. I want to be able to track gear used on projects and see how much gear I need on upcoming projects. If I enter a new project I enter the start and end date. I use a Gantt to see a global timeline of all my projects, which is nice, but I want to be able to basically go, lets check on November, see how many projects we have, how much gear/operators we may need. The problem is as I have many overlapping projects in November, and only a Start/End date…how do I basically be able to group by month? I tried to create hidden fields for each month, and a formula to determine if the date range for a project included that month, and if it did then I could at least easily count the projects I have for a given month, but certainly there has to be an easier way to do this…? Maybe I’m just overthinking?

Just lost 12,678 records. So, um, how many records can Airtable handle? I thought it was 50,000 for my pro plan. But I had 26,000 going and when I added a sixth field for price, 12,678 disappeared. Using the snapshot took me to someplace where my books are suddenly sorted by publisher when I need them kept in the order they were inputted so I can add the book id numbers my dad assigned to each book in what seems to me a random manner. I think I need to just breathe right now and admit to myself that all the frantic proofreading I did on Airtable for a week (on 8,000+ records) is gone. I’ll have to start again. Maybe I’m venting more than I’m asking a question. Can anyone commiserate?

Hi, folks. We’re about to do a big import, and I was wondering what is the maximum character length of a single line text field. Thanks.

Hey good afternoon, I wanted to create a view that gives me all the records from the Current Month and Current Day in history. So today being October 28, 2020, I want to be able to dynamically pull all the previous years for October 28th. I am sure I could add a month field and a day field and manually change them everyday as a filter in my view but wasn’t sure if there was anyway to dynamically pull the current date to get the historical values for the current date. Thanks in advance for any suggestions.

I would like to have a “Summary Table” of the sum info. That is the totals after grouping. How can this be done easily? Thanks in advance! Mark