I’m building a SaaS using backendless as a admin dashboard and I share it’s database with appgyver for a mobile app. I have 2 databases, 1 it’s for client/company preferences where I define departments and another for personalized items. I’ve associated each item with a client but I want to categorize them by using the departments defined in the other database and choose from the ones defined for that client.
Client 1 has 3 departments, A, B and C
Client 2 has 4 departments B, C, D and E
when i create an item for client 1 I want to only have A B and C available.
I’ve tried using data object relationship but when I select the departments I get this error “Exceeded the maximum length”
If you create a column with Multiple Choices and add a Value string longer than 250 characters, you will get an error because the default maximum length is 250. You can change the maximum length to 500 characters.