Hi glide community, I’m new here and I want to create such an public app with conditions below:
this app should be accessed with employee ID and password
every employee ID is a PIC of every site/store, I stored this data in another table
since one ID is a PIC of only one site, the data showed should only accesible by employee ID from related site.
the data showed is the stock of the related site
for example, I have stored that employee ID 000123 is the PIC of store X987 (stored in table USER). then I want to show on my Glide app the inventory of only related store, therefore when user sign in with ID 000123 the data showed only the inventory on store X987 (can’t show data from another store).
thank you for all help. previously I work with Appsheet but I saw Glide as a better opportunity to increase work efficiency.
thank you for your answer.
I’ve just read the topic about relation, and nearly done to make the data accessible only to tthe related PIC.
one more question, can we adjust the form in Glide screen, so the user can only edit some row?
for example I want to show the stock name, stock code and quantity. but I want to lock the stock name and stock code column, so the user can only edit the quantity column in form.