Solved

Hi, Airtable folks! I’m having a trouble in setting view description. I am Japanese so I use Japanese alphabet for all of meta settings, such as table names, view names and they work fine. But when it comes to view description, they work fine at first but after a couple of minutes, they suddenly become all question marks like “???”. Does anyone know why this happens? I need a help!!!

I have a project management base I’ve built over the years. I store project specific information in a ‘Project’ table, which relates to a ‘Proposals’ table. Each project can have multiple proposals, but each proposal can relate to only one project. Each proposal contains a linked record to an organization in a separate ‘Organization’ table. When I check a proposal as awarded, the record in the ‘Project’ table then displays the corresponding awarded organization (we bid out to several general contractors per project, but only one is awarded). What I am trying to accomplish is a page designer block that is based on the ‘Project’ table but can display the fields from the organization referenced in the awarded proposal, without having to pull in the contractor information into the ‘Proposals’ table and then into the ‘Project’ table. I hope there is a simple solution, but I have not found it yet. @Jeremy_Oglesby – any chance you have an idea on this?

Inside of my Airtable base I have two fields that log the timestamp when certain fields are updated like this: From there I take the two timestamp fields and calculate the difference, the calculations reveals the time different for a product to move from “status 1” to “status 2” in minutes. With this calculation, I would like to have a conditional SMS message ideally or email if the time difference exceeds a certain threshold. If the above is possible, there are further items I would like to improve upon.

