Re: How to use Tracker Field Relations

Hi,

Thank you very much for your answers so far;

> (how can I not answer to a case related to Nintendo and Woodworking ?) 😂
Glad you liked it! :-D

> May be 2 dynamic list (one after the other) won’t work fine
Yeah I think I've seen a bug report stating the same thing, and I've had 
this problem too with other trackers.

> you should be able to use instead of the dynamic list field an item 
> list or item link field.
Not sure how I can achieve this by means of item list/item link but I'll 
give it a try!

Thank you :-)

Alessandro Martinelli


Il 13/08/2020 13:00, Bsfez Tiki ha scritto:
> Re-reading;
>
> May be 2 dynamic list (one after the other) won’t work fine (I had 
> issues a few times with that) but you should be able to use instead of 
> the dynamic list field an item list or item link field.
>
> I would need to put my hand under the hood to tell you more. That's 
> how I'am.🤗
>
> Bernard
>
>> On 13 Aug 2020, at 13:22 , Bsfez Tiki <[email protected] 
>> <mailto:[email protected]>> wrote:
>>
>> Hello Alessandro,
>>
>> (how can I not answer to a case related to Nintendo and Woodworking ?) 😂
>>
>> Not sure if you can achieve this with the relation field…
>>
>> Using the dynamic list field you can have on item creation a list of 
>> items from another tracker using the user or the machine as matching 
>> value you will select.
>> You should be able to cascade fields like:
>>
>>>  - *Customer* (choosen from the list) --> [Mario, Luigi], I select Mario
>>>
>> Item link to the tracker customers
>>
>>> - *Machine Types* Table, with the type of machines (Log Saw, 
>>> Embosser, Unwinder, Rewinder)
>>>
>> Dynamic item list to the tracker Machine with for matching value the 
>> customer
>>
>>> - *Machines Sold* Table: <Customer, Machine Type, Machine Serial 
>>> Number>.
>>>
>> Dynamic item list to the machine sold with for matching value the machine
>>
>> Theoretically this should work (may be with some adjustment) but 
>> that’s how I’ll start with this use case.
>> https://www.bernardsfez.com/article46-Tiki-Trackers-ItemLink-ItemList-and-Dynamic-ItemList-field-types
>>
>>
>>
>> About the relation fields I miss the part where you filter your 
>> relations to items dynamically (look for the items related to on the 
>> fly… before saving the item).
>> But may be someone will come up with more about this ? ;-)
>>
>> Bernard
>>
>>
>>
>>
>>> On 12 Aug 2020, at 15:31 , Alessandro Martinelli 
>>> <[email protected] 
>>> <mailto:[email protected]>> wrote:
>>>
>>> Hi,
>>>
>>> I'm here for trackers again :)
>>>
>>> I need to populate a field in the following way:
>>>
>>>
>>> Assume we have
>>>
>>> - *Customers *Table, with the list of customers;
>>>
>>> - *Machine Types* Table, with the type of machines (Log Saw, 
>>> Embosser, Unwinder, Rewinder)
>>>
>>> - *Machines Sold* Table: <Customer, Machine Type, Machine Serial 
>>> Number>.
>>>
>>>
>>> So we could have for example
>>>
>>> <Mario, LogSaw, 16125>
>>>
>>> <Mario, Rewinder, 16826>
>>>
>>> <Mario, LogSaw, 18152>
>>>
>>> <Luigi, Embosser, 19642>
>>>
>>>
>>> So when I create a new ticket, regarding a single machine belonging 
>>> to a given customer, I'll be requested to fill:
>>>
>>>     - *Customer* (choosen from the list) --> [Mario, Luigi], I 
>>> select Mario
>>>
>>>     - *Machine Type* (choosen from the subset composed by machine 
>>> types the given customer owns, so I use a Dynamic Dropdown) --> 
>>> [LogSaw, Rewinder], I select Log Saw
>>>
>>>     - *Machine Serial Number* (automatically filled: it should be a 
>>> dropdown automatically filled selecting the following values:
>>>         "SELECT MachineSerialNumber FROM MachinesSold WHERE Customer 
>>> = SelectedCustomer AND MachineType = SelectedMachineType). --> 
>>> [16125, 18152]
>>>
>>>
>>> Is there a way of achieving this, maybe by means of Relations? I've 
>>> taken a look at this page 
>>> http://doc.tiki.org/Relations-Tracker-Field but it is not enought 
>>> for me.
>>>
>>> Thank you in advance,
>>>
>>>     Alessandro Martinelli
>>>
>>> _______________________________________________
>>> TikiWiki-users mailing list
>>> [email protected] 
>>> <mailto:[email protected]>
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
>>
>> _______________________________________________
>> TikiWiki-users mailing list
>> [email protected] 
>> <mailto:[email protected]>
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
>
>
>
> _______________________________________________
> TikiWiki-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users

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