status(currentfieldname) not working in portals? 
Author Message
 status(currentfieldname) not working in portals?

Dear Listeners:

I have a little problem with the above-mentioned feature.

In a multilingual database I have set up a pop-up global field to hold 1
special character. Behind that is a value list that holds all special
characters that are recognized by FMP (BTW these are only:
?a??????????De?????????????????Tt??Yy? which is
strangely enough somewhat less than is available via c:\windows\charmap.exe)

I let the user choose 1 character and copy it with a button beside it. Then
there is another button that does a Paste (not selecting the whole field).
It works fine.

But I wanted to make it more user-friendly by telling the user if the cursor
is "nowhere" and that he has to put it into one of the fields. So I use an
If-statement to check for all relevant field names. That works fine, too -
BUT it does not work in portals in the same layout. Then the error message
comes up, although the cursor is active in a portal field, and a manual
Paste works fine, too.

Is there a trick to circumvent this?

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



Mon, 07 Feb 2005 22:00:57 GMT
 status(currentfieldname) not working in portals?



Quote:
> Dear Listeners:

> I have a little problem with the above-mentioned feature.

> In a multilingual database I have set up a pop-up global field to hold 1
> special character. Behind that is a value list that holds all special
> characters that are recognized by FMP (BTW these are only:
> ?a??????????De?????????????????Tt??Yy? which is
> strangely enough somewhat less than is available via c:\windows\charmap.exe)

> I let the user choose 1 character and copy it with a button beside it. Then
> there is another button that does a Paste (not selecting the whole field).
> It works fine.

Use SetField instead of Copy Paste. Copy Paste uses the clipboard and any
data in there will be lost if they are switching between applications.

Quote:
> But I wanted to make it more user-friendly by telling the user if the cursor
> is "nowhere" and that he has to put it into one of the fields. So I use an
> If-statement to check for all relevant field names. That works fine, too -
> BUT it does not work in portals in the same layout. Then the error message
> comes up, although the cursor is active in a portal field, and a manual
> Paste works fine, too.

SetField does not require the cursor to be in a field to work.
Quote:
> Is there a trick to circumvent this?

> --
> Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> Christoph Bouthillier
> post (at) no-no-spamtekstotaal.com
> Please remove "no-no-spam" when e-mailing me directly - Thanks
> ------



Mon, 07 Feb 2005 22:26:42 GMT
 status(currentfieldname) not working in portals?
Unless you must check for the cursor being in certain fields for your
particular solution, how about:

If[isempty(status(currentfieldname))]

Quote:

> Dear Listeners:

> I have a little problem with the above-mentioned feature.

> In a multilingual database I have set up a pop-up global field to hold 1
> special character. Behind that is a value list that holds all special
> characters that are recognized by FMP (BTW these are only:
> ?a??????????De?????????????????Tt??Yy? which is
> strangely enough somewhat less than is available via c:\windows\charmap.exe)

> I let the user choose 1 character and copy it with a button beside it. Then
> there is another button that does a Paste (not selecting the whole field).
> It works fine.

> But I wanted to make it more user-friendly by telling the user if the cursor
> is "nowhere" and that he has to put it into one of the fields. So I use an
> If-statement to check for all relevant field names. That works fine, too -
> BUT it does not work in portals in the same layout. Then the error message
> comes up, although the cursor is active in a portal field, and a manual
> Paste works fine, too.

> Is there a trick to circumvent this?

> --
> Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> Christoph Bouthillier
> post (at) no-no-spamtekstotaal.com
> Please remove "no-no-spam" when e-mailing me directly - Thanks
> ------

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 321-5176
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Mon, 07 Feb 2005 22:28:54 GMT
 status(currentfieldname) not working in portals?
Dear Howard:

The status checking works fine in the non-portal portion of the layout, but
not in the portal, alas ... but why?

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



Quote:
> Unless you must check for the cursor being in certain fields for your
> particular solution, how about:

> If[isempty(status(currentfieldname))]


> > Dear Listeners:

> > I have a little problem with the above-mentioned feature.

