Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In my data model I have a calendar with a Year field . I also have a variable vCurrentYear which is set to Year(today()).
Is there a way to create a bookmark where part of the bookmark is set set Year to the variable $(vCurrentYear).
As an alternative I can just add a field CurrentYear to my data model and make that part of my bookmark.
Thanks,
Michael
Create a filter pane with the field Year, perform the search: =Year=$(vCurrentYear) and hit enter, then create the bookmark.
Create a filter pane with the field Year, perform the search: =Year=$(vCurrentYear) and hit enter, then create the bookmark.
Very clever and then bookmark the -1 value.
I like it!
Michael
Does anyone know if this still is possible? I am trying this but it does not seem to work for me
this works but is tricky. you need to do the search with the column name and variable as described above, be sure to press enter on the keyboard (do not use the check mark to select the value!!) and also be sure the bookmark has the option checked to include variable state