Solved

Creating a field to combine text and image header

Posted on 2007-03-26
17
293 Views
Last Modified: 2010-04-27
I have a layout that involves headers that are image containers, with text beneath.

If there are 3 sections, each with its own header and text, I want to create a calculation that will hide the header and text if the text field for a specific record is blank.

I tried creating a summary calculation field that combines all the headers and text, but it seems that a sumary field cannot be a combination of image and text at the same time.
0
Comment
Question by:jarrodprice
  • 7
  • 5
  • 3
17 Comments
 
LVL 19

Expert Comment

by:billmercer
ID: 18799822
You can create an unstored calculation field of type container, which evaluates your text field, and either returns the contents of another container field, or nothing.

However, even if the calculation evaluates to nothing, the field itself will still take up space on the layout, so this may not help you.

It would help to know more about your goal. Are you trying to print a report that will have different headers on each page depending on some field? Or is this for browsing/data entry purposes?

0
 

Author Comment

by:jarrodprice
ID: 18799906
It is actually a wine tasting note with 3 sections "Background", "Tasting Note" and "Reviews".

Each section has a heading.  Currently 1 field that merges all 3 sections, so that there are no gaps between them.  What I would prefer, is to use an image for each heading stored in a container.  The only one of the three sections that may or may not appear depending on the wine is the reviews section.  Since this appears last, a gap would be fine.
0
 

Author Comment

by:jarrodprice
ID: 18800371
Really, what I want is to combine text fields and image containers in the same calculated container.  This does not seem to be possible.
0
ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

 
LVL 28

Expert Comment

by:lesouef
ID: 18804802
a summary works on numerics.
what you need is a concatenation.
mixing up text and images in a container won't work.
and why would you do this? to hide the empty ones? to hide a text field, use a <<merge>> field.
to hide a container, use the printing/silding feature.
(not sure I understand yr pb)
0
 

Author Comment

by:jarrodprice
ID: 18804939
Here is my layout:

image container (header)
textfield1

image container 2
textfield2

image container3
textfield3

Each text field is a paragraph to 3 paragraphs long, depending on the record.

How do I concatenate the 3 fields and 3 image containers so that there is no white space between them
0
 
LVL 19

Expert Comment

by:billmercer
ID: 18809592
True, you cannot combine text and images in a single field. I don't know how this could be done of any database that would allow this.

If I understand you correctly, you should be able to get this simply by using the Sliding/Printing option as Lesouef mentioned.
Just select the fields, go to the Format menu, and choose the Sliding/Printing option. Then check the option to slide up based on all above. You might also want to check the option to reduce the size of the enclosing part. This causes text boxes with small amounts of text to shrink up, allowing items under it to slide up higher on the page. (This only works for printouts and preview mode, you can't see the effect in browse mode.)
0
 

Author Comment

by:jarrodprice
ID: 18812917
I tried this as a first option.  It had absolutely no effect on the printout.

I am amazed that this is such an issue.
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 18813119
printing/sliding is quite tricky, there may be something wrong in yr layout which prevents the effect to work. can we see the layout?
0
 

Author Comment

by:jarrodprice
ID: 18818370
After much fiddling, I got it working, but with some issues.

The image container that I am using for the headers, I wanted to be a repeating calculation field, that also checks for contents for the field below it, and if it is empty, does not appear.

It seems that repeating fields dont slide, and using case in the calculation also prevents sliding.
0
 
LVL 19

Expert Comment

by:billmercer
ID: 18820574
Container fields will slide up on the page, but they will not shrink to fit. A case statement in the calculation should not have any effect on sliding or printing, I think there's some other reason for what you're seeing.

Why use a repeating field? Each repetition displayed will occupy space on the layout.

If you want more layout flexibility, you might want to look into using the Web Viewer feature of Fp8.5, and creating HTML tables to display your content.

I'm still not sure we really understand what you want your layout to look like.

0
 
LVL 28

Expert Comment

by:lesouef
ID: 19339596
it's normally not jarrodprice's style, leave him a few days, he'll be back I think, but he has so many Qs that he probably looses a few in his (supposed) mess!
0
 
LVL 19

Expert Comment

by:billmercer
ID: 19343176
The comment that was accepted here as an answer is not an answer to the question in any way that I can see. Is this a mistake?

0
 

Author Comment

by:jarrodprice
ID: 19344361
After Leseufs comment I accepted, I went back and figured out that there was something wrong in my setup.   His was the correct solution.
0
 
LVL 19

Expert Comment

by:billmercer
ID: 19359008
> His was the correct solution.

My point is that Lesouef's comment that there may be something wrong is not a solution, it's just a general observation.

You really should select the actual specific comments that provided the answer for you, not just any comment made by that expert.

Part of the value of EE is for other people who come along later looking for answers to similar questions. "There was something wrong with my setup" is not useful information to anyone.

What was the actual problem, and what did you do to fix it?

0
 

Author Comment

by:jarrodprice
ID: 19359085
If you look above, I explained what I did right after Leseuf's comments.  I am not sure what the issue is here.
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question