dbTalk Databases Forums  

Display name of field if field is empty

comp.databases.filemaker comp.databases.filemaker


Discuss Display name of field if field is empty in the comp.databases.filemaker forum.



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

Default Display name of field if field is empty - 04-05-2011 , 10:18 PM






Is there a way to display the name of the field if the field is
empty? If there was any way to have it display as it does in layout
mode, that would be perfect.

Any suggestions appreciated.

Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: Display name of field if field is empty - 04-06-2011 , 12:27 PM






You can only do this with a work around.

For MyField in MyTable

Create a textobject with the required text
Set textcolor to whatever color you want
Set the background color to the color that lays behind (or leave it
transparent)
Create a conditional format for the object. Formula is not IsEmpty (
MyTable::MyField )
Set the conditional text color to the backgroundcolor

Make the background of Myfield transparent

Move the text object under the field and make it fit exactly

Hou je goed / keep well,

Ursus

"dvfx" schreef in bericht
news:4f361b9a-1fc8-42df-bd6d-2633380d5f2a (AT) r4g2000prm (DOT) googlegroups.com...

Is there a way to display the name of the field if the field is
empty? If there was any way to have it display as it does in layout
mode, that would be perfect.

Any suggestions appreciated.

Reply With Quote
  #3  
Old   
David Jondreau
 
Posts: n/a

Default Re: Display name of field if field is empty - 04-06-2011 , 02:30 PM



On Apr 5, 9:18*pm, dvfx <damien... (AT) gmail (DOT) com> wrote:
Quote:
Is there a way to display the name of the field if the field is
empty? *If there was any way to have it display as it does in layout
mode, that would be perfect.

Any suggestions appreciated.
Set the fill to "empty". Set the conditional formatting for not
isEmpty ( Self ) with a result of a fill the same as the background.
Place a text box behind the field with the name of the field.

When the field is empty, the fill will be blank and the text label
will show through. When the field has a value, the field will have a
fill and hide the label.

DJ

www.wingforward.net

Reply With Quote
  #4  
Old   
Lynn Allen
 
Posts: n/a

Default Re: Display name of field if field is emptyX-TraceApproved - 04-06-2011 , 04:35 PM



On 2011-04-05 20:18:48 -0700, dvfx <damienvfx (AT) gmail (DOT) com> said:

Quote:
Is there a way to display the name of the field if the field is
empty? If there was any way to have it display as it does in layout
mode, that would be perfect.
Yes. In FM10 or above, you can put whatever you want into the field
comments, such as "First Name" (I do this because my field name is
"NameFirst"), then make the field an auto-enter calc to show the field
comments unless there is content in the field.

Case(IsEmpty(Self);

FieldComment ( Get ( FileName ) ; Get (FieldName ) )

; Self) <- this calc could be wrong, it was months ago

Then whenever the field is empty, it will trigger the calc, and "First
Name" will show up.

Be aware not to use this on fields where it might not be obvious what
the field is later on when it's filled in. Names are obvious, but some
fields always need a visible label, even when they have contents.

That's why I stopped using the above shortly after I started. It turned
out that distinguising among a bunch of fields on a screen after the
labels had been written over with data was too hard.
--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

Reply With Quote
  #5  
Old   
Jens Rasmussen, Fimano, Denmark
 
Posts: n/a

Default Re: Display name of field if field is empty - 04-07-2011 , 03:07 PM



Great, Lynn, as always. :-)
FMST podcast has spoken on the topic too.
Rgds & happy fm'ing,
Jens Rasmussen
FileMaker 11 Certified Developer

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.