Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can anyone help me with a widmatch function?
I am using this expression in a ListBox:
=if(wildmatch(Narrative,'Goods*')>0,'Goods Received',Narrative)
What i want to do is use this expression but when StockQty is greater than ZERO (>0)
Then i want to use a simular expression...
=if(wildmatch(Narrative,'Goods*')>0,'Goods Returned',Narrative)
but when StockQty is less than ZERO (<0)
So what i want to end up with is a List Box displaying 2 description:
Goods Received (which will show all positive values)
Goods Returned (which will show all negative values)
Can anyone tell me how i can do this please?
may be you require this
if(wildmatch(Narraative,'Good*') and StockQty >0,'Good recieved',
if(wildmatch(Narraative,'Good*') and StockQty <0,'Good Return'))
see the attached file
may be you require this
if(wildmatch(Narraative,'Good*') and StockQty >0,'Good recieved',
if(wildmatch(Narraative,'Good*') and StockQty <0,'Good Return'))
see the attached file
Thats excellebt, thanks very much
I have another question tho in regards to the Wildmatch function..
How would i set an action to select any 'Goods*' narrative?
What i want is when the user clicks on a Goods Received button, any narratived with 'Goods*' will be selected.
I have tried using the SELECT IN FIELD option, and choosing Narrative for the field, and the search string....
=WildMatch(Narrative,'Goods*')
but i can't get it to work, What am i doing wrong?
i belieeve no need to set an action to select
if you apply on ur data properly then it will select all good * when seleect Goods Received
u can also select from list box
or else share the sample
Hi, yes i know that, but i want the user to make as little selections as possible. My app shows not only goods received, it shows :
Goods received
Wastage
Reductions
Stock Checking
Stock Variances
Each reason has its own page, so when the user click on the Goods received page i want it to automatically select all narratives for 'Goods*'. Then the user only has 2 option to choose from:
Goods received
Goods Returned.
Thanks
Please see attached
hello
i am not know how to write action on button
but you can cheeck this using a list box
see the attached file
meanwhile i looking into action
Thanks, but thats not what i want. I want the button to select it. But thanks for your help.
I'll start another discussion..