Archive Doc
Share
Explore
Imported Source Table

icon picker
Archive Source Table

These are all the archived rows. To access the columns of a particular row, you can use the formula ParseJSON.
E.g. here’s what it’s like to get the Row Url column and the Date column:
ezgif-4-1e295e021426.gif

Row Url

thisRow.[Row Contents].ParseJSON('RowUrl')
Notice that all spaces are removed

Date

thisRow.[Row Contents].ParseJSON('Date.epoch').EpochToDate()
Notice that we first have to grab Date then the epoch field that’s inside Date.
Not sure what fields you have? Use this website to make your JSON fields easy to read:
Loading…
Once a row is archived, we can tell the source doc it’s ready to delete by exporting it:
Archive Source Table
1
There are no rows in this table

Share
 
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.