I have improved my Vibe Log self-help App by adding [Exactly what I want], [Exactly what I want-Noon] and [Exactly what I want-Night]. The plan is for User to write their life goals in [Exactly what I want] and then [Exactly what I want-Noon] Initial Value will = [Exactly what I want], and then [Exactly what I want-Night] Initial value will = [Exactly what I want-Noon]
My Initial Value for [Exactly what I want] is the below formula that will grab yesterday’s [Exactly what I want-Night] so that I will always keep cascading the latest life goals displayed to the User for them to read aloud in the Morning, Noon & Night, to keep User motivated and on track with their life goals.
[Short date] is just today’s Date.
ANY(
SELECT(
Activity Diary[Exactly what I want-Night],
(([_THISROW].[Short date] - 1) = [Short date])))
My question is… is it possible to get the Initial Value in [Exactly what I want-Noon] and [Exactly what I want-Night] to update with each Sync throughout the day, so that if/when I change the life goals on the fly in the middle of the day my life goals in [Exactly what I want-Noon] and [Exactly what I want-Night] will automatically and immediately update?
I just added this system to my App, and when I wrote my life goals to the [Exactly what I want] column and Synced, it did not automatically add that to the Initial Values in [Exactly what I want-Noon] and [Exactly what I want-Night] columns. I expect the App do do this tomorrow when I add a new day/row to the App, but if/when I change my life goals in the middle of the current day/row, I would like very much to have the App update [Exactly what I want-Noon] and [Exactly what I want-Night] during the current day/row whenever the App is synced, which will happen a lot throughout the day. Thank you very much!
Okay excellent advice, ty! I’ve never used Reset on edit? before, handy. I found this setting under Update Behavior for each column. I left it OFF for my morning column [Exactly what I want] because if I change these life goals today, I don’t want the morning column to reset to the data from yesterday’s Night column with the next Sync.
I changed Reset on edit? to ON for the Noon & Night columns and it seems to be working as I want now, ty, this life goal reminder is a big improvement to this incredibly useful App! See my update below, I had to remove the Reset on edit?.(The ANY SELECT formula in my original post above works perfectly to pull the data from yesterday to today.)
I am considering making my morning column un-editable using ISBLANK so that it will always reflect the data from yesterday (for purely historical reasons), forcing me to make life goal changes only in the Noon and/or Night columns.
But this leads to another consideration that I might need/want for my Noon & Night columns… a formula in the Reset on edit? or Initial Value that would function to keep both the Noon & Night columns coordinated to the latest data/changes, but this sounds tricky and “heavy.” For example, since the User can go back and access & change the data in either the Noon or Night columns (Quick Edit) at any time, if they change their life goals in the Night column, but then go back at some point and adjust the Noon column in any way, that could then possibly update the Night column with different data that they may not want, or eliminate some change/data that they do want to keep.
I suppose that the most simple set up for this potential cascading-data conundrum would be to make both the morning and Noon columns not editable, forcing User to always/only update their life goals at Night, just before going to bed. This seems limiting, but might be the best set up, and I like Simple.
After playing with this, I have to change the setup from the Solution, because with Reset on edit? set to ON for my Noon column, when I make a change to life goals in Noon, it then reverts to the data in the morning column, and then with Reset on edit? ON in the Night column, it also does the same thing, which actually works opposite to what I need.
I suppose that I could set up [_THISROW_BEFORE] [_THISROW_AFTER] formulas, but that might be overly complicated for this.
So I think that I will just stick with a very simple no edit in Morning column, no edit in Noon column, cancel all Reset on edit? forcing all life goal changes to only be allowed in my Night column. Then, the next day Morning & Noon column would pick up any edits in yesterday’s Night column.