Loading...
 
Features / Usability

Features / Usability


CustomSearch, searching item between values

posts: 8633 Israel

I wonder if it is not simpler to create a mathematical field and give a value based on range.
A kind of :

if tracker_field_value 0 and 10 and


After two hours playing with possible formulas and (damned) parentheses...

Copy to clipboard
(if (less-than permanameSize (add 80 0)) (str -80) (if (less-than permanameSize (add 120 0)) (str 80-120) (if (less-than permanameSize (add 160 0)) (str 120-160) (if (less-than permanameSize (add 200 0)) (str 160-200) (if (less-than permanameSize (add 240 0)) (str 200-240) (if (less-than permanameSize (add 280 0)) (str 240-280) (if (more-than permanameSize (add 280 0)) (str +280))))))) )


Success ! 🏆

There are no comments at this time.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting