Skip to content
Rambling Pete's Quick examples
Overview of Examples
Introduction - Extended Formula Help
Table Joins
Bi directional table links
Using buttons to Update tables
Performance
Sundry tips - Responses to Community Questions
Wiki-like behavior
Integration with Google Docs, Slides
Archiving and "Freezing" links and formulas in Tables - In progress
Locking as in WorkCommit
Scratch
More
Share
Explore
Sundry tips - Responses to Community Questions

Cycle through a list with a button

Link to Community post
Rotating list of Assignee's
⁠
⁠
There are three aspects to this
Getting a sorted source list : Table tabPeople, column Rank by Surname
image.png
⁠
⁠
Cycling through the source list:
⁠
image.png
⁠
⁠
Displaying the Responsible Person’s surname:
image.png
⁠
⁠

Task list with Resp Pers
0
Name
Responsible person
Cycle Button
Sequence Status
1
Task 1
Hoogenboezem
Cycle Person
1
2
Task 2
Smith
Cycle Person
4
3
Task 3
Jones
Cycle Person
2
There are no rows in this table
⁠


View of tabPeople
2
colIDPeople
colSurname
colName
colState
Country
Rank by Surname
Rowid
1
ID005
Hoogenboezem
Kryn
South Holland
The Netherlands
1
4
2
ID003
Jones
Dick
NY
USA
2
2
3
ID004
Poggenpoel
Jan
Mpumalanga
RSA
3
3
4
ID001
Smith
John
GA
USA
4
1
5
ID002
Williamson
William
England
United Kingdom
5
5
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.