richshone Posted June 29, 2000 Share Posted June 29, 2000 I want to be able to type in the miles needed to travel somewhere and have another field calulate the km for me. That part is easy, but can I do the same in reverse as well so it won't matter which one I type into first? It would seem to be a circular reference problem, especially since I can't type into a calculation field in the first place...any ideas? Link to comment Share on other sites More sharing options...
filecrazy Posted June 29, 2000 Share Posted June 29, 2000 Try creating 4 fields: Miles Entry, KM Entry, Miles Calculation and KM Caluculation. In your layout, format the two calculation fields without allowing entry into the field. Place the Miles Entry field over the Miles Calculation and do the same for the KM fields. Make sure all fields are formatted to be transparent. When you tab to Miles or KM, you will be allowed to enter into the Entry field and the calculated result will appear in the opposite Calculation field. Good luck. Link to comment Share on other sites More sharing options...
richshone Posted June 29, 2000 Author Share Posted June 29, 2000 I tried your suggestion and found two problems. 1 - I can't find a 'transparent' field function that lets me see only one field and type in another without having trouble seeing the resulting calculation on the other pair of fields, and 2 - I need a calculation formula that is an 'if' formula (as in 'if' one field is typed into, then the other result changes too - as well as the reverse), make sense? So far my formula only changes the calc field...Is this possible? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted June 29, 2000 Share Posted June 29, 2000 quote: Originally posted by richshone: I tried your suggestion and found two problems. 1 - I can't find a 'transparent' field function that lets me see only one field and type in another without having trouble seeing the resulting calculation on the other pair of fields, and 2 - I need a calculation formula that is an 'if' formula (as in 'if' one field is typed into, then the other result changes too - as well as the reverse), make sense? So far my formula only changes the calc field...Is this possible? Actually here is what you do. You first lay down your KM Enty and Mile Entry fields. Next lay down your KM Display and Miles Display calculated field directly on top of them. DO NOT make them transparent, give them a fill color. Next is to go into the field format and uncheck "Allow entry into field". Now when you click on the field it will not allow you to enter the calc field, but will let you entry the data entry field beneath it. Once you click off again your calculated field will update with the new values. Once you do it you will see how simple it is. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www.inthescene.com mailto:[email protected] =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
richshone Posted July 1, 2000 Author Share Posted July 1, 2000 Well I am halfway to solving the problem. I did what you suggested with the entry and display fields and get the result in one of the two fields, the other gets no result until I change the other entry field, which is what I am trying to avoid. Also, as you can imagine, the entry fields underneath the calc fields will be different from the ones on top on them unless I change both as well. Am I making sense? So at this point it seems to be a formulaic problem, not a display one (and by the way, your suggestion for the diplay worked fine - which I am better at understanding anyway). Any ideas? Thanks... Link to comment Share on other sites More sharing options...
richshone Posted July 1, 2000 Author Share Posted July 1, 2000 Well I am halfway to solving the problem. I did what you suggested with the entry and display fields and get the result in one of the two fields, the other gets no result until I change the other entry field, which is what I am trying to avoid. Also, as you can imagine, the entry fields underneath the calc fields will be different from the ones on top on them unless I change both as well. Am I making sense? So at this point it seems to be a formulaic problem, not a display one (and by the way, your suggestion for the diplay worked fine - which I am better at understanding anyway). Any ideas? Thanks... Link to comment Share on other sites More sharing options...
Vaughan Posted August 23, 2000 Share Posted August 23, 2000 Here is a solution that uses 1 less field. Distance is the field that you enter the number in. Units is a field that lets you select either "km" or "miles" Conversion is a calculation field that uses an If statement based on the units field to perform the simple maths. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8655 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 accountSign in
Already have an account? Sign in here.
Sign In Now