Skip to content
REFERENCE

U.PUB_SNAPSHOT

Summary

Helper method used to create properly formatted metadata that, when present, results in the capture of date-stamped snapshots of published reports

Syntax

=U.PUB_SNAPSHOT([rollover_time], [days_forward], [metadata])

Parameters

Parameter Required Description
[rollover_time] No If set, the datestamp applied to publishes occurring after this specified time will be the following weekday by default
[days_forward] No The number of days forward to roll the snapshot date. If not set, by default the snapshot is rolled to the next weekday. Only meaningful of rollover_time is set
[metadata] No Additional metadata to be applied to report being published; can be selected from multiple ranges. If specified this metadata is combined with the pub_snapshot metadata into a single list of metadata entries

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.PUBLISH(F188,F189,B188:C190,U.PUB_SNAPSHOT(,,B194:C196))

=U.PUBLISH(F193,F194,B188:C190,U.PUB_SNAPSHOT(F195,F196,B194:C196))

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.