I have three table :
Table one 【member data】
which have
{start date}
{end date}
{single linked to weekly summary}
table two【activities】
{date of activities}
{multiple linked to weekly summary per person}
table three 【weekly summary per person】
{week ...
I tried to use rollup function to got previous data in the same table as below
First, I make the lenth of one field to be the same.
IF(LEN({TargetField})>10, LEFT({TargetField}, 10), {TargetField}&REPT("_", 10-LEN({TargetField})))
Then in a linked fi...
Thanks, it works
Here is what I do to make this
let a record of weekly note show the note of last week as reference.
Add a string that is unique to the beginning of this week’s note
For example first field of this recored - {Name}
Formula =
{Name}&{...
