Hey all,
In one of my tables I'm trying to use an object to store 'tags'. What I'm attempting here is to allow the front-end to create unique entries that the company can use elsewhere in the application. Thanks to Ray Deck here for the recommendation.
Where I'm struggling at the moment is two fold:
The object is a list with 3 fields; integer (to be set automatically, incrementally), text, and enum.
There should only be one unique combination where the text (name) and enum (type) exist.
Example would be in this list for the company they could have combos:
URGENT : type1
URGENT : type 2
They should NOT be able to create the same combination.
The 'indexes' function does not show this object, so it seems like we're unable to index these objects within the database options nor can use the auto-increment option of indexes here.
Am I missing something or is it true that it would need to be handled entirely via the API instead?