I wish to show on a Page/SubPage when and by whom the last update/modification to that particular page or subpage has been done. Modified() and ModifiedBy() seem to be just what I need, but I can’t seem to find anything other than tables in the list of Coda objects when trying to implement this. How can I call Modified() or ModifiedBy() on a Page/Subpage ?
From what I can tell there is not a way to reference a page in the Modified() or ModifiedBy() formula even though the formula documentation indicates that you can reference the page object:
I did a few searches of the community and I see that other users are requesting the ability to reference pages as objects so that leads me to believe that perhaps the formula documentation is not correct in listing pages as a valid object. Perhaps @Al_Chen_Coda might have some better insight?
The thread I am referencing is here:
That being said - I am sure there is a solution to achieve your desired results. Is it possible for your use-case to use a table for input instead of directly on the page? If so, you can track when the row of a table is modified and can reference that on the page itself.
I have a doc for a daily updates from my team (think SCRUM standup). They enter their responses on a table - I have formulas set up on a page to make things look nice and include the date/time they submitted their answers to me (along with a button to email the page to myself). I know I can reference the page object using the button that emails the doc to myself but can’t seem to get a page object to show up in the Modified() or ModifiedBy() formula.
This feature is on our roadmap! Currently you can’t reference a page in a formula (the exception being a button that can email out a page as @James_Eades pointed out). You can, however, reference
thisDocument to see when the entire doc was last modified.
Thanks for the replies, I’m glad to hear it’s on the roadmap
I noticed that tables or thisDocument can be used, but unfortunately that still doesn’t quite work for us as we would like to use this feature to know who made the last changes to a certain page/subpage (and when). This is because we document a specific part of our code/data on a page or subpage, and they don’t necessarily contain any tables.
But the button thing might be useful in the meantime, though, so will look into that!
This is a bit of a “hack” that might possibly achieve what you are looking for:
The above example has a page set up with a table that has 3 columns and 1 row. The only visible row is for whatever content you would want to be edited and tracked by the other two (hidden) columns for Modified() and ModifiedBy()
The cell can be expanded to use Rich Text: Launched: Ability to expand cell for better writing
And buttons can be created to expand the cells if the keyboard and gui shorcuts are problematic:
Using this table method, you could even have multiple sections on a page that you can track history on.