SerialIncrement()
Category: Text
Syntax: SerialIncrement ( text; incrementBy ) |
Parameters:
textAny text or text expression that contains an alphanumeric string.
incrementByA number or numeric expression with which to increment the text value.
Data type returned: Text
Description:
Returns the combined text and number from the text value, where the numeric portion of the text has been incremented by the value specified in the incrementBy parameter.
The incrementBy value is truncated to an integer when incrementing. Positive and negative numbers are accepted.
Examples:
Function | Results |
|---|---|
SerialIncrement ("test1"; 2) | Returns test3. |
SerialIncrement ("project_plan_v12.3"; -1) | Returns project_plan_v12.2. |
SerialIncrement ("2hithere3"; 3) | Returns 2hithere6. |
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
- Calculation Signatures
- Aggregate Functions
- Date Functions
- Design Functions
- External Functions
- Financial Functions
- Get Functions
- Logical Functions
- Number Functions
- Repeating Functions
- Summary Functions
- Text Functions
- Text Formatting Functions
- Time Functions
- Timestamp Functions
- Trigonometric Functions
Calculation Functions
- Abs()
- Atan()
- Average()
- Case()
- Ceiling()
- Choose()
- Combination()
- Cos()
- Count()
- DatabaseNames
- Date()
- Day()
- DayName()
- DayNameJ()
- DayOfWeek()
- DayOfYear()
- Degrees()
- Div()
- Evaluate()
- EvaluationError()
- Exact()
- Exp()
- Extend()
- External()
- Factorial()
- FieldBounds()
- FieldComment()
- FieldIDs()
- FieldNames()
- FieldRepetitions()
- FieldStyle()
- FieldType()
- Filter()
- FilterValues()
- Floor()
- FV()
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostIPAddress)
- Get(HostName)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(PageNumber)
- Get(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenWidth)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- GetAsBoolean()
- GetAsCSS()
- GetAsDate()
- GetAsNumber()
- GetAsSVG()
- GetAsText()
- GetAsTime()
- GetAsTimestamp()
- GetField()
- GetNextSerialValue()
- GetNthRecord()
- GetRepetition()
- GetSummary()
- GetValue()
- Hiragana()
- Hour()
- If()
- Int()
- IsEmpty()
- IsValid()
- IsValidExpression()
- KanaHankaku()
- KanaZenkaku()
- KanjiNumeral()
- Katakana()
- Last()
- LayoutIDs()
- LayoutNames()
- Left()
- LeftValues()
- LeftWords()
- Length()
- Let()
- Lg()
- Ln()
- Log()
- Lookup()
- LookupNext()
- Lower()
- Max()
- Middle()
- MiddleValues()
- MiddleWords()
- Min()
- Minute()
- Mod()
- Month()
- MonthName()
- MonthNameJ()
- NPV()
- NumToJText()
- PatternCount()
- Pi
- PMT()
- Position()
- Proper()
- PV()
- Quote()
- Radians()
- Random
- RelationInfo()
- Replace()
- RGB()
- Right()
- RightValues()
- RightWords()
- RomanHankaku()
- RomanZenkaku()
- Round()
- ScriptIDs()
- ScriptNames()
- Seconds()
- SerialIncrement()
- SetPrecision()
- Sign()
- Sin()
- Sqrt()
- StDev()
- StDevP()
- Substitute()
- Sum()
- TableIDs()
- TableNames()
- Tan()
- TextColor()
- TextColorRemove()
- TextFont()
- TextFontRemove()
- TextFormatRemove()
- TextSize()
- TextSizeRemove()
- TextStyleAdd()
- TextStyleRemove()
- Time()
- Timestamp()
- Trim()
- TrimAll()
- Truncate()
- Upper()
- ValueCount()
- ValueListIDs()
- ValueListItems()
- ValueListNames()
- Variance()
- VarianceP()
- WeekOfYear()
- WeekOfYearFiscal()
- WindowNames
- WordCount()
- Year()
- YearName()
: Custom Functions
Custom Functions Primer
Useful Custom Functions
- Useful Custom Functions
- Number Calculations
- Date Calculations
- Text and Data Conversions
- Email Tools
- Developer Tools
- System Constants
- Toolkit for Complex Data Structures
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
- FileMaker XML Reference
- About FileMaker and XML
- URL Syntax for Web Access to FileMaker Data
- FileMaker XML Grammars
- Query Parameters for XML/XSLT URL Requests
- FileMaker XML and XSLT Namespaces
: Other Resources
Where to Go for More Information
- Where to Go for More Information
- FileMaker
- General Information on Relational Databases
- Data Modeling and Database Design
- Project Management, Programming, and Software Development
- Running a FileMaker Consulting Practice
- General Resources for Tips and Tricks
- Hosting FileMaker Databases on the Web
- FileMaker News Sources
- Developer Tools
- Web Programming
- PHP
- ODBC/JDBC
EAN: 2147483647
Pages: 352
