Effortlessly craft a personalized calendar within minutes, providing you with a seamless solution to manage and monitor dates and events in your application.
With the “Calc” sheet open, click “Add Page” and select “Report”.
Set “Title” to “Client Data”.
Change “Source” to “Range of Cells”, and set the ranges to “A$4:$Q$63” by selecting the range of cells and clicking the clipboard icon.
Set “Header” to “None (automatic)”.
Click “Save and Exit”.
Create a Data Filter page:
With the “Calc” sheet open, click “Add page” and select "Data Filter".
Change “Source” to “Range of Cells”, and set it to “$A$1:$A$2”.
Set “Header” to “Use First Record”.
Go to "More" tab and ensure “Match fields by name” is selected.
Click “Save and Exit”.
Create an Edit Record page:
Go to “Data” sheet, click “Add page” and select "Edit-Record".
Set “Title” to “Change Client Data”.
Set “Source” to be the table “Client_List”.
Click “Save and Exit”.
Create a Form page:
Click “Add Page” and select “Form Page”.
Set “Title” to “Client Input Page”.
Click “Save and Exit”.
Create a Layout Container page:
Click “Add page” and select “Layout Container”.
Set “Title” to “Client Dashboard”.
Set “Columns” to 1.
Select “Data Filter Page” and “Report Page” in the drop-down list.
Click “Save and Exit”.
Create a Tabs Container page:
Click “Add page” and select “Tabs Container”.
Set “Title” to “Dashboard”.
Select “Client Dashboard (Layout Container)”, “Client Data (Report)”, “Change Client Data (Edit-Record)” and “Client Input Page (Form)” in the drop-down list.
Click “Save and Exit”.
Optional: Hide everything except the Tabs Container page from the navigation menu by hovering over each page, clicking the gear icon, and selecting “Hide”.
Optional: For each page go to the "More" tab and uncheck “Show Page Title” box.
With the “Attractions” sheet open, click “Add Page” and select “Report”.
Click “Save & Exit”.
Create a Map page:
With the "Attractions" sheet open, click “Add-Page” and select "Map”.
Set “Title” to “LONDON”.
Set “Titles (Optional)” to “Range of Cells”, and set the ranges to “Attractions!$C$2:$C$200” by selecting the range of cells and clicking the clipboard icon.
Set “Locations” to “Attractions!$E$2:$E$200”.
Set “Colors (Optional)” to “Attractions!$M$2:$M$200”.
Click “Save & Exit”.
Create a Details Report page:
With the “Attractions” sheet open, click “Add-Page” and select “Details Report”.
Set “Title” to “Attraction”.
Under the “More” tab, set “Details Template” to “AttractionsLayout2”.
Set “Columns to display in list view” to “Attractions!$A:$J”.
Click “Save & Exit”.
Create an Edit-Record page:
With the “Attractions” sheet open, click “Add-Page” and select "Edit-Record”.
Set “Title” to “Trip Editor”.
Under the “More” tab, set “Editable Template to “EditTripLayout”.
Set “Columns to display in list view” to “Attractions!$A:$H”.
Click “Save & Exit”.
Create a Layout Container page:
Click “Add-Page” and select “Layout Container”.
Set “Title” to “BUCKET LIST”.
Set “Columns” to 1.
Select “LONDON (Map)” and "Attraction (Details Report)" in the drop-down list.
(optional) Under the “More” tab uncheck “Show Page Title”.
Click “Save & Exit”.
Optional: Hide “Report Page”, “Attraction” and “LONDON” pages by hovering over each page, clicking the gear icon, and selecting “Hide”.
Click the “Sheet” button to change the “Source” and choose the “Tbl_Questions” Table.
Change the “Enter Details Drilldown Screen” to “Enter When Selected”
Click on the “More” tab.
Under the List Screen, change the “Template for Each Item” to the “QuestionsItemLayout” sheet.
Under the “Details Drilldown Screen”, change the “Details Template” to “QuestionsDetailsLayout” screen.
Click on the “Field Rules”
Set the “Question ID” field to “Restrict User Input” and choose “Auto-Increment”
Under Experimental Content:
Select “Add Nested Child”
Change the title to “Answers”
Set the Source to the “Tbl_Answers” table
Set the ID to “A (Question ID)”
Click “Close”
Set the ID Field on the main sidebar to “A (Question ID)”
Click Save
Click the Back Arrow
Create a Text Page
Click “Add Page” and select “Text”.
Set the Title to “Win”
Set the Text to “Correct!”
Click Save
Click the Back Arrow
Create a Text Page
Click “Add Page” and select “Text”.
Set the Title to “Lose”
Set the Text to “Wrong!”
Click Save
Click the Back Arrow
Create a List Management Page
Click “Add Page” and select “List-Management”.
Set the Title to “Test”
Set the Source to the “Tbl_Test” Table
Click on the “More” tab
Under the “Details Drilldown Screen”, change the “Details Template” to the “TestDetailsLayout” sheet
Click on “Field Rules”
Add a rule to the “TestID” and select “Restrict User Input”. Select “Auto-Increment” from the dropdown menu.
Add a Rule to “QuestionID” and select “Fill on Save”. In the first dropdown menu, select “Fill with value computed by this formula” and input the formula: RANDBETWEEN(MIN(Tbl_Questions[Question ID]),MAX(Tbl_Questions[Question ID])) into the input box. Select “Add” from the second dropdown menu.
Add a rule to “Submitted” and select “Fill on Save”. Select “Logical” from the first dropdown menu, choose “FALSE”, and select “Add” from the second dropdown menu.
Add a rule to “Submitted” and select “Fill on Save”. Select “Logical” from the first dropdown menu, choose “TRUE”, and select “EDIT” from the second dropdown menu.
Click on “None” next to “Redirect or Refresh” and select “If Form Successfully Submitted”
Choose “Custom Formula”
Add the formula: IF(CASTLASTVALUELOCATION(Tbl_Test[Submitted]),IF(CASTLASTVALUELOCATION(Tbl_Test[Correct]),CASTPAGELINK(,CastPages[Win]),CASTPAGELINK(,CastPages[Lose])),CASTPAGELINK(,CastPages[Test])) to the input box.
Click “Save”
Click the Back Arrow
Add a Menu Page
Click “Add Page” and select “Menu”.
Change your Source and select “Auto Create New”
Remove all of the values from the MenuLayout sheet except “Daily Trivia” and “Questions”