February 17, 200322 yr Hi All! I have a database of pages of a newspaper, and to set it up quickly, every page contains a number of gaps, and every gap is being made to contain a number of ads, each of those is a seperate table. Now, I made a calculation in the pages database that returns the status of the page. If every gap on the page has the field 'Printed' set to 1, then, it equals 2, if some are set to 1 but not all, it equals 1, if none are set to 1, it equals 0. Then, I have a container field, which if the page status is 2, it shows a global field containing a green bar, 1, a yellow bar, 0, a red bar. The purpose of this is so that in the parent DB, where I have a portal showing all the pages, I am dropping a container in the back of each row fo teh portal, to highlight the row in one of thsoe three colors, thus showing the user the status of the pages. There, hopefully that makes sense. Now, the problem is, that normally, the container fields display nothing. If I click on a portal row, then click off, it shows me the color, and the color remains until I change something in the portal, then dissapears again! How can I make them ALL appear ALL the time? Help., p[lease? Sorry to be writing so fast and impersonal, I'm nearing that 'were almost done, so we'd better hurry it up' stage of my project!!!
February 17, 200322 yr Hi Keshavi, You probably do have fields in that portal apart from the container calc. Can you disallow entry for the fields in your portal ? This would help a lot... If not, you could change your mind and only show this color at the end right of your portal, instead of having all rows highlighted.
February 18, 200322 yr Author Well, I do have all the fields set to no entry. I had that already. There are a few buttons in the portal, but they are not overlapping the container either. I also tried just deleting all the fields except the container - same thing.
February 18, 200322 yr Author Well update - I CAN make the fields appear, by hiding the window under the windows menu, and then showing iit again. I know I can do this in a script, but then every time anything moves in the portal, the screen will have to flash. Anybody else have a good procedure for this?
February 18, 200322 yr I also tried just deleting all the fields except the container - same thing. This should not be the same thing... How is your container set into the portal row ?
February 19, 200322 yr Author It is set one pixel in and one pixel down from the origin of the row, and it is sized 2 pixels narrower and 2 pixels shorter than the row, so that it is contained ientirely within the portal row.
February 19, 200322 yr Here are a set of four portals with three different colors. Have a look and tell. Excuse me for the colors. I read that someone in that forum loves lime green and Lilla colors
February 19, 200322 yr Author Wow,those colors had personality . And they work fine on my system. In all honesty, I think the problem here lies in the calculation that determines the field not updating, not in the field not being visible. But what do I know?
Create an account or sign in to comment