> > In a multilingual database I have set up a pop-up global field to hold 1
> > special character. Behind that is a value list that holds all special
> > characters that are recognized by FMP (BTW these are only:
> > ?a??????????De?????????????????Tt??Yy? which is
> > strangely enough somewhat less than is available via

c:\windows\charmap.exe)

- Show quoted text -

Quote:

> > I let the user choose 1 character and copy it with a button beside it.
Then
> > there is another button that does a Paste (not selecting the whole
field).
> > It works fine.

> > But I wanted to make it more user-friendly by telling the user if the
cursor
> > is "nowhere" and that he has to put it into one of the fields. So I use
an
> > If-statement to check for all relevant field names. That works fine,
too -
> > BUT it does not work in portals in the same layout. Then the error
message
> > comes up, although the cursor is active in a portal field, and a manual
> > Paste works fine, too.

> > Is there a trick to circumvent this?

> > --
> > Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> > Christoph Bouthillier
> > post (at) no-no-spamtekstotaal.com
> > Please remove "no-no-spam" when e-mailing me directly - Thanks
> > ------

> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 321-5176
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance



Tue, 08 Feb 2005 01:37:29 GMT
 status(currentfieldname) not working in portals?
Dear Michael:

Unfortunately I cannot use Set Field here because the single character to be
inserted must be able to be placed anywhere in the field, therefore "Paste"
is the only way to go. An example:

The field "t.text" contains "gro?er" but this must manually be changed into
"gr??er". Here the cursor  will be placed behind "o", the user will
backspace the "o" and then fetch the "?" from the special field.

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



Quote:


> > Dear Listeners:

> > I have a little problem with the above-mentioned feature.

> > In a multilingual database I have set up a pop-up global field to hold 1
> > special character. Behind that is a value list that holds all special
> > characters that are recognized by FMP (BTW these are only:
> > ?a??????????De?????????????????Tt??Yy? which is
> > strangely enough somewhat less than is available via

c:\windows\charmap.exe)
Quote:

> > I let the user choose 1 character and copy it with a button beside it.
Then
> > there is another button that does a Paste (not selecting the whole
field).
> > It works fine.
> Use SetField instead of Copy Paste. Copy Paste uses the clipboard and any
> data in there will be lost if they are switching between applications.

> > But I wanted to make it more user-friendly by telling the user if the
cursor
> > is "nowhere" and that he has to put it into one of the fields. So I use
an
> > If-statement to check for all relevant field names. That works fine,
too -
> > BUT it does not work in portals in the same layout. Then the error
message
> > comes up, although the cursor is active in a portal field, and a manual
> > Paste works fine, too.
> SetField does not require the cursor to be in a field to work.
> > Is there a trick to circumvent this?

> > --
> > Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> > Christoph Bouthillier
> > post (at) no-no-spamtekstotaal.com
> > Please remove "no-no-spam" when e-mailing me directly - Thanks
> > ------



Tue, 08 Feb 2005 01:37:28 GMT
 status(currentfieldname) not working in portals?
Hi Chris--

