Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Welcome to the Airtable Community!

47839members
114531posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Average Cost Per Lead In Interface?

I run a digital marketing company and I'm trying to have an element in an interface that reports the Average Cost Per Lead. For this I need to divide my total amount spend on paid ads with the amount of leads generated. Is there a way to do this?

  • 1 Views
  • 0 replies
  • 0 kudos

date range forumla

Hi! I'm trying to create a field of active/inactive based on a date range. I already have a field each for start date and end date, but can't figure out how to create the formula for the active field based on those dates. Any ideas?Thanks! Sondra.

  • 5 Views
  • 1 replies
  • 0 kudos

Tracking Latest Values

Hello Everyone, I am having a methodology issue.I am working on a personal price tracking project, in my case, it is computer parts.  But I believe this could translate to almost anything. I have multiple tables, one for each component type (CPUs, RA...

  • 12 Views
  • 0 replies
  • 0 kudos

Currency Conversion Script - Run on Input?

I am using a modified version of the currency conversion script kindly provided in this thread https://community.airtable.com/t5/development-apis/custom-currency-calculations-using-scripting-panel/td-p/136067 by @Vivid-Squid but I don't want to have ...

Screenshot 2022-12-09 at 15.46.45.jpg
  • 19 Views
  • 2 replies
  • 0 kudos

Form Validations and conditions

Hello, I'm fairly new to the paid version of Airtable and I've been able to figure out most of the features and automations I need. I'm specifically wondering (especially with the updates that have come out) if there's a way to validate entries and f...

  • 2 Views
  • 0 replies
  • 0 kudos

Null check in Airtable Automation Script

Hi I recently decided to take the leap to level up how I use Airtable by taking baby steps to use Airtable script to accomplish more complex tasks, especially in Airtable Automations. I am currently struggling to combine a typical "If conditional sta...

CleanShot 2022-12-09 at 17.45.22@2x.png CleanShot 2022-12-09 at 17.45.22@2x.png
  • 17 Views
  • 3 replies
  • 0 kudos

Problems merging different fields

I've been researching and trying to create a table for my needs but having problems and doubting if this is possible with Airtable.I'm importing a csv/google sheets everyday with ID, date and amount fields. What I'm trying to achieve is, import anoth...

  • 14 Views
  • 1 replies
  • 0 kudos

Remove Characters after comma for string fields

Hello Airtable world,I need help with a formula. I have a look up field with many options. All of these options share the same data for some field e.g. Pick Up Location.In this case, I have 1 record with 2 options (lookup field) and the look up field...

Matteo_Saporett_0-1670533707555.png
  • 41 Views
  • 1 replies
  • 0 kudos

Formula Based on Monthly Income

Hi guys, im trying to do an automation that performs the following: “If Salesperson A’s monthly revenue is below the target, then do X”  However, I can’t find a way to automatically reflect the revenue of the month based on the month I’m in. I can do...

  • 28 Views
  • 1 replies
  • 0 kudos

Filtering a grid based on record picker

I have a record picker that I want to use to filter a different grid source.For example:1. Picking a project with difficulty of 2/3.2. Filtering a gird of freelancers with ability to work on difficulty of 2/3 and above.I can only manually input the f...

  • 24 Views
  • 1 replies
  • 0 kudos

Custom Future Date Calculation

Is it possible to calculate future dates based on the nth occurrence of a day of the week in a given month? For example, I would like to return the dates the 1st Monday in April falls in 2023, 2024, etc.

  • 36 Views
  • 2 replies
  • 0 kudos

Get Table information from Linked Record

I'm working on a script that will move records (and its child records) from one base to another. It's mostly working but one issue I'm running into is figuring out the table information of a linked record. For instance, I have two tables: Companies a...

  • 49 Views
  • 2 replies
  • 0 kudos

Unable to create new table in existing base using API

Hi All, I would like to use the Airtable API to create a new table in an existing base. I've tried using Python/ PyAirtable as well as https requests via Postman. The API reference uses the following:https://api.airtable.com/v0/meta/bases/{baseId}/ta...

Screenshot 2022-12-08 at 16.29.16.png Rutger_0-1670513579024.png
  • 56 Views
  • 1 replies
  • 0 kudos

Sum up values if value is the same

Hi, I'd like to sum up the values from the "Weitghted results" column, when "Technology"=Social Media, or when "Technology"=BlockchainI have made some researches but can't find to get it correctly. I've used this formula but it doesn't work: INT(IF({...

  • 54 Views
  • 2 replies
  • 0 kudos

Keep Record setting when formula runs

Hello everyone! I have this table:The issue right now is that when I in 'Næste gang?' selects an option, fx. 'Daily' or 'Weekly', the Record will update and get a new deadline based on my choise (daily or weekly). However the Record also looses all i...

Skærmbillede 2022-12-08 kl. 14.58.44.png Skærmbillede 2022-12-08 kl. 15.04.14.png
  • 39 Views
  • 3 replies
  • 0 kudos

Airtable forum UI helper

Hey guys, I made some customizations for the new Airtable forum and figured I'd share them in case anyone else found them useful!You can turn off whatever features you don't want, and I've left comments in the code to help with figuring out what you ...

Read vs Unread - Original.png Read vs Unread - Customized.png Fixed reply box - Original.gif Fixed reply box - Custom.gif
  • 77 Views
  • 1 replies
  • 1 kudos

How can I recover my bitcoin wallet after loss the key?

Hey Everyone,I have Loss access to my data of bitcoin wallet, especially financial data such as private keys, seed words or other authentication codes. How can I recover my bitcoin wallet after loss the key?Need some bitcoin private key finder tools ...

  • 55 Views
  • 0 replies
  • 0 kudos

Announcements

Community Change Maker: Mark Figueiredo

The Airtable Community Change Maker Spotlights are a new ongoing series where we will be highlighting inspirational creators across the Airtable Community. We are thrilled to be able to highlight Mark...

Announcements

Welcome to the new Airtable Community 🚀

Welcome to the new Airtable Community Experience! We are so excited to welcome you back. Whether you've been a member of the Airtable Community since day one or you joined us a few clicks ago, thank y...

Announcements

Community Change Maker: Danielle Combs

The Airtable Community Change Maker Spotlights are a new ongoing series where we will be highlighting inspirational creators across the Airtable Community. We are thrilled to be able to highlight Dani...

Announcements

Community Change Maker: Hannah Wiginton

The Airtable Community Change Maker Spotlights are a new ongoing series where we will be highlighting inspirational creators across the Airtable Community. For our first spotlight, we are thrilled to ...

Announcements