Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have an application that i am writing for transactions.
In my script i have the following..
LOAD *, 1 AS CustomerSalesValueRangeSelection INLINE [
Sales Value Range
All Values
Equal To Entered Value
Between Entered Values
];
I have then created a LIST BOX which displays the above fields.
When i click on a field above i,e 'Equal To Entered Value' I have then got an input box to appear where the user can enter a transaction value.
The input box is mapped to a field called 'Amount'.
The same thing happens if the user click the 'Between Entered Values' (but 2 input boxes appear).
The problem i am getting is if i enter a value into a list box, the value appears in my current selection (which is what i expect) but when i click on 'All Values', my initial selection is still selected. I do not know how to tell it that 'All Values' should include everything.
Does anyone know how to do this please?
And also my 'Between Enterd Values' selection doesn't work. i can enter a GREATER than figure, but when i enter a LESS than figure it wipes out my GREATER than because they are using the same field. Can i use the same field for 2 different selections?
I have attached my example
Any help with this?
No thoughts anyone?
Hi,
Here you are a possible solution for your problem.
Check out the document properties, Triggers, Sales Value Range fiel select action for Equal case, and the Find button action for between case.
I hope it helps you.
Regards.
Thanks Miguel, that worked great 🙂
Is there any way though that on the Greater than and Less than input boxes, the £ sign can go on automatically? That way the user only has to enter numbers, i.e. 1.50 but the input box displays £1.50 instead of typeing £1.50?
Your help is very appreciated..
Hi,
I was on vacations, so I'm sorry by the late answer.
I think there is a way for that but it could be very expensive for the document's performance. It's better the user expends a few seconds writing the value that all the document works slowly.
Regards.