![]() ![]() The familiar boolean operators AND, OR and NOT (also written &, || and !) are also supported but be advised that they do not honor the usual precedence rules, so parentheses should be used whenever multiple operators are used together. A phrase, surrounded by double quotes - "quick brown" - will search for all the words in the phrase, in the same order. Outputs an action (when run) which will create a duplicate page of page with the given name. This option is only used if duplicateOptions is not "CreateViews". If set to `None`, none of the rows will be included. If set to `Visible`, only visible rows will be included. If set to `All`, all rows including those hidden by a view will be included. It should be one of - All, Visible, None. ![]() rowOptions This parameter is used to specify which rows should be included. If set to "DuplicateTables", edits to views in the new page will show up in the original table, and other edits won't affect the rest of your doc. If set to "DuplicateData", edits to data in the new page won't affect the rest of your doc. ![]() If set to "CreateViews", edits to data in the new page will show up in the original tables too. duplicateOptions Behavior when the page has tables and views. copySubpages Whether to copy all subpages of page. parentPage The page to create the new page under. ![]() Optional Inputs name Name for the new page. Required Inputs page The page that will be duplicated. What are formulas? Writing formulas Video courses Base formulas Arrays All Any Contains ContainsAll ContainsOnly Duplicates First ForEach FormulaMap In Last List ListCombine Nth RandomItem RandomSample ReverseList Sequence Unique Collections Count CountUnique Find MaxBy MinBy Slice Sort Splice Dates Created CurrentTimezone Date DateTimeTruncate DateToEpoch Day DocumentTimezone EndOfMonth EpochToDate Hour IsoWeekNumber IsoWeekday Minute Modified Month MonthName NetWorkingDays Now RelativeDate Second Time TimeValue ToDate ToDateTime ToTime Today WeekNumber Weekday WeekdayName Workday Year Duration Days Duration Hours Minutes Seconds ToDays ToHours ToMinutes ToSeconds Filters AverageIf CountIf Filter IsFromTable Lookup Matches SumIf Info IsBlank IsDate IsLogical IsNotBlank IsNotText IsNumber IsText ToNumber ToText Logical And False If IfBlank Not Or Switch SwitchIf True Math AbsoluteValue Average BinomialCoefficient Ceiling Even Exponent Factorial Floor IsEven IsOdd Ln Log Log10 Max Median Min Mode Odd Percentile PercentileRank Pi Power Product Quotient Random RandomInteger Rank Remainder Round RoundDown RoundTo RoundUp Sign SquareRoot StandardDeviation StandardDeviationPopulation Sum SumProduct Truncate Misc ObjectLink ParseCSV Object ParseJSON People CreatedBy IsSignedIn ModifiedBy User Relational RowId WithName RichText BulletedList IndentBy NumberedList Shape ClipCircle Embed Hyperlink HyperlinkCard Image Rectangle Spatial Distance Location String Character Concatenate ContainsText DecodeFromBase64 EncodeAsBase64 EncodeForUrl EndsWith Format Join Left LeftPad Length LineBreak Lower Middle RegexMatch RegexReplace Repeat Replace Right RightPad Split StartsWith Substitute ToByteSize ToHexadecimal Trim Upper Action formulas Actions Activate AddOrModifyRows AddRow CopyDoc CopyPageToDoc CopyToClipboard DeleteRows DuplicatePage ModifyRows Notify OpenRow OpenWindow RefreshColumn RefreshTable RunActions SetControlValue SignUpForCoda Pack formulas ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |