Hi everyone. Ive been racking my brain a while, and i cant find any documentation, although im probably not the first to look for this issue.
My app logs information about fryer oil.
Data:
I have a table with a list of fryers: Row ID| Fryer Name| Company Name| Photo. I have another table that will store the data from the fryers (Daily Input): Row ID| Name (user email)| Date| Company Name| Branch| Fryer| TPM| TPM pic.
Each user has a company name (i.e. McDowells or Patty Queen), and a branch (NYC, MIA, LA, etc). Each fryer has a company name that is related to a company name table. Branches are also related to the company name from a “Branches” table.
Layout:
I have a tab with fryers (list). The list is filtered according to the user (a McDowells employee will only see their fryers). When a fryer is clicked, it sends the user to a form (called Daily Input Form), where the user will enter the TPM and take a pic of the TPM reader (something my company does, not really important, its just a number for argument sakes). I would like the Daily Input table to autopopulate the fryer column according to the fryer that was clicked.
Hope this makes sense.
TIA