Common fields subform. - Article

Common fields subform. 29 September 2000

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.

Feedback

- Rafat Waqar
- Tue 31 Dec 2002
How to paste the URL in SendMail Agent
How do we paste the URL Link of the current Web Document in the Web SendMail Agent? What kind of fields we should create in the form to achieve that goal?

Reply
- Rafat Waqar
- Tue 31 Dec 2002
Server Name does not show with @DbName formula
I created a computed field called Server but Server Name does not show with @DbName formula on the Web. It only shows in the Notes client. Can someone help me on this?

Reply
1. - Stan Rogers
  - Thu 2 Jan 2003
  Re: Server Name does not show with @DbName formula
  That's done on purpose, since remote lookups, etc., are not permitted on the web. Anything other than an empty string ("") specified in a ServerName parameter on the web will result in a security error. Given that, it is difficult to understand what purpose the server name could serve in a web application.
  
  Reply
  
  Show the rest of this thread
  1. - Karl W.
    - Tue 21 Oct 2003
    Re: Server Name does not show with @DbName formula
    Stan -
    If there is no way to get the server name in a web app, is there another way to get the URL for an element in an application.
    I have a frameset for a home page, with a frame that opens the first document in a view. Frame Type: URL Value: "http://server/db.nsf/viewname/$First?OpenDocument"
    Right now I'm hard coding the server name in the value, but it becomes a pain on the development and test servers to test anything. Also, if the production server name changes or the app is migrated to another server, I need to remember to change the reference.
    Is there another solution to accomplish the same task.
    Karl
    
    Reply
2. - Darshana
  - Mon 3 May 2004
  Re: Server Name does not show with @DbName formula
  You can directly use following : Field Name : SERVER_NAME Type : Computed for Display Value : SERVER_NAME
  This will return you the server name on which your database resides.
  -Darshana
  
  Reply
3. - Pancho Marx
  - Tue 13 Mar 2007
  Re: Server Name does not show with @DbName formula
  @GetHTTPHeader("Host")
  
  Reply
  
  Show the rest of this thread
  1. - Pancho Marx
    - Tue 13 Mar 2007
    Re: Server Name does not show with @DbName formula
    also
    @Name([CN]; @ServerName)
    
    Reply
- Kurt
- Sat 1 May 2004
Dynamic First Field
I have been tasked with creating a template that not matter what the name of the field, when loaded via a browser, it will automagically go to the first field.
I use the "onLoad": document.forms[0].elements[0].focus()
For whatever reason, this won't recognize the first field.
If I use "onLoad": document.forms[0].first.focus() and name the field "first" it works fine.
I prefer using the elements[0] method so I don't have to dictate field names. This is a basic template that will be used to make custom forms. Because of all the other elements required, I am using a subform to store the input fields.
Any thoughts as to why this isn't working?

Reply
1. - Jake
  - Sun 2 May 2004
  Re: Dynamic First Field
  Hi Kurt,
  Not sure why it wouldn't work. Depends what the first element is. May not be a field! Try:
  alert(document.forms[0].elements[0].name)
  and see what it thinks element 1 is.
  
  Reply
  
  Show the rest of this thread
  1. - Kurt
    - Sun 2 May 2004
    Re: Dynamic First Field
    That worked. Trouble is, Domino adds it's own fields. First field was a hidden field that it was selecting.
    Thanks for the troubleshooting kick in the head (aka "Oh duh!")
    :-)
    
    Reply