Hello. I am trying to implement a search functionality using the record id is this possible given that the id isn’t in one of the fields? As an example, I have the following records records: [ { id: “rec2PRjhAMAh2O64a”, fields: { Name: “blah blah”, }}, { id: “rec2otu8JF7ijlmA4”, fields: { Name: "klkdsd ", },] I want to search by the id. Is this possible?

Hi! I’ve been using the below formula for awhile, but it returns an #ERROR! for the fields where {FOC (Current)} is blank. For cleaner reporting I’d like to have it return as “PENDING” but can’t seem to get an IF formula to work successfully. Any suggestions? DATETIME_FORMAT({FOC (Current)},‘YYYY, MM (MMMM)’)

I am building a CRM database. There is a table in my database called Deals that contains a multiple select field called Deal Stage. One of the options in that field is called Closed Won. Those are deals for which we have a signed term sheet and are going to provide a loan. I want to create a new table called Loans where I list details for each of the loans we have made to that subset of Deals for which we Closed Won. For the primary field in the Loan table, I would like to create a formula that looks up the name of the deals in the Deals table and only finds those ones that have the status Closed Won in the Deal Stage field. I would be so extremely grateful for help me with this. Thank you!!!

Hello I have a product table. And want to use a button to order the products. And then create order records in order table (pulling 3 columns from product table) and link the two tables. product id - order id need some help im green John

So in the chart block, how does one exclude custom data categories? I feel like I am likely missing something. I have created custom categories using a multi-select field to code some qualitative data. I want to exclude certain categories or ones below a certain count. (Only display if there are more than 5 of a type.) Thanks

Hey there, I’ve got a Gallery view of people with biography info, name, and other mutli-select data points. The labels of those columns are used to form a survey. The survey asks questions like “what would you like your Bio to be?” and then in the Gallery view, I would want the label of the card to be displayed as “Bio” instead of showing the entire question in a card. Is this possible?

Hi Support, I have a Date field, and wants to get day diff of it till now. Yet when I set ‘d’, ‘days’, “d”,”days”, it’s always said error in formula. Without unit parameter, it works fine with second unit. Is it possibly a bug? Thanks, Elaine

Hello all, I’m new to the community and have been finding so many valuable resources here - thank you! I did some research on this question but wasn’t able to quite find the solution. Here is the basic layout of the two tables in question: RIGS table // Shows all our available inventory Rig 01 Rig 02 Rig 03 etc EVENTS table // Shows event details including which pieces of Inventory are assigned to which Event Event 1 - Rig 01 Event 2 - Rig 02, Rig 03 etc Objective: As Inventory is assigned in the EVENTS table, I want to remove the assigned Inventory from the RIGS table dynamically. I can make this happen per field, however it doesn’t translate to all records globally. Thank you so much for your help in advance! Joanna

I have multiple checkboxes in my base, showing only 1 checkbox per view. Can someone please help with putting together the correct formula to update my “Status” field based on the checkboxes. The closest I can find is support when 1 box is checked at a time, however, once this step is complete the checkbox for that view is hidden and the new view reveals step 2 - showing only step 2 checkbox. So as you carry on through the task management process multiple checkboxes will get checked and I don’t want the “status” field to show all fields, just the one on the current view. Typing that to explain it is harder than I thought. So in a nutshell- think of the checkboxes as status dropdowns - and manually changing the status drop down during each phase of your project. That’s what I need to accomplish but with checkboxes. Thank you

A huge draw back for me of Airtable is its limited Zapier integration - and the fact that it can only trigger on new record (and in view) - I really need this to trigger on updated field / record. I know I can do this with Integromat but don’t want to introduce a new app to my stack. There seems to have been some discussion of this some time ago… but quiet recently - is there another hack or imminent zapier development? Thanks

Here is what I want to do… We are using Airtable for a survey that can be answered anonymously. Many people may wish to do this at first and therefore not put their emails in initially. However, later we ask if they want to receive information about services, so we would then need their email. For now, I have the description state that they need to provide us with an email if they answer yes. Is there a way to have the email field pop back up? In other words, I don’t want to have two email fields, I want it to link to the same field.

Hi everyone! I have a table with a list of 6 different release dates - I’m trying to create a field that looks at all of those dates and picks the earliest/first one as “Initial Launch.” IS_BEFORE only seems to work with 2 dates and the factorial of 6 dates is 720 possibilities of combinations so I don’t think I can do a workaround combining multiple nested IF and IS_BEFORE functions. Maybe I’m over thinking this though. I also thought about self-linking and doing a rollup field? Anyway, any advice or recommendations welcome!

Hi, Airtable folks! I have a trouble with sharing blocks in Public. I was given a beta feature to share blocks in Public but all of the records are also automatically shared in Public. There is a button saying “Show data” in the top right corner in the shared public page, which I want to hide. Does anyone know how to hide it? If I can’t do it, I want to vote for the feature which we can hide it with.

Hi! The new Button field is awesome for so many different things and a great addition. I was wondering if there’s a way to have a button open URLs from fields {URL1}, {URL2} and {URL3}, all by clicking the one button? /AT

HI all! I could really use your help please. I have a column that I call “Sponsor” that is a value of a number like 12345 (this is imported from a spreadsheet) but instead of showing 12345 (cause I can’t remember who that is) I’d like it to show a name like Sally Brown. There are probably 10 unique “Sponsor” numbers that I need to correlate with 10 different names.

I have of data that you want to import in one fell swoop and I have a bunch of photos that relate to each record of that tons of data. Whats the most efficient way of getting all the data and images up?

I have three tables - Organizers, Events and Players. Organizers have events and players are part of an event. I want to pull the most recent event for a particular organizer through the API via a GET, but can’t figure out how to do that. I’d also like to pull in a particular event by ID. In this case, I’ve pulled the ID of the event into a column (RecordID) via a formula (RECORD_ID()), but don’t know the correct URL parameter to send. Thanks in advance.

How do you sum a column of data. I try the formulas that SUM({GROUP}), but the result is not the sum of all the data in a column.

Hello everyone. I am trying to build a somewhat complex base. I thought I had figured it all out, but I can’t get the last part together, so I would like some help please. First, I have (1) projects. Projects are created by (2) acts, which assign (3) people to the (4) group working on each of them. But an act can also do other things (extending deadlines, changing its type, etc.), which are all covered already maybe except for one that seems tricky for what I still need to solve: an act can replace people in the group or simply add more people to it. So I have the following tables: Projects Acts People Groups The (2) acts table has the following columns: A) [Single line text] Act ID B) [Date] Act’s date C) [Multiselect] Purpose/object [one or more of: “project creation”, “deadline extension”, “group member replacement”, “group member addition”, “final report/project closure”] D) [Link to one or many] Projects [because a projects sometimes are “connected” so a group will work on more

I manufacture products, and have a customer that buys several items at once. They are requesting a spreadsheet with one Item and description of each item per row in said spreadsheet. Example: My current base shows the following “3 Pieces of green widgets that weigh 50 pounds each and 3 pieces of red widget that weigh 10 pounds”. The customer is requesting the information to be displayed in a spreadsheet as below green widget 50 pounds green widget 50 pounds green widget 50 pounds red widget 10 pounds red widget 10 pounds red widget 10 pounds Does anyone have a suggestion as how to do this automatically?

hello guys, i am looking for this apps to manage my several projects. i proposing to use table as my “portofolio” and use category as my “project”. I am little bit confusing how to add more category within the table. maybe some of you willing to share your experience in using Airtable to manage several projects and oversee project statuses in a glance. thanks you

I’m having trouble viewing more than the Title and Date on my quick view while selecting an item on the calendar. Image for reference: How do I add an additional field to view so I don’t have to “Expand record?”