10000cranes Posted September 10, 2004 Posted September 10, 2004 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
RalphL Posted September 10, 2004 Posted September 10, 2004 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.
transpower Posted September 10, 2004 Posted September 10, 2004 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now