Skip to main content

How to search a number with a date

  • September 25, 2024
  • 3 replies
  • 28 views

Forum|alt.badge.img+4

Hi

I want to search a number with a date, like this :

 

Can you help me ?

Thanks !

3 replies

BillH
Forum|alt.badge.img+24
  • Brainy
  • September 25, 2024

I might be guessing wrong on your goal, but it seems you could create a column as a link to a pipeline record, then modify the "Benefices Prev." column to be a lookup to that link with the output being the value from "Calcul" in the lookup record.

You would either have to manually link the record when you create a new row or set up an automation triggering on the new row creation to populate the row.


Forum|alt.badge.img+4
  • Author
  • New Participant
  • September 25, 2024

I might be guessing wrong on your goal, but it seems you could create a column as a link to a pipeline record, then modify the "Benefices Prev." column to be a lookup to that link with the output being the value from "Calcul" in the lookup record.

You would either have to manually link the record when you create a new row or set up an automation triggering on the new row creation to populate the row.


Hi.

Thanks.

Have you got an exemple of formula ?

Because I don't see how to do that 🤔 🤔

I need to create a link record in another table ?

Thanks !


BillH
Forum|alt.badge.img+24
  • Brainy
  • September 25, 2024

There is no formula.  

You create the link to the record in the same table not a different table.

Airtable isn't a spreadsheet, so you need the link in order to do a lookup to other records in the same table, but usually that involves adding an automation to populate the links as you add records unless you build it into a form or interface.