I am trying to write a formula to link to a form slice I’ve made. However I am running into 2 problems with the following action formula:
=LINKTOFORM(“Off Rent Request”, “Equipment ID:”, [Equipment ID:], “Approval Status”, “Transfer Requested”)
First problem being Equipment ID isn’t locked (They can change the info there, I need it to be locked, but showing what was on the previous page). Second problem being I need the approval status to be filled in with “Transfer Requested” even though I’ve got that column hidden in that slice. Is that possible?