Common fields subform.

Jake Howlett, 29 September 2000

Category: Forms; Keywords: CGI variables path file

One of the first things I do when starting a new database for the web is to create a subform called "CommonFields" which I will use on every form in the database. On it I usually put all the fields that I find myself using in just about every form.

By useful fields I mean things like:

DBPath

Computed For Display Text
@ReplaceSubstring(@Subset(@DBName; -1); "\\"; "/");
Used in all URLs whose relative position is unknown

isAdmin

Computed For Display Text
@UserRoles = "[Admin]"
Boolean value of whether or not user has Admin role. Useful in hide-whens.

CGI Variables

Computed For Display Text
Formula same as name
Examples - HTTP_Referer, Query_String, Remote_User

You can also add any Global JavaScript Functions/Variables that you need to throughout the site. If using R5 these can go in the JSHeader, otherwise add them as Pass-Thru HTML straight on to the subform.