I have a repeating field of 2. When filtering on the second field it does not take it into account...
Hoe can a filter on repeating field ?
Filtering on a repeating field
5 posts
• Page 1 of 1
Posts: 3
Joined: Mon Jan 20, 2014 12:37 pm |
|
Hi Paul. Which SeedCode product are you using and where exactly are you trying to implement a filter? Can you post a screen shot?
|
|
Posts: 3
Joined: Mon Jan 20, 2014 12:37 pm |
Hi
I am using SeedCode Calendar v12. In The Event Details I have a repeating field with the length of 2 (Installateurs: Mobiliflex and Armag in the screen capture). When I filter the Calendar, let"s say on the second field of 2 (Armag), I always get the first field as well in the results. Also if I filter on Mobiliflex I also get Mobiliflex QC. See attachment... Thanks
|
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
Hello Paul,
Thanks for the screen shot! The idea here would be to use a single field in Event Details for your installers, and to separate the installers with carriage returns. Formatting the field as checkboxes will do this for you automatically. The beauty of this is that there is only one field to search: searching the field for "Armag" will find them if they are the first installer for that event or the third. (That kind of search is what our filters do under the hood.) This is what we demonstrate in this video showing how to link an event to multiple resources (like your installers): https://www.youtube.com/watch?v=lYWbh9_e2jw More at the end of the page here: http://www.seedcode.com/pmwiki/pmwiki.p ... .Resources Additionally, return-separated values can be used as keys in relationships where repeating values can not. So if you have a field with more than one ID separated by carriage returns, a relationship based on that field will match ANY of the rreturn separated values in the field. In this case that is much preferred to using repeating fields. John Sindelar
SeedCode |
Posts: 3
Joined: Mon Jan 20, 2014 12:37 pm |
THANKS!
It does work as describe in your response! Paul |
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests