April 19, 200124 yr I have three fields: (F_Size_Bytes, F_Size_KBytes, F_Size_MBytes). I want to be able enter data into anyone of these three and automatically have the other two updated. If this is impossible then how could i have a fourth field (F_Size) be the total number of bytes (even though i inputed say MegaBytes): I understand the math concept (*1024 or /1024) i just don't know how to get filemaker to work this way. One other possible solution is like the one @ http://javascript.internet.com/calculators/download.html where there is only one input field but you press a button to choose the measurement. I would really appreciate some help on this one! (so would my boss )
April 20, 200124 yr Okay, assuming you will only enter one of the fields, you can use the following guide for the fourth calc field: Case(not IsEmpty(F_Size_Bytes), F_Size_Bytes , not IsEmpty(F_Size_Kbytes), F_Size_KBytes * 1024, not IsEmpty(F_Size_MBytes), F_Size_Mbytes / 1024, "") To do it the other way, entering one number and pressing a button to convert it to whatever you want would be fairly simple as well, but I would probably stick with the above. If you want to try the button thing, let us know and I or someone will help you work it out. Jeremy
Create an account or sign in to comment