Ask A Question | Airtable Community

Hiding Certain Records Within Base by User

I want to block certain users from seeing entries within a base that are for a specific client without making a second base for that client. Is this possible?To elaborate, I would like to use ONE base as this is a hub for all company work orders that...

12 Views
1 replies
0 kudos

Factors Affecting Base Performance

Hey there heavy-lifiting Airtable power users (i.e. full time consultants, developers and similar)!I recently engaged in different discussions with fellow consultants on what factors affect base performance (e.g. speed) the most, trying to come up wi...

22 Views
1 replies
0 kudos

How to fix formula to only calculate if input value is 0 or not empty?

I'm having a really hard time with making a formula field only calculate a value if the input field is not empty, including if it's 0. For some reason Airtable seems to treat 0 and empty value that same.Here is my current formula: IF({Monthly Actual}...

23 Views
2 replies
0 kudos

Difference in the sum of the records in the Data base and what is visualized in the Interface

Hi community,Has anyone encountered the following issue and what may be causing it. I have a record - Unique prospects contacted in my database. The sum of all entries in this column is correct showing 18516In the designated Interface I have created ...

40 Views
3 replies
0 kudos

Resolved! Return a numerical value based on a Single Select Dropdown

Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 30...

48 Views
3 replies
0 kudos

Formula to return text and URL

I have a table of books with the following columnsBook Titleyear publishedAmazon LinkBookshop.org LinkI want to create a field that returns Book Title (Year Published) Amazon Bookshop, where the "Amazon" is linked abd "Bookshop.org" is linked.Is it p...

49 Views
3 replies
0 kudos

Resolved! Update record based on form

I am attempting to use a form to update a record in the existing table.So an account executive fills out a form with the new terms and rate amounts for 2025 2026 and 2027I tried coping a workflow shared by a community member (https://community.airtab...

54 Views
3 replies
0 kudos

Preserving Comments/Historical Record

I am building a complex workflow for a project-based business. In this workflow, if multiple customers are associated with a job, the job is duplicated for each customer (City Building 1, City Building 2). Furthermore, if multiple versions of the job...

42 Views
1 replies
0 kudos

Counting status field changes and automate changes to it

Hi, I'm running a research participant network for my organization. When our customers sign up to do product research with us, they provide a number of times they want to be contacted about engaging in a research activity. I need an flow automated f...

55 Views
1 replies
0 kudos

FilterByFormula - Exact match for Multi-Value Columns

Hello Airtable Community!I'm facing a challenge with constructing a filterByFormula and came across a similar issue discussed here: https://community.airtable.com/t5/formulas/formula-with-multiple-values/td-p/174768.I have a column named Klasse, whic...

99 Views
3 replies
0 kudos

Browse the Community

Automations

Base Design

Formulas

Interface Designer

Other questions

Ask A Question Activity