
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Select FIELD - Question! :)
Hi,
there's a way to allow the user to select only YEAR greater than 2015?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How you want to assign this?
1) OnOpen Document
2) Fuzzy Search
3) after selection one year?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i just want that no one should be able to see Year lower than 2016


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try This ;
=If(Year>=2016,Year)
if you don't want to show the data itself before 2016 apply the where condition in the script level .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(year>2016,year) on the listbox
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the logic behind, That means if some one select 2016 you need to display 2016 , 2017 ...
OR
You need to use default in listbox?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Well, probably the best thing is to change the script and don't load the data before 2016.
The reason is that data coming from year before 2015 are not validated - so i don't want to show nothing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps this?
Load Field1, Field2, Year From Table Where Year > 2015;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
another list box expression (on General tab / Field) might be:
Aggr(Only({1<YEAR={">2015"}>} YEAR),YEAR)
hope this helps
regards
Marco
