Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Combining different data fields into one column

Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be gr...

bartdubs by 4 - Data Explorer
  • 9 replies
  • 0 kudos

Simple Conditional setting not working for Lookup field?

I am attempting to make a Travel Sheet my Supervisors access through a Form view, that allows the selection of Employees (linked from our Employee Table) based on their current Employment Status (which is a dropdown selection on the other table). Whe...

halffrozen by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Locate Completed Record

Hi, where do I find completed record when it disappeared in the table?

reign by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Prefilled Forms with Conditionally Hidden Fields - Continuous Forms

Hi Everyone!I'm relatively new to AirTable and figured this might be a question for you all! For context... I work with people who don't always reply to their emails or often miss conversations that we need their input on. Which means process get del...

bweber by 5 - Automation Enthusiast
  • 4 replies
  • 0 kudos

Recreating SUMIFS and Expenses Sheet by date and category

I would like to recreate a transaction sheet and P&L sheet from Google Sheets into Airtable. In Sheets, there is a "Transactions" sheet with all of the company's expenses. The relevant columns for the P&L sheet are data, amount, category 1, subcatego...

triple by 5 - Automation Enthusiast
  • 1 replies
  • 0 kudos

when copy formula values "HTML code"

I've HTML Code to use inside formula to insert virables inside the HTML code then export it as final HTML Code.. the problem is when i tried to copy the field it add some extra character (")...Here's the formula code:"<div style='position: fixed; top...

Karek_Rami by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Create a view based on duplicates

Hi all, I'm stuck as to what to do here. Hoping someone can help. I THINK a formula should be able to do this? Essentially I want to create a view that shows me only the records that have a zip code that matches a zip code of another record. I was pl...

Screenshot 2023-06-21 at 11.51.41 AM.png

Resolved! Attachment URLS

I know I am late to the game here. I have been ignoring the updates until now. I currently have uploads and the links for the uploads through a formula - which allows me to create a download button.I use these so in the public share link to my base -...


Is there a way to get the count in group view?

Hi, i would like to ask for help if there's a way to get the count in group view maybe via automation or scripting. (please see screenshot). Though we have a count My goal is to check one of my field when the program is under the same metro schools -...

Pursarth_Tuladh_0-1682402939742.png Pursarth_Tuladh_1-1682403077031.png

Display Options

Hi! I just moved over here from Quickbase. On QB, when I did a search, all the matching results appeared, and no other records were showing.In my new Airtable, my search results in a single highlighted instance of the matching search result, and I mu...

enhompe by 4 - Data Explorer
  • 1 replies
  • 1 kudos

Updating Airtable IF something new exists in Podio

Hi everyone, Thank you in advance for any suggestions you may have I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues...

Dhiresh by 5 - Automation Enthusiast
  • 2 replies
  • 0 kudos

Resolved! Create URL for filtered Gantt view?

Hi, I'm trying to create a formula that will direct to a Gantt view filtered by a ProjectID field (So I can create a "Open Gantt Chart" button in an Interface using the "go to url in record" action that will open a Gantt view filtered by a specific p...

Liz_Shaw by 5 - Automation Enthusiast
  • 4 replies
  • 3 kudos

Carry formula into summary row?

I am building a database for an investment firm where they purchase and sell investments. I have a column that calculates the multiple earned on an investment. For example, if cost = $100; proceeds on sale = $150 (proceeds / cost) then the multiple f...

MattW by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Show/Hide complete row in a table with "single select".

Hello, I am working with Airtable and Softr. Sometimes it would be helpful to show or hide single rows of a table. So I am looking for a way/formula to easily switch on or switch off (mute) each row in a table with "single select". Sort of like enabl...

Resolved! Utilize Date conditions after creating date token in formula

I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...

Screen Shot 2023-02-01 at 12.05.39 PM.png Screen Shot 2023-02-01 at 12.05.56 PM.png
RoseAmelia by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos