Features / Usability

Features / Usability

Re: Can Tracker do m:n relations?

posts: 289 United States

I don't believe so. Trackers do not have the notion of a pool of values of which you can take only 1 instance, such that once it is taken another user must select a different value. If you need something like that then you really need a proper database.

Trackers are really meant for linear data, although they have one or two dynamic capabilities such as:

  1. If value W is selected in field 1, then values X,Y or Z can be selected in field 2.
  2. Limited calculated fields (take values from fields 1 and 2, then sum them together).

The first example is sort of along the lines of what you want to do but there is no notion that X,Y or Z are "taken" by a user and so not available to another user.

I hope this post makes some sort of sense, if not I'd be happy to try to explain further but essentially it sounds like what you're trying to do is too complex for trackers if you're trying to do some kind of user assignment without the possibility of repeats or duplication.