Custom (form) view that is linked to a specific row

[Caolanmcd]

I have a project on the go that has a Google Sheet with Equipment information such as Sensor Type, Brand, Serial No., Status and Location. Equipment will be moved from location to location and status may change. 

The idea is to have a custom view (probably a form) that you are brought to by a QR code that asks Yes/No questions (could also be enum) that would work similar to this

I decided to try this as a form view from "edit" in details page before QR integration

"Do you want to move equipment?" If Yes (Location = X) If No (nothing), "Do you want to report a fault? "If Yes, add comment box (Status = Fault) If No (Status = functioning)

I've added columns to the sheet that ask these questions, set these columns to Yes/No or Enum and then added expressions in the formular tag to set "location = x" but the form I am brought to when I "edit" from detail view MIGHT show me these specific columns!? Sometimes the show up, sometimes they don't and then my formula expression doesn't work. 

Please Help

[Caolanmcd · Accepted solution]

Found a fix