Rambling Pete's Quick examples

Explore

Archiving and "Freezing" links and formulas in Tables - In progress

Archive Examples

⁠

If you find this document useful, please consider buying me a

Ko-fi here.⁠

⁠

Click on the Delete row button to simply delete a row from the table.

Click on the Move to Arc button to move a row from arcData table to arcArchive, and then to delete the row from the original arcData table. Move to Arc contains two steps in a runaction() formula. The first action copies the row to the arcArchive table, the second action deletes the row from the arcData table (The runaction() formula is necessary to ensure 100% that the two actions are executed in the correct sequence.)

Click on the Archive check box to trigger a row-based automation. This will activate the Auto Move button, and trigger the row-based automation to execute the runactions on the Move to Arc buttons. (I have used row-based, so that you do not need to wait for the time based trigger to come around when you try out this document.

For both of the moves note that the columns Lookup Value and Formula retains their type.

For further info on Automation check out the video below.

⁠

This link can't be embedded.⁠

arcData

arcData

Name

Lookup Value

Formula

Archive?

Delete row

Button Move

Auto Move

Record 1

Value 1

Record 1

@Value 1⁠

⁠

Delete row

Move to Arc

Record 2

Value 2

Record 2

@Value 2⁠

⁠

Delete row

Move to Arc

Record 3

Value 1

Record 3

@Value 1⁠

⁠

Delete row

Move to Arc

Record 4

Value 2

Record 4

@Value 2⁠

⁠

Delete row

Move to Arc

There are no rows in this table

⁠

arcArchive

arcArchive

Name

Lookup Value

Formula

There are no rows in this table

⁠

arcLookup

arcLookup

Name

Value 1

Value 2

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.