Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an App (February 2021 version) with many sheets thet show differnt aggregation of same details Data. Data of dettail are showed in one sheet. In every sheet I have inserted a button that allows to navigate to details sheet. I would Like insert a button in the detail sheet to go back to the starter sheet. I have tried to use a Variable that is set in starter sheet, but the solution seems not working.
Do somebody have any suggestions ?
Thanks,
Michele
In the button that navigates to the Details sheet, add 2 actions. In the first action set the variable (vSheetID) to the current "Sheet ID" (Sheet1).
In the second action, activate the Details sheet
On the Details sheet, in the button that navigates to the previous sheet add the "Activate Sheet" action with this formula: ='$(vSheetID)'
In the button that navigates to the Details sheet, add 2 actions. In the first action set the variable (vSheetID) to the current "Sheet ID" (Sheet1).
In the second action, activate the Details sheet
On the Details sheet, in the button that navigates to the previous sheet add the "Activate Sheet" action with this formula: ='$(vSheetID)'