Hi all,
I'm trying to set the text of a button from a certain cell from a datatable. The datatable and the button are NOT on the same screen (if this is revelant).
I have a Data table named WCSINFO as such :
And I want my Button to have the text from the "Cellule1" column first row. I'm gonna have as many button as there are cells in the table.
So I did a Lookup function like this :
LookUp(WCSINFO,Matos="EQUIPMT 1",Cellule1)
in the text field but it does not work. I get the error :
The formula contains 'ParenClose' where 'Error' is expected
I've also tried to set a variable to use in the text field But I canno't manage to make it work.
Thank you
Ok I found a solution.
Since the table was fetch from a excel workbook, I had to call the table from the workbook and not the one that I added in the screen.
So I get something like this :
LookUp(Tracking_des_colis__1;Column2="EQUIPMT 1";Column3)
And this works for me.