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

Forum Posts

Limit data submission by user

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

lmac by 5 - Automation Enthusiast
  • 278 Views
  • 4 replies
  • 1 kudos

Resolved! Issues with formula - Attempting an on hold client button

Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote","On Hold - Do not Quote"))We are hop...

ahenry by 4 - Data Explorer
Solved
  • 187 Views
  • 2 replies
  • 0 kudos

test scoring formula

Hoping someone can guide me with setting up a formula to score tests that are reported on another table.Here's the current setup:Table 1 - record of all test takers by session ID, including fields for all of their question responses.Table 2 - questio...

hhspiel by 5 - Automation Enthusiast
  • 213 Views
  • 1 replies
  • 1 kudos

How to search for what's missing?

Hi all, I'm working on a donor management system for a non-profit org.  Donors make pledges to give $x on x recurring basis, usually something like $50 a month.I've got a table for Donors, one for pledges, and one for donations.I need to have a way t...

Resolved! Template help

Hello everyon, so I have created this project management based on the template. I have got around 10 people in the group and how can I do that when each person logs into that base it will show tasks by name individually? Cuz for now you have to do it...

Screenshot 2024-02-21 at 16.26.43.png
jsaduakassov by 5 - Automation Enthusiast
Solved
  • 1364 Views
  • 7 replies
  • 1 kudos

Filter rollup field by created date

I have rollup field that sum all the records from a table. I want to limit the sum from all to sum for current month only.How can I do it? 

SoMedia by 4 - Data Explorer
  • 165 Views
  • 1 replies
  • 1 kudos

Resolved! Loom content in formula field

Hi! Wondering if there's any way to make this work...I have a formula field that pulls info from multiple fields & concatenates it all together to create an email (content) to be delivered to the person associated with that record.I want to include a...

Combining fields in table into formula

Can someone assist me with writing this formula? I'd like to basically have a column in which the staff or faculty nominee column is combined with the value. For example: Cameron, Ali - Innovative SpiritI'm running into an issue were if the staff col...

Keywords

Hola a todos! Estoy trabajando en un proyecto en donde los usuarios podrán escribir artículos. La idea principal, es que las keywords se generen automáticamente a partir del texto del artículo. He buscado por todas partes pero aun no eh logrado esa f...

sfaig by 4 - Data Explorer
  • 150 Views
  • 0 replies
  • 0 kudos

Resolved! Invalid Formula

Hello,I have a formula in Airtable which should output "SMS" if certain conditions are met.This formula has worked for a long time and has not been changed. Now I have noticed that something has been changed in the formula function and Airtable indic...

KevinDax by 5 - Automation Enthusiast
Solved
  • 1622 Views
  • 1 replies
  • 1 kudos

IF <X> Range = checkbox

I'm new to Airtable and I need a formula to check a box from a form submission.IF >=0, 3>= then True (Checkbox 1)IF >=4, 6>= then True (Checkbox 2)IF >=7, 9>= then True (Checkbox 3)IF >=10, 12>= then True (Checkbox 4)I have an automation that sends a...

ksaycdc by 4 - Data Explorer
  • 309 Views
  • 1 replies
  • 0 kudos

Setting up specific date ranges

I have a table that records all of my business leads.I have another table that functions as a report, to provide a summary of all those leads, how much they cost, when they were generated, so on and so forth.These tables are linkedCreated Date column...

DennisyuTSS1 by 5 - Automation Enthusiast
  • 158 Views
  • 0 replies
  • 0 kudos

Roll up (or look up) of Table B, based on conditions in Table A

Hi there,I'm trying to create a field in a table (say Table B), where its output is takes into consideration a condition based on a field in Table B, rather than the original table it is rolling up from (which I know Airtable has a simple filter for)...

acxp by 4 - Data Explorer
  • 351 Views
  • 2 replies
  • 0 kudos

Airtable relation & product

Hello!Situation:I have a table named « Leads » in which is all the information of my prospects (first name, last name, email, phone Numbers).These prospects, via a Tally sent by email, inform their needs with regard to 9 products (always the same). S...

Remove date/time from field

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I do...

JJJ by 4 - Data Explorer
  • 296 Views
  • 1 replies
  • 0 kudos

Ingredient stock rollup

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products.  Sometime the same ingredients will be used for five different products.We want to creat...

MoniK by 4 - Data Explorer
  • 512 Views
  • 3 replies
  • 0 kudos

Future Inventory & Ship Out Dates

Hello! We operate in an industry dealing with perishable goods, where the timing of receiving products (INBOUND) and the customer's requested shipping date (OUTBOUND) are crucial factors. We are trying to create a base structure/formula so we can kee...

4pine by 4 - Data Explorer
  • 558 Views
  • 1 replies
  • 0 kudos

Resolved! Formulas > Números Consecutivos > A partir de un número en Especifico

Muy buenas tardes,Estoy montando mi propio gestor de proyectos, estos proyectos quiero numerarlos con números consecutivos, pero que el primer número sea un número en especifico.Por ejemplo:N. de Pedido: P003245 (Esté sería el primer campo de la tabl...

JuanArLo by 4 - Data Explorer
Solved
  • 500 Views
  • 1 replies
  • 1 kudos