I just tried it in Windows with FMP 5.5 and it works fine.  I created a script
with one step: Set Field[gText, status(currentfieldname).  Put a button on the
layout (not in the portal) that calls that script.  Works when the cursor is in
any field, including portal fields.

I did a similar test script that starts with
If[isempty(status(currentfieldname))] to either shoe me an error message or
not.  This also worked fine from portal fields.

Perhaps there is another step in your script before the test that is gtrr or
somehow otherwise exiting the portal before your test?

Quote:

> Dear Howard:

> The status checking works fine in the non-portal portion of the layout, but
> not in the portal, alas ... but why?



> > Unless you must check for the cursor being in certain fields for your
> > particular solution, how about:

> > If[isempty(status(currentfieldname))]


> > > Dear Listeners:

> > > I have a little problem with the above-mentioned feature.

> > > In a multilingual database I have set up a pop-up global field to hold 1
> > > special character. Behind that is a value list that holds all special
> > > characters that are recognized by FMP (BTW these are only:
> > > ?a??????????De?????????????????Tt??Yy? which is
> > > strangely enough somewhat less than is available via
> c:\windows\charmap.exe)

> > > I let the user choose 1 character and copy it with a button beside it.
> Then
> > > there is another button that does a Paste (not selecting the whole
> field).
> > > It works fine.

> > > But I wanted to make it more user-friendly by telling the user if the
> cursor
> > > is "nowhere" and that he has to put it into one of the fields. So I use
> an
> > > If-statement to check for all relevant field names. That works fine,
> too -
> > > BUT it does not work in portals in the same layout. Then the error
> message
> > > comes up, although the cursor is active in a portal field, and a manual
> > > Paste works fine, too.

> > > Is there a trick to circumvent this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 321-5176
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Tue, 08 Feb 2005 01:58:10 GMT
 status(currentfieldname) not working in portals?
Dear Christophe,

If the field whose name you want to test is the button, the test will fail.
If the field is formatted to disable entry, the test will fail. Also, if the
test is for the field name AND the relationship:

Relationship__Name::Field_Name

...the test will fail. It wants only the field name without the relationship
name. You might test by adding a step to set a global text field to
Status(CurrentFieldName) and placing the global temporarily on the layout.
You will see that only the name is returned, but it will work if the field
is in a portal row and the field is enterable.

John


Quote:
> Dear Listeners:

> I have a little problem with the above-mentioned feature.

> In a multilingual database I have set up a pop-up global field to hold 1
> special character. Behind that is a value list that holds all special
> characters that are recognized by FMP (BTW these are only:
> ?a??????????De?????????????????Tt??Yy? which is
> strangely enough somewhat less than is available via

c:\windows\charmap.exe)
Quote:

> I let the user choose 1 character and copy it with a button beside it.
Then
> there is another button that does a Paste (not selecting the whole field).
> It works fine.

> But I wanted to make it more user-friendly by telling the user if the
cursor
> is "nowhere" and that he has to put it into one of the fields. So I use an
> If-statement to check for all relevant field names. That works fine, too -
> BUT it does not work in portals in the same layout. Then the error message
> comes up, although the cursor is active in a portal field, and a manual
> Paste works fine, too.

> Is there a trick to circumvent this?

> --
> Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> Christoph Bouthillier
> post (at) no-no-spamtekstotaal.com
> Please remove "no-no-spam" when e-mailing me directly - Thanks
> ------



Tue, 08 Feb 2005 03:12:32 GMT
 status(currentfieldname) not working in portals?
Dear Howard

Aaahh!

Got it working inside and outside the portal with your help:

The copying (of 1 accented character from a value list)

Copy["g.accentcharacterdepot"]
Go to Field

And then the pasting anywhere in any text field:

Set Field  ["g.fieldnamestatus";"Status(CurrentFieldName)"]
If [isempty("g.fieldnamestatus")
ShowMessage["In order to paste an accented character the cursor must be in a
text field."]
Exit Script
Go to Field[]
Else
Paste[]
End If

Thanks!

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



Quote:
> Hi Chris--

> I just tried it in Windows with FMP 5.5 and it works fine.  I created a
script
> with one step: Set Field[gText, status(currentfieldname).  Put a button on
the
> layout (not in the portal) that calls that script.  Works when the cursor
is in
> any field, including portal fields.

> I did a similar test script that starts with
> If[isempty(status(currentfieldname))] to either shoe me an error message
or
> not.  This also worked fine from portal fields.

> Perhaps there is another step in your script before the test that is gtrr
or
> somehow otherwise exiting the portal before your test?


> > Dear Howard:

> > The status checking works fine in the non-portal portion of the layout,
but
> > not in the portal, alas ... but why?



> > > Unless you must check for the cursor being in certain fields for your
> > > particular solution, how about:

> > > If[isempty(status(currentfieldname))]


> > > > Dear Listeners:

> > > > I have a little problem with the above-mentioned feature.

> > > > In a multilingual database I have set up a pop-up global field to
hold 1
> > > > special character. Behind that is a value list that holds all
special
> > > > characters that are recognized by FMP (BTW these are only:
> > > > ?a??????????De?????????????????Tt??Yy? which
is
> > > > strangely enough somewhat less than is available via
> > c:\windows\charmap.exe)

> > > > I let the user choose 1 character and copy it with a button beside
it.
> > Then
> > > > there is another button that does a Paste (not selecting the whole
> > field).
> > > > It works fine.

> > > > But I wanted to make it more user-friendly by telling the user if
the
> > cursor
> > > > is "nowhere" and that he has to put it into one of the fields. So I
use
> > an
> > > > If-statement to check for all relevant field names. That works fine,
> > too -
> > > > BUT it does not work in portals in the same layout. Then the error
> > message
> > > > comes up, although the cursor is active in a portal field, and a
manual
> > > > Paste works fine, too.

> > > > Is there a trick to circumvent this?

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 321-5176
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance



Tue, 08 Feb 2005 05:34:16 GMT
 status(currentfieldname) not working in portals?
Dear John:

Thanks for your suggestion. I had followed an advice by Howard last night
and had posted its successful implementation some 8  hours ago. You will not
have seen my answer due do this (news server failure?). I just reposted it a
minute ago.

The global Howard had suggested is not even on the layout, and the 2 buttons
"Copy" and "Past at cursor" are somewhere in the header; they are not
fields, too. All the the text fields where accented characters are meant to
go, are in the body, 3 in the "normal" area and 3 in a portal. It all works
fine now, see the scripts in my other message. It's become a really
comfortable way to enter such characters except that the widely loathed
copy/paste steps are necessary.

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



Quote:
> Dear Christophe,

> If the field whose name you want to test is the button, the test will
fail.
> If the field is formatted to disable entry, the test will fail. Also, if
the
> test is for the field name AND the relationship:

> Relationship__Name::Field_Name

> ...the test will fail. It wants only the field name without the
relationship
> name. You might test by adding a step to set a global text field to
> Status(CurrentFieldName) and placing the global temporarily on the layout.
> You will see that only the name is returned, but it will work if the field
> is in a portal row and the field is enterable.

> John



> > Dear Listeners:

> > I have a little problem with the above-mentioned feature.

> > In a multilingual database I have set up a pop-up global field to hold 1
> > special character. Behind that is a value list that holds all special
> > characters that are recognized by FMP (BTW these are only:
> > ?a??????????De?????????????????Tt??Yy? which is
> > strangely enough somewhat less than is available via
> c:\windows\charmap.exe)

> > I let the user choose 1 character and copy it with a button beside it.
> Then
> > there is another button that does a Paste (not selecting the whole
field).
> > It works fine.

> > But I wanted to make it more user-friendly by telling the user if the
> cursor
> > is "nowhere" and that he has to put it into one of the fields. So I use
an
> > If-statement to check for all relevant field names. That works fine,
too -
> > BUT it does not work in portals in the same layout. Then the error
message
> > comes up, although the cursor is active in a portal field, and a manual
> > Paste works fine, too.

> > Is there a trick to circumvent this?

> > --
> > Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> > Christoph Bouthillier
> > post (at) no-no-spamtekstotaal.com
> > Please remove "no-no-spam" when e-mailing me directly - Thanks
> > ------



Tue, 08 Feb 2005 16:11:28 GMT
 status(currentfieldname) not working in portals?
[resending this message since it dit not show up after some 8 hours in the
list]

Dear Howard

Aaahh!

Got it working inside and outside the portal with your help:

The copying (of 1 accented character from a value list)

Copy["g.accentcharacterdepot"]
Go to Field

And then the pasting anywhere in any text field:

Set Field  ["g.fieldnamestatus";"Status(CurrentFieldName)"]
If [isempty("g.fieldnamestatus")
ShowMessage["In order to paste an accented character the cursor must be in a
text field."]
Exit Script
Go to Field[]
Else
Paste[]
End If

Thanks!

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



Quote:
> Hi Chris--

> I just tried it in Windows with FMP 5.5 and it works fine.  I created a
script
> with one step: Set Field[gText, status(currentfieldname).  Put a button on
the
> layout (not in the portal) that calls that script.  Works when the cursor
is in
> any field, including portal fields.

> I did a similar test script that starts with
> If[isempty(status(currentfieldname))] to either shoe me an error message
or
> not.  This also worked fine from portal fields.

> Perhaps there is another step in your script before the test that is gtrr
or
> somehow otherwise exiting the portal before your test?


> > Dear Howard:

> > The status checking works fine in the non-portal portion of the layout,
but
> > not in the portal, alas ... but why?



> > > Unless you must check for the cursor being in certain fields for your
> > > particular solution, how about:

> > > If[isempty(status(currentfieldname))]


> > > > Dear Listeners:

> > > > I have a little problem with the above-mentioned feature.

> > > > In a multilingual database I have set up a pop-up global field to
hold 1
> > > > special character. Behind that is a value list that holds all
special
> > > > characters that are recognized by FMP (BTW these are only:
> > > > ?a??????????De?????????????????Tt??Yy? which
is
> > > > strangely enough somewhat less than is available via
> > c:\windows\charmap.exe)

> > > > I let the user choose 1 character and copy it with a button beside
it.
> > Then
> > > > there is another button that does a Paste (not selecting the whole
> > field).
> > > > It works fine.

> > > > But I wanted to make it more user-friendly by telling the user if
the
> > cursor
> > > > is "nowhere" and that he has to put it into one of the fields. So I
use
> > an
> > > > If-statement to check for all relevant field names. That works fine,
> > too -
> > > > BUT it does not work in portals in the same layout. Then the error
> > message
> > > > comes up, although the cursor is active in a portal field, and a
manual
> > > > Paste works fine, too.

> > > > Is there a trick to circumvent this?

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 321-5176
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance

--
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
post (at) no-no-spamtekstotaal.com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------



- Show quoted text -

Quote:
> Hi Chris--

> I just tried it in Windows with FMP 5.5 and it works fine.  I created a
script
> with one step: Set Field[gText, status(currentfieldname).  Put a button on
the
> layout (not in the portal) that calls that script.  Works when the cursor
is in
> any field, including portal fields.

> I did a similar test script that starts with
> If[isempty(status(currentfieldname))] to either shoe me an error message
or
> not.  This also worked fine from portal fields.

> Perhaps there is another step in your script before the test that is gtrr
or
> somehow otherwise exiting the portal before your test?


> > Dear Howard:

> > The status checking works fine in the non-portal portion of the layout,
but
> > not in the portal, alas ... but why?



> > > Unless you must check for the cursor being in certain fields for your
> > > particular solution, how about:

> > > If[isempty(status(currentfieldname))]


> > > > Dear Listeners:

> > > > I have a little problem with the above-mentioned feature.

> > > > In a multilingual database I have set up a pop-up global field to
hold 1
> > > > special character. Behind that is a value list that holds all
special
> > > > characters that are recognized by FMP (BTW these are only:
> > > > ?a??????????De?????????????????Tt??Yy? which
is
> > > > strangely enough somewhat less than is available via
> > c:\windows\charmap.exe)

> > > > I let the user choose 1 character and copy it with a button beside
it.
> > Then
> > > > there is another button that does a Paste (not selecting the whole
> > field).
> > > > It works fine.

> > > > But I wanted to make it more user-friendly by telling the user if
the
> > cursor
> > > > is "nowhere" and that he has to put it into one of the fields. So I
use
> > an
> > > > If-statement to check for all relevant field names. That works fine,
> > too -
> > > > BUT it does not work in portals in the same layout. Then the error
> > message
> > > > comes up, although the cursor is active in a portal field, and a
manual
> > > > Paste works fine, too.

> > > > Is there a trick to circumvent this?

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 321-5176
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance



Tue, 08 Feb 2005 16:11:27 GMT
 
 [ 10 post ] 

 Relevant Pages 

1. Status(CurrentFieldName) - how does it work??

2. Status ( CurrentFieldName )

3. Problem with Status(CurrentFieldName)

4. Status(CurrentFieldName)

5. Status(CurrentFieldName)

6. 'Go to portal row' not working

7. "Status (currentportalrow)" does not work

8. Status(CurrentPortalRow) not working

9. To Portal or not to Portal

10. Status 2's that are not really status 2's

11. CurrentFieldName

12. SQL Cluster working/MS Cluster not working


 
Powered by phpBB® Forum Software