AnsweredAssumed Answered

How to direct to new layout if monthly data changes

Question asked by springer01 on Jan 15, 2019
Latest reply on Jan 17, 2019 by user17152

In FMP12 I have a Body layout sorted by month of Assets by several categories, one of which is "Family Trust Investments". In that category I had a Fund VTSMX, which was sold in August and replaced with POSKX, each with fields with the names of the fund, nbr of shares. price and current balance. If I create a new layout w/ the new name and accompanying data, how do I write a script which says: If: d_date is greater than 08-31-18, go from layout "Family Trust 01" to layout "Family Trust 02" and the attendant field(s)?

Here is a partial of the current Layout:

Family Trust.png@

Attachments

Outcomes