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
-
Do you mean a simple list of staff like in field "formular"?
-
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)
-
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)
Content aside
- vor 2 JahrenZuletzt aktiv
- 6Antworten
- 34Ansichten
-
2
Folge bereits