Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to provide input box to the user.
If user enter any date in the input box and automatically select in month in month list box or chart.
Ex: user enter 10/06/2017 in input box it automatically select Jun month in other month list box. How to achieve this?
For this, you can achieve like. Please handle one variable called as Variable1
Then, In list box, you can call it as expression to =If(DateField = Variable1, MonthField)
If it is in straight table, You could state that variable as Sum({<DateField = {"<= Variable1"}>}Sales) // Here, You can manipulate if date format issue
One way is you can use triggers to select the Month field with the date entered in the Inputbox.
Create a variable using Inputbox. Then using your monthfield add a trigger from Doc Properties ctrl+atl+D then variable event triggers select the variable created from inputbox.