topic Re: Choose several date based on variable in App Development

Choose several date based on variable

GuillaumeBonin — Mon, 20 Dec 2021 21:08:46 GMT

Hi All,

For a users need, I have to use "Variable input" element.

With this element, users will filled a value (X) between 1 and 20, in order to display the current week and the next "X" week.

"X" is stored in my variable "vSemaine".

Example, if "X" equals to "4" and the current week is "47", I want to display the data between week "47" and "51".

I have a field "Semaine" but I am not able to filter between a range of week number. I tried this but it's not working :

=[semaine] >=week(today(0)) and [semaine] <=week(today(0))+vSemaine==> this code is used in a "button for navigation" element as "Action"

I don't know how to use a range in a filter, if someone could help me it will be great.

Regards,

forte — Mon, 23 Nov 2020 12:50:49 GMT

I have tested your case and it works for me. Seems that you haven´t selected proper action.

Attached qvf example.

Hope it helps

Regards

GuillaumeBonin — Mon, 23 Nov 2020 13:23:56 GMT

Hi,

Thanks for your quick answer, it's working perfectly in your applicaiton.But it seems that i didn't used the same "button" as you.

I used "", and it seems that the action that you used (sorry it's in french) "

it's not available in the button for navigation that I used :

I tried "select multiple values in a field" but it's not working.

GuillaumeBonin — Mon, 23 Nov 2020 13:29:44 GMT

I was using the extension instead of "Button" in "Graphics" part... Thanks a lot