Entire Site

Creative Edge


    Copyright
    About the Authors
    Acknowledgments
    We Want to Hear from You!
    INTRODUCTION Welcome to FileMaker Pro 7
    Pt. : I Getting Started with FileMaker 7
    Pt. : II Developing Solutions with FileMaker
    Pt. : III Developer Techniques
    Pt. : IV Data Integration and Publishing
    Pt. : V Deploying a FileMaker Solution
    Pt. : VI Appendixes
    Appendix A: Additional Resources
    Appendix B: Calculation Function Reference
    Abs()z
    Atan()
    Average()
    Case()
    Ceiling()
    Choose()
    Combination()
    Cos()
    Count()
    DatabaseNames()
    Date()
    Day()
    DayName()
    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(ApplicationLanguage)
    Get(ApplicationVersion)
    Get(CalculationRepetitionNumber)
    Get(CurrentDate)
    Get(CurrentHostTimestamp)
    Get(CurrentTime)
    Get(CurrentTimestamp)
    Get(ErrorCaptureState)
    Get(ExtendedPrivileges)
    Get(FileName)
    Get(FilePath)
    Get(FileSize)
    Get(FoundCount)
    Get(HighContrastColor)
    Get(HighContrastState)
    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(PrinterName)
    Get(PrivilegeSetName)
    Get(RecordAccess)
    Get(RecordID)
    Get(RecordModificationCount)
    Get(RecordNumber)
    Get(RequestCount)
    Get(ScreenDepth)
    Get(ScreenHeight)
    Get(ScreenWidth)
    Get(ScriptName)
    Get(ScriptParameter)
    Get(SortState)
    Get(StatusAreaState)
    Get(SystemIPAddress)
    Get(SystemLanguage)
    Get(SystemNICAddress)
    Get(SystemPlatform)
    Get(SystemVersion)
    Get(TotalRecordCount)
    Get(UserCount)
    Get(UserName)
    Get(WindowContentHeight)
    Get(WindowContentWidth)
    Get(WindowDesktopHeight)
    Get(WindowDesktopWidth)
    Get(WindowHeight)
    Get(WindowLeft)
    Get(WindowMode)
    Get(WindowName)
    Get(WindowTop)
    Get(WindowVisible)
    Get(WindowWidth)
    GetAsCSS()
    GetAsDate()
    GetAsNumber()
    GetAsSVG()
    GetAsText()
    GetAsTime()
    GetAsTimestamp()
    GetField()
    GetNextSerialValue()
    GetRepetition()
    GetSummary()
    Hour()
    If()
    Int()
    IsEmpty()
    IsValid()
    IsValidExpression()
    Last()
    LayoutIDs()
    LayoutNames()
    Left()
    LeftValues()
    LeftWords()
    Length()
    Let()
    Lg()
    Ln()
    Log()
    Lookup()
    LookupNext()
    Lower()
    Max()
    Middle()
    MiddleValues()
    MiddleWords()
    Min()
    Minute()
    Mod()
    Month()
    MonthName()
    NPV()
    PatternCount()
    Pi
    PMT()
    Position()
    Proper()
    PV()
    Quote()
    Radians()
    Random
    RelationInfo()
    Replace()
    RGB()
    Right()
    RightValues()
    RightWords()
    Round()
    ScriptIDs()
    ScriptNames()
    Seconds()
    SerialIncrement()
    SetPrecision()
    Sign()
    Sin()
    Sqrt()
    StDev()
    StDevP()
    Substitute()
    Sum()
    TableIDs()
    TableNames()
    Tan()
    TextColor()
    TextFont()
    TextSize()
    TextStyleAdd()
    TextStyleRemove()
    Time()
    Timestamp()
    Trim()
    Truncate()
    Upper()
    ValueCount()
    ValueListIDs()
    ValueListItems()
    ValueListNames()
    Variance()
    VarianceP()
    WeekOfYear()
    WeekOfYearFiscal()
    WindowNames
    WordCount()
    Year()
    Appendix C: Script Step Reference
    Appendix D: Documenting FileMaker Pro Systems
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • PrintPrint
    Share this Page URL
    Help

    Let()

    Category: Logical

    Syntax: Let ( {[}var1=expression1 {; var2=expression2...]} ; calculation )


    PREVIEW

                                                                               

    Not a subscriber?

    Start A Free Trial


      
    • Creative Edge
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • PrintPrint