Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Creating Labels with repeating fields


This topic is 7380 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I'm a newbie ...

Have a simple database for submitting entries (IWP) for a gallery showing.

Fields are name, title of piece, size and price. Each person can enter five titles (with price and size). The titles, price and size fields are all repeating. I want to create labels for each title (with the artists name,etc.). I've used the get repeating field function to set up layouts for titles 2, 3, 4, & 5. This is ok unless a person has less than five entries; at that point my label layout is creating (wasting) a name label.

How do I create labels for only the titles submitted ... and leave out labels if repeating fields 2,3 and 4 are empty (for example)?

thank you

ps.

I'm not looking for a 'solution'; merely looking for guidance ... as in 'try a portal instead', or a key idea like the name of a function, or a calculation key.

thanks

Posted

I would suggest thst you forget about repeating fields. They are a carryover from FMP2. Use a portal for data entry, it isn't that much different from repeating fields. You can limit the portal to five rows. When printing the labels, print from the related record.

Posted

You can create a compound calculation field which combines the various fields and uses the case function to handle the situtation in which any of the fields are empty.

This topic is 7380 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.