Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Update a field with previous data record

Hello everyone,I'm a beginner on Airtable, I don't really know where to post this message, so sorry in advance if it's in the wrong place, I have some ideas for resolution but it could be in automation, base design or then formulas, I chose to post i...

jeremy_b by 4 - Data Explorer
Solved
  • 259 Views
  • 1 replies
  • 1 kudos

Transfer Structure in a Cash Flow Base

Hello - I am new here and trying to create a base for following cash flows in my various accounts, cash or petty cash.Thanks to sources I found here, I succeeded to create deposit and withdrawal through two tables, one for accounts and one for transa...

murater by 4 - Data Explorer
  • 274 Views
  • 2 replies
  • 1 kudos

Resolved! Pulling a list of tasks that were completed overdue?

Hello,As projects come to a close, I want to review how successful my team was on staying on task and completing tasks by the deadline. My base is set up to flag overdue tasks, so I know in the moment when something is overdue and needs to get done A...

kmm23 by 5 - Automation Enthusiast
Solved
  • 751 Views
  • 6 replies
  • 0 kudos

Changing help text based on input in a form?

Hi! I'm trying to make it easier to check which cell phone carrier a person uses based on their phone number. Right now I have a formula I use, but formulas can't appear in formsThis is the formula I use: IF({Phone Number} = BLANK(), '', CONCATENATE(...

echointer by 4 - Data Explorer
  • 267 Views
  • 1 replies
  • 0 kudos

How to use return outside of select method

Hello, I am using the Airtable API in javascript. Currently I am using the select method based on the documentation, and I am trying to make use of the returned data outside of the method.For example this is my code:  base('TestData').select({ vi...

Resolved! Rollup - displaying a field, based on another field's value

My Table A is a list of Staff members, and is linked to Table B.  Table B are records of Agreements, with one of the fields being Company (the company name of that Agreement.  We have several companies).  A record in Table A (Staff) has multiple Agre...

Screenshot 2024-04-08 at 03.49.42.png

How can I create a summary table of thousands of records, my method seems clunky

I have a table with 5K+ rows of data as such:table1Date - Year(formula of date) - Month(formula of date) - DataPoint1/1/2020   2020                                         01                          5461/2/2020   2020                                ...