Articles
Da Honey Pot
About meBizzyBee’s BizzyThoughts
Archive for the 'Formula' Category
If you ever bump into this message when opening, refreshing or saving a document, there’s probably a field on your document breaking the 32K or 64K limit of the maximum field size for simple text fields.
We know the power of action and link hotspots. It would be great if we could create them computed, f.e. to give it a computed description or to create a number of hotspots that can vary. I’m sure you know some applications for this yourself (just nostalgically think of those times you bumped your head against the wall in rage 
).
It turns out not to be that difficult, but there are some gotchas and restrictions. But don’t be afraid, I’ll take you by the hand and show you where the mines are…
How does it look?
It could look like this:
Hide-when formulas often give me headaches. It sometimes seems so much effort just to decide whether or not I have to show a line of text. And there’s always a condition you forget 
.
Hide-when’s tend to get complex. If they get too long or complex, you might want to reconsider your design. I once saw an application with hide-when formulas that needed 2 pages when printed. Needless to say I threw them out…
(4 votes, average: 2.50 out of 5)
Loading ...