Expand my Community achievements bar.

NY2CA
NY2CA
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • I downloaded the form. I appreciate your effort, however, the form still does not work. For some reason on your form when you divide the firstlien (450,000.00) into the salesprice of (500,000.00) you get .9% instead of 90.00%. Maybe you changed the format. I can fix that but the color does not chang...

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • Thanks you so much!!! I havent been able to download the form you fixed but I do appreciate your help. The color codes I used came from Kuler. They are$.fillColor = "255,13,255"                elseif ($ gt 90) then                        $.fillColor = "188,40,29"                else                 ...

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • I changed the code today to:Form1.#subform[0].LTV1st::calculate - (FormCalc, client)if(FirstLien gt 0 and SalesPrice gt 0) then                 $ = FirstLien / SalesPrice                if ($ gt 80 and $ lt 90) then                        $.fillColor = "255,13,255"                elseif ($ gt 90) th...

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • I dont know how to upload a form to this site. The form can be downloaded from box.net.The link to the form is: https://www.box.com/s/61n32urjw3xglsjnhjg4Thanks again.

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • Using the following code, the results are the same.if(FirstLien gt 0 and SalesPrice gt 0) then            $ = FirstLien / SalesPriceif ($ gt 80) then                                $.fillColor = "50,62,49"           elseif ($ gt 90) then                                $.fillColor = "75,100,75"      ...

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • Thank you. The only color that works is the "else" fill color of 208. The form does not calculate or change with the percentage. This is the code i'm using.if(FirstLien gt 0 and SalesPrice gt 0) then            $ = FirstLien / SalesPrice           if ($ gt 80) then                                $.f...

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • I am trying to connect the following codes to work together. The way it's constructed one code will work but not the other, this is also true when the code is reversed. The 1st part of the code represents a change in the percentage and the 2nd part of the code calculates the actual percentage.The pe...

    Type

    Questions

    Views

    3.7K

    Likes

    0

    Replies

    18
  • I tried simply cutting and pasting the code you sent. It doesnt calculate with this on top.  If(FirstLien>0 and SalesPrice>0) then LTV1st = FirstLien / SalesPrice;endif if ( LTV1st > 90) then$.fillColor = "255,255,133"elseif (LTV1st >= 80 ) then$.fillColor = "74,165,116"else $.fillColor = "208,208,2...

    Type

    Questions

    Views

    978

    Likes

    0

    Replies

    0
  • It may be easier to send you the form. The code below is the current one i've tried, it does the auto-calc for the percentage field but not the change in color shade. LTV1st.ui.oneOfChild.border.fill.color.value = "74,165,116";var sum = LTV1st;if ( sum >= 80) then$.fillColor = "74,165,116"elseif (su...

    Type

    Questions

    Views

    947

    Likes

    0

    Replies

    0
  • I had changed it before your post, it seems to make no difference. Either the number calculates or the color changes, the code the way I have it constructed doesn't do both.Thanks again.

    Type

    Questions

    Views

    947

    Likes

    0

    Replies

    0