Re: [Tiki-devel] Tiki Item link preselect parameters

Forgot to mention that preg-replace math function is available in Tiki 21+

On 8/16/21 9:51 AM, Victor Emanouilov via TikiWiki-devel wrote:
>
> Bernard,
>
> Ah, that's easy but unfortunately, I don't see a documentation about 
> it, maybe you can add one :)
>
> Math formula to get the user: (preg-replace (str /^.*?\|/) (str ) 
> fieldMonthAndUser)
>
> Math formula to get the month: (preg-replace (str /\|.*$/) (str ) 
> fieldMonthAndUser)
>
> Regards,
> Victor
>
> On 8/15/21 10:49 AM, Bsfez Tiki wrote:
>> Hi Victor,
>>
>>> Maybe you need 2 additional fields (Month) and (User) in the same 
>>> tracker, both Math fields with calculation to extract that info from 
>>> the Month|User field and the match other items based on the new fields?
>>>
>> I thought also about a calculation field to split the Month|User and 
>> have 2 separate field I can use separately but I couldn’t find how to 
>> do it : https://doc.tiki.org/Calculations 
>> <https://doc.tiki.org/Calculations>
>>
>> Thanks for guidance,
>> Bernard
>>
>>
>>> On 13 Aug 2021, at 13:30 , Victor Emanouilov <[email protected] 
>>> <mailto:[email protected]>> wrote:
>>>
>>> Yes, it is a trial and error, unfortunately. I am not sure Trackers 
>>> natively support your use-case where you have 2 different values 
>>> Month and User in one field and want to restrict items from other 
>>> trackers based on part of the field. Maybe you need 2 additional 
>>> fields (Month) and (User) in the same tracker, both Math fields with 
>>> calculation to extract that info from the Month|User field and the 
>>> match other items based on the new fields?
>>>
>>> Regards,
>>> Victor
>>>
>>> On 8/13/21 12:14 AM, Bsfez Tiki wrote:
>>>> Thanks Victor,
>>>>
>>>> I’m trying to have items generated and populate automatically from 
>>>> other trackers just using the "Month | User" field only.
>>>> For this I’m trying to use the "Month" part with a filter based on 
>>>> date range (so I can make it each with each end of the month) and 
>>>> the user part to auto-select the user linked with the item list 
>>>> (hours) generated by the "Month | User" field.
>>>>
>>>> That’s why I wanted "August | Victor" to be used as filter for the 
>>>> user Victor and select it.
>>>>
>>>>
>>>> From what I remember (but will re-teste as usual):
>>>>>
>>>>> - check out the cross-select option
>>>>>
>>>> = Empty dropdown
>>>>
>>>>> why don't you try with a Dynamic items list field?
>>>>>
>>>> = blank disable dropdown
>>>>
>>>> I’ll dig more… after I update to Tiki23.
>>>>
>>>> Thanks 🙏
>>>>
>>>> B
>>>>
>>>>
>>>>> On 12 Aug 2021, at 16:34 , Victor Emanouilov via TikiWiki-devel 
>>>>> <[email protected] 
>>>>> <mailto:[email protected]>> wrote:
>>>>>
>>>>> Bernard,
>>>>>
>>>>> I also don't fully understand this preselection but have the 
>>>>> following suggestions:
>>>>>
>>>>> - check out the cross-select option
>>>>>
>>>>> - check if Month | Worker tag field contains the same values as 
>>>>> the ones you are trying to preselect
>>>>>
>>>>> If all you need to do is selecting the user out of Month | User 
>>>>> kind of field, why don't you try with a Dynamic items list field?
>>>>>
>>>>> Regards,
>>>>> Victor
>>>>>
>>>>> On 8/12/21 10:24 AM, Michael Finko wrote:
>>>>>> looks like that's the lowest value on the list, so essentially is 
>>>>>> using the 'first' value?
>>>>>>
>>>>>> On Wed, Aug 11, 2021 at 7:26 PM Bsfez Tiki via TikiWiki-devel 
>>>>>> <[email protected] 
>>>>>> <mailto:[email protected]>> wrote:
>>>>>>
>>>>>>     Hi Victor ;-)
>>>>>>
>>>>>>>     UserSelector field actually stores usernames (which could be
>>>>>>>     email addresses depending on your Tiki setup)
>>>>>>
>>>>>>     I don’t use email.
>>>>>>
>>>>>>
>>>>>>     Field 179 is the item link with the preselect rule, and it
>>>>>>     stay locked on the first item found (lower id)
>>>>>>
>>>>>>     <Screen Shot 2021-08-11 at 19.10.24 .png>
>>>>>>
>>>>>>
>>>>>>     <Screen Shot 2021-08-11 at 19.13.46 .png>
>>>>>>
>>>>>>
>>>>>>
>>>>>>     Shouldn’t it work ?
>>>>>>
>>>>>>     Bernard
>>>>>>
>>>>>>
>>>>>>
>>>>>>>     On 11 Aug 2021, at 17:14 , Victor Emanouilov
>>>>>>>     <[email protected] <mailto:[email protected]>> wrote:
>>>>>>>
>>>>>>>     Hi Bernard,
>>>>>>>
>>>>>>>     UserSelector field actually stores usernames (which could be
>>>>>>>     email addresses depending on your Tiki setup), so if you
>>>>>>>     preselect something, that should be based on usernames, not
>>>>>>>     actual user ID values. Otherwise, some kind of mapping must
>>>>>>>     be done between usernames and user ID values.
>>>>>>>
>>>>>>>     Regards,
>>>>>>>     Victor
>>>>>>>
>>>>>>>     On 8/11/21 4:28 PM, Bsfez Tiki wrote:
>>>>>>>>     Hello (Victor ;-)),
>>>>>>>>
>>>>>>>>     I finally understood why I couldn’t work anything using the
>>>>>>>>     item link preselect thing.
>>>>>>>>
>>>>>>>>     It seems it work with a text field something I never
>>>>>>>>     attempt or needed.
>>>>>>>>
>>>>>>>>     I always tried to use it with user selector field where I
>>>>>>>>     guess it can’t "find" the other tracker value (the string
>>>>>>>>     in the field) but the look through the "link reference"
>>>>>>>>     values list.
>>>>>>>>
>>>>>>>>     IE: looking for "123" instead of  "Bernard".
>>>>>>>>     <option value="123" selected="selected">Bernard</option>
>>>>>>>>
>>>>>>>>     Does anyone has a trick so the preselect is made using a
>>>>>>>>     user selector ?
>>>>>>>>
>>>>>>>>
>>>>>>>>     Bernard
>>>>>>
>>>>>>     _______________________________________________
>>>>>>     TikiWiki-devel mailing list
>>>>>>     [email protected]
>>>>>>     <mailto:[email protected]>
>>>>>>     https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>>>     <https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel>
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> TikiWiki-devel mailing list
>>>>>> [email protected]
>>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>> _______________________________________________
>>>>> TikiWiki-devel mailing list
>>>>> [email protected] 
>>>>> <mailto:[email protected]>
>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>
>>
>
>
> _______________________________________________
> TikiWiki-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel