• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Linked fields in Lotus

U

uethello

Member
I'm using Lotus 1-2-3 to create a database. When a person enters a zip code in one field, I want it to automatically be input in another field on the same sheet. These Zip code fields will be for a PO box Address and a physical address. The zip codes will probably be the same, but I want the second field to be able to be changed, manually if needed.

Can anybody help me with this?
 
Well, you won't be able to use a formula in the cell AND have the ability to overwrite it cleanly, unless you do something wacky like have a third 'override' field for entry of the zip. The 2nd field w/ the formula would do something like:

if(isblank(3rd),1st,2nd)

If you have smartsuite, try using Approach. It's probably a better solution, and as far as database programs go, it's one of the easiest to learn.

You can also check out http://www.xpertss.com/

You should be able to find more info there on all of the smartsuite components.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top