The info(“matrixcellrecordid”) function returns the record id of the cell in a matrix that was clicked on.

Description

This function returns the record id of the cell in a matrix that was clicked on. This function can onlly be used with a matrix that has the pass thru option enabled. Here is code that will jump to the clicked record in a matrix.

findid info("matrixcellrecordid")
if info("found")
    BookingDate = today()
else
    message "Record has been deleted or is not currently visible!"
endif

See Matrix Clicking and Matrix Database Integration to learn more.

See Also

• dbinfo( -- gets information about a database: what forms it contains, what fields, what flash art pictures, etc.
• fileglobalvalue( -- accesses a fileglobal or permanent variable from other databases.
• getfieldproperties( -- returns a dictionary containing all of the properties of the specified field. (See the setfieldproperties statement if you want to change one or more field properties.)
• getformoption( -- returns information about a form.
• getprocedureoption( -- returns information about a procedure.
• getproceduretext( -- gets the contents (source code) of a procedure.
• globalvalue( -- returns the value of a global variable.
• info( -- returns miscellaneous bits of information about the system, the current database, the current window, etc.
• info("accessorypanelwidth") -- returns the current width of the current window's accessory panel, if any.
• info("activeobjectid") -- returns the object ID of the currently active text editor or text list object, if any.
• info("activesuperobject") -- returns the name of the currently active text editor or word processor object, if any.
• info("angleunits") -- returns the current angular measurement units.
• info("applicationsfolder") -- returns the path to the current user's Applications folder.
• info("applicationsupportfolder") -- returns the path to the current user's Application Support folder (inside the Library folder).
• info("arraybuildstatus") -- returns the status of the most recently executed superarraybuild statement.
• info("availablescreenrectangle") -- returns a rectangle defining the edges of the main screen, after deducting for the space of the menu bar and dock (if visible).
• info("bof") -- returns true if the active record is currently on the first visible (selected) record.
• info("buttonrectangle") -- returns a rectangle defining the edges of the most recently clicked button.
• info("cachefolder") -- returns the path to the current user's Cache folder (in the Library folder).
• info("canmodifydatabasedesign") -- returns true if the user has permission to modify the database design.
• info("canusestandardui") -- returns true if the user has permission to use standard Panorama UI when using this database.
• info("click") -- returns the location of the last mouse click in screen relative coordinates.
• info("clickedobjectid") -- returns the object ID of the clicked object.
• info("clickedobjectname") -- returns the name of the button that was just clicked.
• info("clickedwindownumber") -- returns the window number of that was just clicked.
• info("clonewindow") -- returns true if the current window was opened as a "clone" window.
• info("collapsible") -- checks to see if the current record is collapsible.
• info("countrycode") -- returns the country code for the current location.
• info("csvseparator") -- returns the current CSV field separator character (comma or semicolon).
• info("currencycode") -- returns the currency code for the current location.
• info("currencysymbol") -- returns the currency symbol for the current location.
• info("customfunctions") -- returns a list of all available custom functions.
• info("customstatements") -- returns a list of all available custom statements.
• info("databasefilename") -- returns the name of the current database.
• info("databasename") -- returns the name of the current database excluding any filename extension (if any).
• info("datasheetwindownumbers") -- returns the unique ID numbers of all open data sheet windows.
• info("datatype") -- returns the data type of the current field.
• info("decimalseparator") -- returns the current decimal separator character (period or comma).
• info("defaultdatepattern") -- returns the default date pattern used for displaying dates.
• info("defaultmaxdatasheetcolumns") -- default maximum number of allowed data sheet columns.
• info("defaultvoice") -- returns the current default system voice.
• info("desktopfolder") -- returns the path to the user's desktop folder.
• info("dialogsheet") -- returns true if the currently active window is a dialog sheet.
• info("dialogtrigger") -- returns the name of the last button pressed in an alert or dialog.
• info("disablebackgroundsearch") -- returns true if all background searches have been disabled.
• info("disabledfields") -- returns a list of disabled fields in the current database (fields that cannot be edited).
• info("documentsfolder") -- returns the path to the current user's Documents folder.
• info("downloadsfolder") -- returns the path to the current user's Downloads folder.
• info("dropdatabase") -- returns the name of the database that contains the form data was dropped on.
• info("dropfiles") -- returns a list of files dragged onto a *Drag Receiver* form object (see Drag and Drop).
• info("dropform") -- returns the name of the form data was dropped on.
• info("dropobject") -- returns the name of the object that data was dropped on.
• info("droptext") -- returns text dragged onto a *Drag Receiver* form object (see Drag and Drop).
• info("droptypes") -- returns a list of all the data types dragged onto a *Drag Receiver* form object (see Drag and Drop).
• info("dropvcard") -- returns the text of any VCards dragged onto a *Drag Receiver* form object (see Drag and Drop).
• info("dropwindow") -- returns the name of the window that contains the form data was dropped on.
• info("dropwindownumber") -- returns the number of the window that contains the form data was dropped on.
• info("empty") -- returns true or false depending on the result of the last select operation. If no records were selected the function will return true, otherwise it will return false.
• info("enabledfields") -- returns a list of enabled fields in the current database (fields that can be edited).
• info("eof") -- returns true if the active record is currently the last visible (selected) record.
• info("error") -- returns the most recent error message.
• info("errorparameter") -- returns the parameter that caused a runtime error.
• info("errorstack") -- returns the contents of the procedure stack after an error.
• info("errorstatement") -- returns the name of the statement that Panorama was trying to run at the time an error occurred.
• info("eventtype") -- returns the type of the last event (mouse click, keyboard press, etc.).
• info("executeerrorsource") -- can be used in Error Handling code when an error occurs in code running via the execute statement or its siblings.
• info("expandable") -- checks to see if the current record is expandable.
• info("expressionstacksize") -- returns the fake size of expression stack.
• info("fieldcount") -- returns the number of fields in the current database.
• info("fieldname") -- returns the name of the current field.
• info("fieldnumber") -- returns the number of the current field (starting from 1).
• info("fields") -- returns a carriage return delimited list of fields in the current database.
• info("files") -- returns a list of all open database files.
• info("filesystemmonitors") -- lists the active file system monitors.
• info("filevariables") -- builds a carriage return separated text array containing a list of the currently allocated fileglobal variables in the current database.
• info("focusobject") -- returns the name of the currently active text editor or word processor object, if any.
• info("focusobjectid") -- returns the object ID of the currently active text editor or text list object, if any.
• info("foldersepchar") -- returns the separator character used between folders.
• info("fonts") -- returns a list of all fonts installed on this computer.
• info("formevent") -- returns the last event that occurred to the current form.
• info("formname") -- returns the name of the current form.
• info("formwindownumbers") -- returns the unique ID numbers of all open form windows.
• info("found") -- returns true or false depending on whether the last *find* or *next* statement was successful.
• info("globalvariables") -- builds a carriage return separated text array containing a list of the currently allocated global variables.
• info("guid") -- returns a unique identifier string.
• info("hiddenfields") -- returns a carriage return delimited list of fields that are currently hidden in the current data sheet.
• info("horizontalscrollbar") -- returns true if the current window's horizontal scrollbar is enabled, false if it is disabled.
• info("javascriptvalue") -- returns the value passed from JavaScript code in a web browser object.
• info("keyboard") -- returns the last key that was pressed.
• info("keycode") -- returns a special numeric code that represents the last key that was pressed.
• info("labels") -- lists the labels in the current procedure.
• info("languagecode") -- returns the language code for the current location.
• info("libraryfolder") -- returns the path to the current user's Library folder.
• info("localvariables") -- builds a carriage return separated text array containing a list of the currently allocated local variables.
• info("loggedinaccountemail") -- returns the currently logged in account ID (email address).
• info("loggedinaccountrole") -- returns the currently logged in account role.
• info("magnification") -- returns the current magnification of the current form.
• info("matrixcell") -- returns the current cell number within a matrix object.
• info("matrixcelldata") -- returns the data associated with the current matrix object cell.
• info("matrixcellselected") -- returns the selection status of the current matrix object cell.
• info("matrixclickedframeform") -- returns the form that contains the matrix frame, or `""` if the current form contains the frame.
• info("matrixclickedobjectid") -- returns the object id of the object in a matrix that was clicked on (or zero if none).
• info("matrixcolumn") -- returns the current column number within a matrix object.
• info("matrixdata") -- returns the data associated with the current matrix object.
• info("matrixname") -- returns the name of the matrix object being drawn, if any.
• info("matrixrow") -- returns the current row number within a matrix object.
• info("matrixseparator") -- function returns the separator associated with the current matrix.
• info("measurementsystem") -- returns the measurement system for the current location.
• info("menuidentifier") -- returns the identifier of the most recently chosen menu item (if any).
• info("milliseconds") -- returns the number of milliseconds (1/1000th second) since the system started up.
• info("modaldialogopen") -- returns true if a modal dialog window is currently open.
• info("modifiedfield") -- returns the name of the field that was just modified.
• info("mousedown") -- returns true or false depending on whether the mouse is currently down.
• info("moviesfolder") -- returns the path to the current user's Movies folder.
• info("musicfolder") -- returns the path to the current user's Music folder.
• info("noshow") -- returns true if noshow is currently turned on, false if it is not.
• info("notification") -- returns information about the just clicked notification.
• info("osversion") -- returns the operating system version and build number.
• info("pagecount") -- calculates the total number of pages that will be printed.
• info("pagenumber") -- returns the current report page number.
• info("pagesetuporientation") -- returns the printing page orientation for the current database.
• info("pagesetuppaperheight") -- returns the printing paper height for the current database.
• info("pagesetuppaperwidth") -- returns the printing paper width for the current database.
• info("pagesetupscale") -- returns the printing scale factor for the current database.
• info("panoramafolder") -- returns the location of the folder containing the currently running copy of Panorama.
• info("panoramaname") -- returns the name of the currently running copy of Panorama.
• info("panoramauptime") -- returns the number of seconds since Panorama launched.
• info("parameters") -- returns the number of parameters passed to a subroutine.
• info("picturesfolder") -- returns the path to the current user's Pictures folder.
• info("posixtasks") -- list of POSIX shell tasks running in the background.
• info("preferences") -- returns a list of all currently active preference settings.
• info("printsequence") -- returns the record sequence number of the record being printed.
• info("proceduredatabase") -- returns the name of the database that contains the currently running procedure.
• info("procedurename") -- returns the name of the currently running procedure.
• info("procedurestack") -- returns the contents of Panorama's procedure call stack.
• info("procedurewindownumbers") -- returns the unique ID numbers of all open procedure windows.
• info("publicfolder") -- returns the path to the current user's Public folder.
• info("quitinprogress") -- returns true if Panorama is in the process of quitting.
• info("ram") -- returns the amount of physical RAM in this computer.
• info("rawdatabasedata") -- returns the binary data of the current database.
• info("records") -- returns the total number of records in the current database.
• info("runningatomic") -- returns true if the current procedure is running as an "atomic" procedure.
• info("runninghandler") -- returns true if the current procedure is running as a "handler" procedure.
• info("screenrectangle") -- returns a rectangle defining the edges of the main screen.
• info("searchformula") -- returns the most recent search formula used in a *find* statement, if any.
• info("selected") -- returns the number of selected records in the current database.
• info("serverconnection") -- returns true if the currently active database successfully connected to the server when it opened.
• info("serverconnectionstatus") -- returns the status of the connection between this database and the server.
• info("serverrecordid") -- returns the unique ID number for the current record.
• info("serverrecordts") -- returns the internal time stamp associated with the current record.
• info("serverupdate") -- returns true if the server update option is currently turned on (this is the default).
• info("showlater") -- determines whether or not Panorama is currently deferring display.
• info("speaking") -- returns true if talking is occuring right now.
• info("speechrate") -- returns the current Panorama speech rate (words per minute).
• info("speechvoice") -- returns the current default system voice.
• info("speechvolume") -- returns the current Panorama speech volume.
• info("stopped") -- returns true or false depending on the whether the last uprecord, downrecord, left or right statement succeeded or failed.
• info("summary") -- returns the summary level of the current record, from 0 (data record) to 7.
• info("taperecorder") -- returns information about the current procedure recording (if any).
• info("tempfolder") -- returns the path to the current user's temporary folder (for files you plan to use only for a short time).
• info("texteditortrigger") -- returns the reason why a Text Editor object triggered a procedure.
• info("thousandsseparator") -- returns the current thousands separator character (period or comma).
• info("tickcount") -- returns the number of ticks (1/60th second) since the system started up.
• info("timelimitremaining") -- returns the amount of time available (in seconds) before a loop will time out.
• info("toolbar") -- returns true if the current window's toolbar is visible, false if it is hidden.
• info("toolbarvisible") -- returns true if the current window has a visible tool bar.
• info("trigger") -- returns information about how the current procedure was triggered.
• info("typeofwindow") -- determines what type of view the current window contains.
• info("unixusername") -- returns the short user name of the logged in user.
• info("unsharedrecordid") -- returns the minimum ID for unshared records.
• info("uptime") -- returns the number of seconds since the computer was last booted.
• info("user") -- returns the name of the user of this computer.
• info("userfolder") -- returns the path to the current user's home folder.
• info("verticalscrollbar") -- returns true if the current window's vertical scrollbar is enabled, false if it is disabled.
• info("visible") -- returns true if the current record is visible and false if it is invisible.
• info("visiblefields") -- returns a carriage return delimited list of fields that are currently visible in the current data sheet.
• info("voices") -- returns a list of available speech synthesis voices on this system.
• info("volumes") -- returns a list of all of the currently mounted volumes (disks) on the computer.
• info("webbrowserlinklabel") -- returns the url of the link right clicked in a Web Browser object.
• info("webbrowserlinkurl") -- returns the url of the link right clicked in a Web Browser object.
• info("windowdepth") -- returns the color depth of the current window.
• info("windowname") -- returns the name of the current window.
• info("windownumber") -- returns the unique ID number of the current window.
• info("windownumbers") -- returns the unique ID numbers of all open windows.
• info("windowoptions") -- returns the names of any currently enabled window options,
• info("windowrectangle") -- returns a rectangle defining the edges of the current window. The rectangle is in screen relative coordinates.
• info("windows") -- builds a carriage return separated text array containing a list of all the currently open windows.
• info("windowtype") -- returns a numeric value based on what type of view the current window contains.
• info("windowvariables") -- returns a carriage return separated text array listing the windowglobal variables defined for the current window.
• info("windowview") -- determines what type of view the current window contains.
• localvalue( -- returns the value of a local variable.
• parameter( -- is used to transfer data between a main procedure and a subroutine.
• scopes( -- returns the current scope of a variable, as well as any hidden scopes.
• scopevalue( -- returns the value of a variable in the specified scope.
• setdatabaseoptions -- modifies one or more properties of a database.
• setformoptions -- modifies one or more properties of a form (name, viewing mode, etc.).
• setprocedureoptions -- modifies one or more properties of a procedure (source code, Action menu options, etc.).
• windowglobalvalue( -- accesses a windowglobal variable from other windows.

History