Right now, you can’t open a row with a button. You can either click the “Expand row” icon on the far left of the row, or you can press
option + space on the keyboard. Sometimes, though, it might be useful to open a row when you click a button, especially if you’re pairing it with other buttons in order to perform simultaneous actions.
Until we add that to the product, here’s a (albeit hacky) way to open a row with a button:
Step 1: pull in the full URL of a popped-open row. Make sure to put it in quotes to prevent the table from autocompleting to a lookup column:
Step 2: Break apart the URL into 3 different sections: base URL + row ID + tail piece
The number after the “/r” is the row ID, and the tail is everything after the row ID:
Step 3: Concatenate all the pieces together using the CONCATENATE() formula:
Step 4: Replace the hard-coded Row ID with the formula ROWID():
Step 5: Remove the quotations from the beg of the base and the end of the tail, and then make the base and tail URL’s formulas so they auto-populate:
Step 6: Add a button and choose the action “open hyperlink”. For the URL field, select the Concatenate column:
Ok, phew that should be it. Congrats for making it through all of those steps! Now that you have this button that opens a row, you could also create another button that, for example, modifies the same row. Then, create a third button that pushes both of the buttons.