Go to record on cell click

[Gaius]

Hi!
I have a table where the columns are dates and the rows are particular groups. Each cell shows an inspection done by that group on that date (pass/fail info). This table is generated in a Google Spreadsheet that references the other imported Google Sheets dynamically, always showing the last 5 weeks.

What I’d like is when a user clicks on the cell, it takes them to the inspection done by that group on that day. This way they can easily see the details of why that inspection failed on that particular date.

I have a lot of vague ideas on how to do this by reading other topics, but could still use a push in the right direction.

Any advice or guidance would be great! Thanks.

[Lynn]

Best Way to Setup my Google Sheets? Questions

[Gaius · Accepted solution]

After a lot of work, I think I figured it out…or at least a workaround.

I created a Virtual Column of type App. I then used the LINKTOROW() function to tell it which record to go to (in this case, I wanted it to go to the “Lab Inspection_Detail” view matching the [0 Key] column). If there is nothing listed in the [0 Key] column, I placed a “#” in the column, and in these cases, I link instead to the form (using the LINKTOFORM() function) pre-filled in with the necessary columns.

Then I made sure that the App column was next to my column of interest in the table view:

This isn’t ideal, but it’s a reasonable workaround. I still have some weird things I need to figure out, but I’ll do that in a separate post.