How to search a number with a date

[bguiraud]

Hi

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

Can you help me ?

Thanks !

[BillH]

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.

[bguiraud]

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]

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.