Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 25, 2024 05:36 AM
Hi
I want to search a number with a date, like this :
Can you help me ?
Thanks !
Sep 25, 2024 06:59 AM
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.
Sep 25, 2024 08:18 AM
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 !
Sep 25, 2024 08:50 AM
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.