dbTalk Databases Forums  

Removing carriage return in Instant Web Publishing

comp.databases.filemaker comp.databases.filemaker


Discuss Removing carriage return in Instant Web Publishing in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
efiles
 
Posts: n/a

Default Removing carriage return in Instant Web Publishing - 06-08-2010 , 11:20 AM






Instant web publishing does not allow you to exit a field with the
Enter key, so I tried a script. That didn't work, so I tried simply
taking the data and using the substitute script to remove the enter
key.
It's not the best solution. So I then put a tool tip on every field
explaining the user has to enter the Tab key.

But why is it that if I create a validation so that only so many
characters are allowed it still allows the enter key.

This problem has me puzzled. How to I stop a user in Instant Web
Publishing from pressing the Enter key inside a field that is only one
line?

Reply With Quote
  #2  
Old   
Your Name
 
Posts: n/a

Default Re: Removing carriage return in Instant Web Publishing - 06-09-2010 , 01:26 AM






"efiles" <lidia.lopinto (AT) gmail (DOT) com> wrote

Quote:
Instant web publishing does not allow you to exit a field with the
Enter key, so I tried a script. That didn't work, so I tried simply
taking the data and using the substitute script to remove the enter
key.
It's not the best solution. So I then put a tool tip on every field
explaining the user has to enter the Tab key.

But why is it that if I create a validation so that only so many
characters are allowed it still allows the enter key.

This problem has me puzzled. How to I stop a user in Instant Web
Publishing from pressing the Enter key inside a field that is only one
line?
Validation doesn't occur until the user leaves the Field (I've nbever used
the web interface, so that may not even validate until the user submits the
form).

There's two possible ways to fix the unwanted carriage returns:

- In newer versions of FileMaker I believe you can set the Field's
Auto-enter options to use a calculation base on itself, and have
that remove the carriage returns.

- create a second set of Fields that copy the content from the
user Fields, removing the carriage return.

In either case the calculation will use the Substitute function:
Substitute(Field; "{returncharacter}"; "")

where {returncharacter} is really the backwards P / pilcrow return symbol.
on one of the buttons in the define calculation window.

You might want to also include the Trim function to remove excess leading or
trailing spaces:
Trim(Substitute(Field; "{returncharacter}"; ""))


Helpfull Harry )

Reply With Quote
  #3  
Old   
105
 
Posts: n/a

Default Re: Removing carriage return in Instant Web Publishing - 06-09-2010 , 06:01 PM



On 9/06/10 1:50 AM, efiles wrote:
Quote:
Instant web publishing does not allow you to exit a field with the
Enter key, so I tried a script. That didn't work, so I tried simply
taking the data and using the substitute script to remove the enter
key.
It's not the best solution. So I then put a tool tip on every field
explaining the user has to enter the Tab key.

But why is it that if I create a validation so that only so many
characters are allowed it still allows the enter key.

This problem has me puzzled. How to I stop a user in Instant Web
Publishing from pressing the Enter key inside a field that is only one
line?
In 'normal' db (i.e. non IWP) a script trigger and field behaviour (
use go next object for tab/rtn/enter), but IWP:

<<
In Instant Web Publishing and Custom Web Publishing, script triggers can
only be activated by a script and not by direct user interaction. For
example, if a user tabs into a field that has an OnObjectEnter script
trigger, the trigger will not activate. If a script step causes focus to
move into that field, the script trigger will activate.
Quote:

What about a single 'SAVE' button on the layout that runs the scrub script?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.