Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Filtering

HI i want to ask some questions i have a two table Product and Category, in product i have linked to another record field with the name 'Categories' and i want to filter the record in Product table with id that i have in Category table i have tried t...

rmxburhan by 4 - Data Explorer
  • 203 Views
  • 3 replies
  • 1 kudos

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

federica by 4 - Data Explorer
  • 1515 Views
  • 2 replies
  • 1 kudos

Rollup fields, formulas, and nuances driving me nuts

Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above ...

Formula Help!

Hello, I am new to formulas so I was hoping someone can help me with the formula below. I am trying to create two new formula fields.In the first new formula field, I am trying to do the following: If the 'Category' field is Finance and the 'Owner' f...

coco-chen by 4 - Data Explorer
  • 810 Views
  • 4 replies
  • 0 kudos

Prefilling forms with Link to another record

I am facing difficulty in prefilling forms with 'Link to another record data type'Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON' What changes should I make so...

mshah72_0-1709137006213.png
mshah72 by 6 - Interface Innovator
  • 1422 Views
  • 7 replies
  • 4 kudos

Resolved! Airtable formula error in 'search records' module in Make.com

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be ...

hauwi by 6 - Interface Innovator
Solved
  • 803 Views
  • 2 replies
  • 2 kudos

Resolved! Calculation Percent yes/no in one field

I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calcul...

KevinTC91_0-1707511298379.png
KevinTC91 by 5 - Automation Enthusiast
Solved
  • 2423 Views
  • 4 replies
  • 4 kudos

Allocate information based on post number

Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided ...

LauraF by 4 - Data Explorer
  • 428 Views
  • 0 replies
  • 0 kudos