Re: How to use Tracker Field Relations
Bsfez Tiki <[email protected]>
| Newsgroups | gmane.comp.cms.tiki.user |
|---|---|
| Message-ID | <[email protected]> |
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]> 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 <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 <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] > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users _______________________________________________ TikiWiki-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/tikiwiki-users