Glide will see your results as non user-specific and I assume that’s not what you want.
I think what you can do is add a user-specific completion date column, then use the Math column of Glide to derive the “Next Scheduled” date.
How you get that formula to work will be the main problem. I assume next week means 7 days after the completion date, next month means the same day of next month after the completion date (this is a bit tricky), and next year means the same day of next year?
In the photo, i have both the google sheets tabs (which work for just me), and also the user-specific glide data columns (next due and completed to the right of it) The user data column works when i view as myself, but when I view as anyone or a made up user it doesn’t auto-populate the Next Due date. I used the math function and i used the frequency column in days (math: completed+frequency)
If i left the google sheets as is (without the data editor glide columns) having the user profile tab with a row owner by email and each row here having it’s own ID, SHOULD IT technically work with each user being specific?
the frequency day isn’t; just the completed and next scheduled are. I saw i deleted that; but the user-specific “next due” doesn’t show up as a data option for the column of “next scheduled”. it only allows me the google sheets choice; BUT if I clear the date (and have the next due as a placeholder) it then defaults to the correct next scheduled date since it points to the placeholder.
It also works in the “fields” display and lets me use it as a data option as well as an option to show in the main collection. I just can’t get it to show as data for the button in the details page.