I use this formula in my database: (FILTER(BASEDEVIS!B:B; BASEDEVIS!$A:$A=$D26))
The application translated it: (FILTER(BASEDEVIS!C[-3]:C[-3] , BASEDEVIS!C1:C1=RC4))
everything works great! but I’m looking for a formula that could do the same result directly in the app.
Do you have an idea ?
Thank you
Salut Cédric et bienvenu dans la communauté !
Well done trying to replace sheet formulas with app formulas.
In AppSheet you can use FILTER() or SELECT() commands. You can also filter your data in AppSheet using Slices when possible, which are always a better and a more efficient alternative.
SELECT() | AppSheet Help Center
Salut KJ merci de ton aide,
j’ai utilisé SELECT().
Ca fonctionne a merveille !!! 