Jump to content

Graphic display in repeating field


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

Recommended Posts

Senerio: Purchase order system using one layout for all departments. This layout has a repeating price field of 75 cells (uses the sliding/printing function). Some departments should not see the pricing entires. Because the font color can not be dynamicly changed (from black to white) I will have to 'mask out' the price fonts from behind using a graphic (similar to a maxicode bar code pattern)in a separate repeating field using the cells as containers.

Problem: Setting the background field as a calculation, how do I bring in a pattern for each cell used in the pricing field? (Pattern is in a gobal container)without have to write 75 statements.

Link to comment
Share on other sites

You don't need to go to this trouble just to hide information. Just replace the price field with a calculated field cDisplayPrice with the formula:

Case(Extend(AllowToSee),Price,"")

The field "AllowToSee" should be a regular field or a global field with a value of 1 when the price should be displayed, and 0 otherwise.

And now for the usual admonition. You shouldn't be using repeating fields. You should have a related line items file.

Link to comment
Share on other sites

This topic is 7553 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.