maulanday Posted December 2, 2005 Share Posted December 2, 2005 Does anyone know the calculation for highlighting the text in a field? Link to comment Share on other sites More sharing options...
mr_vodka Posted December 2, 2005 Share Posted December 2, 2005 What do you exactly mean? Do you mean changing the color of the text itself or changing the background of the field? Link to comment Share on other sites More sharing options...
maulanday Posted December 2, 2005 Author Share Posted December 2, 2005 Changing the background of the field. Link to comment Share on other sites More sharing options...
mr_vodka Posted December 2, 2005 Share Posted December 2, 2005 You can have the text field without a background sit ontop of a calc container field. When the criteria for it to change color occurs the field behind it (container) will switch to a image with whatever color you want. Do s search on highlight or higlight portal row etc. and you will seee lots of examples. Link to comment Share on other sites More sharing options...
maulanday Posted December 5, 2005 Author Share Posted December 5, 2005 Mr_Vodka, You seem to be always helpful. I'm sorry if I ask a lot of questions. But, I do need your help. I need to create a calculation field that is similar to a campaign fundraising bar that gets filled in as the capaign gets closer to the goal. This one would represent a project's progress. Is that feasible? And if so is there a website that I can refer to for help. Link to comment Share on other sites More sharing options...
mr_vodka Posted December 5, 2005 Share Posted December 5, 2005 Take a look at this mockup file. Good luck. fundraising.zip Link to comment Share on other sites More sharing options...
Gar Posted December 5, 2005 Share Posted December 5, 2005 I understand you want a graphic "picture" of progress in your project. As I am not experienced at FM8 scripting, I will not give exact formulae. This is more of an overview. For the sake of this I will assume a graph divides in tenths. Field X is your goal. Field Y is your current level. Create field A through J as calc fields (one each for 10% increment) Field A = If Field Y > (Field X * 10%)then format color using formatting directions noted in other threads. Field B = If Field Y > (Field X * 20%)then format color using formatting directions noted in other threads. Continue until final field. Final field will be 100% of goal. End result is ten fields that highlight as the current amount exceeds each of the 10% milestones. Arrange these fields in a vertical alignment and you will have a ladder as you requested. You may add text identifying each increment. Unfortunately I do not know the format field commands. Link to comment Share on other sites More sharing options...
maulanday Posted December 5, 2005 Author Share Posted December 5, 2005 Mr_Vodka... Thank you for the mock-up. But I need it for percentages. Link to comment Share on other sites More sharing options...
maulanday Posted December 6, 2005 Author Share Posted December 6, 2005 Okay. I followed your instructions for using the fundraising mock-up, however. I need one of those for every project. So I can't make it into a global field. Please help. Link to comment Share on other sites More sharing options...
mr_vodka Posted December 6, 2005 Share Posted December 6, 2005 Why would it be a global field? In the mockup it was a calculation with container result that displayed the image. The global fields were used to store the images. Maybe you should post your file so that we can help you achieve your results more smoothly. Link to comment Share on other sites More sharing options...
maulanday Posted December 7, 2005 Author Share Posted December 7, 2005 (edited) Thank you. I figured it out. But I am working the file is from the server. So, when the image i place in the gprogressimage global field disappears. I understand global fields are supposed depend from session to session. It works well on my desktop. But when I share the database on my server, the global field doesn't work. Edited December 7, 2005 by Guest Link to comment Share on other sites More sharing options...
mav Posted December 11, 2005 Share Posted December 11, 2005 have one record that holds your 'images' in standard fields. create a start up script that takes the user to this record, then sets the globals based on the standard fields, then take them to their normal layout. this will 'load' the globals everytime a user logs in . . . Link to comment Share on other sites More sharing options...
mr_vodka Posted December 12, 2005 Share Posted December 12, 2005 For files hosted on Server, global fields will retain their value of the original files hosted on the server. Take a look at my previous post. Previous Post Link to comment Share on other sites More sharing options...
maulanday Posted December 19, 2005 Author Share Posted December 19, 2005 Mr. Vodka, I followed the replicated the fundraiser mock-up and followed LaRetta's instructions for highlight text. Everything seems to be working on my computer, but when I post it to the server, my users are having problems seeing the color. I'm trying to find out how I can save my work as a zip to show you what I mean. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6674 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