Jump to content

DoDoTwin

Members
  • Content Count

    13
  • Joined

  • Last visited

Posts posted by DoDoTwin


  1. Hi Mathilda,

     

    After working and adding code, I figured out that:

    1- The HTML block with the code is adding 1 column.

    2- It's not possible to have 2 HTML blocks.

    => It means that on 1 DataPage, we CAN'T color more than 1 field/Column. I would like to color several fields/columns depending on values.

    For example,  I would I have several columns like: Name, Sex, Age, Income and to color the text of 1 cell depending on the conditions.

    Please see below my code :

    <div id="mydiv[@field:Agent_ID#]"> </div>

    <SCRIPT LANGUAGE="JavaScript">

    if ("[@field:Agent_Sex]" == "M"){ document.getElementById("mydiv[@field:Agent_ID#]").innerHTML ="<span style='color:blue;'> [@field:Agent_Sex] </span>"; }

    else{ document.getElementById("mydiv[@field:Agent_ID#]").innerHTML ="<span style='color:pink;'> [@field:Agent_Sex] </span>"; }

    </SCRIPT>

    I would like a code that DO NOT add a column or if I can have several checks on several columns.

    Is it possible to create a code in footer or in the wordpresspage?

     

    Thanks


    Dorian

     

     


  2. Hi,

    I tried your code in a HTML Block:

     

    <div id="mydiv[@field:Agent_ID#]"> </div>

    <SCRIPT LANGUAGE="JavaScript">

    if ("[@field:Agent_Name]" == "Jason"){ document.getElementById("mydiv[@field:Agent_ID#]").innerHTML ="<span style='color:blue;'> [@field:Agent_Name] </span>"; }

    else{ document.getElementById("mydiv[@field:Agent_ID#]").innerHTML ="[@field:Agent_Name]";

     

    When I do a preview, I can see the code above with IDs. But not the name in blue.

    Please find attached a screenshot of the preview page.

     

    Thanks

     

    Dorian

     

     

    Capture.JPG


  3. Hello,

     

    I changed the parameters (font, style, size and so on) of 1 default style (Caspian). But I would like to RESET my modifications as it doesn't seem good.

    It has been saved. Is it possible to RESET my modifications and to come back to the original settings?

    There is a RESET button/ink but it's for the current session.

     

    Thanks


    Dorian

     


  4. Hello.

    I have 2 tables: "Property" and "Lease".

    1 property can have N leases.

    1 lease have a Start and End dates and also a lease amount.

    I woud like to return the current lease (Lease ID and the lease amount)

    For example, there are 2 leases:

    (1) Jan 1st 2012 to December 31st 2014 for $1000 per month

    (2) Jan 1st 2015 to December 31st 2017 for $1100 per month

    Today is November 9th 2016. So at the date of today the lease to return is lease #2 and $1100 for the lease amount.

    How is it possible to return a row and some data depending of criteria? Datapages? Views? Pivot tables?

     

    Thanks


    Dorian


  5. Hello,

     

    I have 2 tables named  "property" and "Rent" joined with Rent.PropertyID and Property_ID

    1 property can have multiple rents.

    Property Table: Property_ID; Property_Address

    Rent Table:  Rent_ID; Property_ID; Rent_Amount

    If I create a Tabular form, I will see for example in the result page: Rent_ID = 1; Property_ID = 1; Rent _Amount = $1000.

    I will be able to delete, edit and add. But I will see Property_ID =1 and not the Property_Address. For a final user "1"doesn't mean anything.

    So, I create a VIEW with the tables "Property" and "Rent". I can see the property Address in the result page. However it's impossible to Edit, Add or Delete.

    Is there a solution to edit at least (to change the rent_amount or the property address if it has been inserted by mistake)?

     

    Thanks

     

     

     

     

×
×
  • Create New...