Hi all,

I have three questions:

 

QUESTION 1

I have a tooltip calculation that DOES NOT work:

FieldComment ( Get(FileName) ; template::template_field_name_01 )

 

Then I created a second Tooltip calculation that DOES work:

Get(FileName)

I have assigned these two Tooltip calculations to both Field and Field Labels for testing purposes. What am I doing wrong in the first calculation?

 

QUESTION 2

In my troubleshooting quest and internet search, I came across some Filemaker commenters mentioning putting Tooltips in their own dedicated table. This is interesting and I can see some benefits in doing so (translated versions, access to all Tooltips quickly for editing, etc.)

Has anyone developed a Tooltip Table in this manner and can you share if doing so was relatively easy AND that it DOES actually provide a more convenient way to manage tooltips?

 

QUESTION 3

Is there another method I should strongly consider other than the two I stated above which are: 

1. A "literal" string or calculation in the tooltip; or
2. Tooltip Table

Thank you in advance for your input.

 

Question #1:

The 2nd parameter of FieldComment() is fieldName. You are supplying the field's value. It would work with:

FieldComment ( Get(FileName) ; "template::template_field_name_01" )

but since we don't want to hard-code the field's name, we prefer to use:

FieldComment ( Get(FileName) ; GetFieldName ( template::template_field_name_01 ) )

which can be shortened to:

FieldComment ( "" ; GetFieldName ( template::template_field_name_01 ) )

And if (as one would assume) the tooltip is attached to the field with the comment, you could use simply:

FieldComment ( "" ; GetFieldName ( Self ) )

 

Edited September 15, 20241 yr by comment

On 9/14/2024 at 1:38 PM, comment said:

FieldComment ( Get(FileName) ; GetFieldName ( template::template_field_name_01 ) )

 

Thank you Comment - I appreciate your input: your calculation works exactly as I need.

I have decided to create a Custom Function so I have it handy versus me trying to remember the calculation again and again.

 

If I may continue to inquire...

What are your thoughts on a dedicated table to handle all of the Comments that one may create throughout a database?

It seems having the ability to list all of the comments would be quite handy - especially if one wanted to edit the comments so they were more "uniform" in terminology or sentence structure.

 

I think it depends on the nature of your project.