Quite new to Tadabase (although I’ve been watching its development with interest for some time) and I’m struggling with the following:
I have a multi-tenant app, and each of my tenants can also create customer users which is connected via a “company” table (so a tenant of the tenant), so that their customers may access some basic pages of their orders. At the moment this mainly works fine, but when using a new user form to add a new company user, I can only get the connected “company” field to either show all companies in the system (ie not just the logged in tenants customers but all customers of every tenant), or none at all. Everthing else appears to work great in this tenanted system, except when I come to create a new user within a company, which is within a tenant.
I’ve been playing around with the “limit to” and “show records” options for days now, but just can’t get it to work. Can anyone tell me what I’m missing?
Not knowing how you have your databases configured it is a bit difficult to address your needs.
I’ve been where you are now…brand new to TB. Therefore, if you would like to jump on a Zoom or other virtual call, we can brainstorm on your app. The only thing I ask in return is to provide the TB Community any useful info for future Community members to be able to use.
Send me a private message if you are interested and we can link up.
I’ve had to overcome this exact same scenario and I came up with a workaround for it. What I did to make this work was created two-step process for the form.On the first page, add the form with nothing on it except for the company connection and hide it and then name the button “add new user”. Then add form rules to connect the logged in user company to that company field connection.
Now on a new page create a new form with the rest of the details you need to gather for the new user. Then return to the first form and have it redirect to the second form on submission.
Hopefully that makes sense to you, if not let me know and I’ll see if I can put together a quick video for you.
@SafetyUniversity thank you so much for the invite to a zoom call, I have much in the pipeline so will be in touch.
@SuiteUpstairs again, thank you, but I am still struggling here. If you did have the time for a quick video it would be hugely appreciated; I have battled for a few more days to try and conquer this on my own, but its still not right. Very annoying when everything else seems to be so smooth.
