0

Help

Mirko

Hi Mirko,

In Dasboard table I place one tab with the name table is a table in HTML , but don't know integrates the event_staff_join to see the staff Name Staff, this is possible ?

Thanks

6 Antworten

null
    • mirko3
    • vor 2 Jahren
    • Gemeldet - anzeigen

    Do you mean a simple list of staff like in field "formular"?

      • Rafael_Sanchis
      • vor 2 Jahren
      • Gemeldet - anzeigen

      MirkoYes I need the list with the Staff with all events and dates if posiible.

      Thanks 

    • mirko3
    • vor 2 Jahren
    • Gemeldet - anzeigen

    Hi, Rafael. Put this Code in a formula-field and try it. It´s another CSS with cool round corners like I haven't seen them anywhere, but you can copy the old form into the new, if you don't like it. Mirko

    let selStaff := record(STAFF,number(this.Staff_Choice));
    let cntRes := cnt((select event_staff_join)[staff = selStaff]);
    let content := "
    <style>
    td,th{
        font-size: small;
        background-color: rgb(230,230,220);
        font-family: 'Courier New';
        padding: .1em 1.5em .1em 1.5em;
    }
    /*dynamic round corners*/
    tr:nth-of-type(1) th:nth-of-type(1)  {
          border-radius: 2em 0em 0em 0em;
    }
    tr:nth-of-type(1) th:nth-of-type(4)  {
        border-radius: 0em 2em 0em 0em;
    }
    tr:nth-of-type(" + (cntRes + 1) + ") td:nth-of-type(1){
        border-radius: 0em 0em 0em 2em;
        }
    tr:nth-of-type(" + (cntRes + 1) + ") td:nth-of-type(4){
        border-radius: 0em 0em 2em 0em;
        }
    </style>
    <table>
            <th>detail</th><th>staff</th><th>date</th><th>type</th>
            " + ((select event_staff_join) order by 'Event Detail'.Date)[staff = selStaff].("
            <tr>
                <td>" + 'Event Detail'.Name_Event + " </td><td>" + replacex(staff.Name_Staff, "[a-z\s']+", "") + "<td>" + 'Event Detail'.Date + "</td><td>" + 'Event Detail'.Type + "</td>
            </tr>
            ") + "
    </table>
    ";
    html(content)
    
      • Rafael_Sanchis
      • vor 2 Jahren
      • Gemeldet - anzeigen

      Mirko Hi Mirko.

      Look very good but something strange ocurss, when delete the old table I los the format o the new one.

    • mirko3
    • vor 2 Jahren
    • Gemeldet - anzeigen

    I misunderstood you, you meant the existing table on tab "Tablet". There is an array of names.

    let cntRes := cnt(select 'EVENTS DETAIL');
    let content := "
    <style>
    td,th{
        font-size: small;
        background-color: rgb(230,230,220);
        font-family: 'Courier New';
        padding: .1em 1.5em .1em 1.5em;
    }
    tr:nth-of-type(1) th:nth-of-type(1)  {
          border-radius: 2em 0em 0em 0em;
    }
    tr:nth-of-type(1) th:nth-of-type(4)  {
        border-radius: 0em 2em 0em 0em;
    }
    tr:nth-of-type(" + cntRes + ") td:nth-of-type(1){
        border-radius: 0em 0em 0em 2em;
        }
    tr:nth-of-type(" + cntRes + ") td:nth-of-type(4){
        border-radius: 0em 0em 2em 0em;
        }
    </style>  <table>
        <thead>
            <tr>
                <th> Staff </th>
                <th> Name Event </th>
                <th> Date </th>
                <th> Type </th>
            </tr>
        </thead>
        <tbody>
            " + ((select 'EVENTS DETAIL') order by Date).("
            <tr>
                <td> " + join(Actv_Staff_join.staff.Name_Staff, ",") + " </td><td> " + Name_Event + " </td><td> " + Date + " </td><td> " + Type + " </td>
            ") + "
        </tbody>
    </table>  ";
    html(content)
      • Rafael_Sanchis
      • vor 2 Jahren
      • Gemeldet - anzeigen

      Mirko Yes is Ok now, Thanks a lot Mirko appreciate your help.👍