Solved

Creating a field to combine text and image header

Posted on 2007-03-26
17
290 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
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now