Sounds cool. Going to try this out now.
I figured out the Company (customer) and adding the company ID into the user part to accosiate the user with its company part, and I then wrote the Company ID from the user table into the orders that they placed on the front end so that the users can see only the orders for their companies.
Let me try the suggestion for admins to then see all records.
So I get this to work when I manually add these values.
Whn i do try to do this dynamic via an action it keeps adding the user email address instead of the Company ID
Okay. I think your problem there is that you are trying to set those values using an onSubmit action with a form. What you should do instead is pass the values as column values with the form itself. Review the below docs.
Yeah, if you create a row and immediately are not the owner of that row (On Submit happens AFTER the row is created), then I think Glide will automatically insert the signed in user’s email into any row owner columns so the row doesn’t become orphaned with no row owner.
So instead of pushing info after the record is created I should pull the info as the record is opened, or rather when the user hits the add new order button?
No, you should set the owner values when the form is submitted - but not using an onSubmit action.
Check the document that I linked you to - it explains how to do that.