Format rule for records of one table using timestamp (or date) of activity from another table?

[ten4info]

If I have a master table of information that is my “master DB” with an activity table that is then connected to the unique records of the master DB, how can I setup a format rule to color code (red, yellow, green) the record lines of the master DB based on the date timeline (or touches) from the activity records?

Can this also be done is I have some toggle fields in the activity form that could tell the records in the master DB to be formatted a color based on that information, think a red record if the do not call toggle is selected.

Thanks.

[Steve]

ten4info:

or touches

What does this mean?

[ten4info]

Touches being based on the date of interacting with the record as inputed in the activity table.

[Steve]

Like this?

IN(TRUE, [Related Activities][Do not call?])

See also:

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

help.appsheet.com

IN()

Is item in list?

[ten4info]

@Steve greek to me at this point! Any better examples or videos that might help?

[Steve]

ten4info:

Any better examples or videos that might help?

Nope.