0

Show and hide the Ninox symbols in your tables centrally.

The database 340_CSS plugin in Team Webinar EN 2012 helps to show and hide the Ninox symbols in your tables centrally.

5 replies

null
    • Sean
    • 2 yrs ago
    • Reported - view

    Very nice Uwe. Who developed this database? The thread title got my hopes up with the word "centrally", but in my view that would mean one could enter the CSS in "Trigger after open". As it is now, a user needs to create a Formula field for every table like "CSSCopy" and put this in the formula... record(CSS_Dashboard,1).CSS. It also needs to be added to every Tab in a Form, otherwise, the CSS won't be executed for that element.

     

    I am developing something similar for styling colors and fonts...

     

    https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-can-i-change-the-font-size-of-a-number-field-5b87f7a2d11f6f5f857be0f6?page=2

    • UweG
    • 2 yrs ago
    • Reported - view

    Hi Sean
    I developped this database. And yes, your right. You have to create in every table a Formula-Field. 
    The simplicity is, that you have in the dashboard a record for every table and can individual show or hide the Ninox-Symbols.
    It includes instructions on how to integrate it into your own existing projects without too much effort. There are 3 csv files attached and a how-to for the installation.
    So far only in German, but easy to translate into your own language with Deepl.
    I already use it in the 0001_Ninox-Reference.
    I also find your link very interesting and it can possibly be integrated into the dashboard.
    Maybe I'm stealing ideas from you ;-)

      • Maurice
      • 2 mths ago
      • Reported - view

       Hello Uwe,

      I downloaded the 340_CSS_Plugin V1-1 Database from the Webinar-Team. Very nice.

      If I do not work in in the formular-view and use the table view: how can I hide the last line including the plus-sign at the buttom of the table to add a new record (under the last record)?

      Maurice

      • UweG
      • 2 mths ago
      • Reported - view

      This is not possible. The functionality in this way is only possible in form views.

      • Maurice
      • 2 mths ago
      • Reported - view

       Thanks Uwe. What a pitty.

      For who it may concern: It was easy to adapt your Dashboard-Customizing to individual Dashboards. I have a table "Rollenmanagement" in which every user has a record. Every User has its own Dashboard. It all works easily with the following code by opening-code of a database:

      let thisMail := userEmail();
      let UserRolle := (select Rollenmanagement);
      let UserExist := cnt(UserRolle[userID = userId()]);
      if UserExist = 0 then
          let UserNeu := (create Rollenmanagement);
          UserNeu.(userID := userId());
          UserNeu.(Benutzername := userFullName());
          UserNeu.(Benutzerrollen := concat(userRoles()));
          UserNeu.(Personal := first((select Personal)['Ninox E-Mail' = thisMail].Nr))
      else
          if UserExist > 0 and
              UserRolle[userID = userId() and Benutzerrollen != concat(userRoles())] then
              UserRolle[userID = userId()].(Benutzerrollen := concat(userRoles()))
          end
      end;
      let my := (select Dashboard where 'Erstellt von' = user());
      if cnt(my) = 0 then
          let new := (create Dashboard);
          openRecord(new)
      else
          openRecord(first(my))
      end
      

      I added a text-field UserID in the CSS_Dashboard table where I put the userId of the user. The CSS-Code in the fx-field in Dashboard-formular is then:

      let vTableID := tableId(this);
      let thisUser := userId();
      html("<style>" +
      first(select CSS_Dashboard where 'Tabellen-ID' = vTableID and UserID = thisUser).CSS_Style)
      

      May it is helpful for others. Of course I get more records in the CSS_Dashboard table, but now I can manage the Dashboard depending of the user.

Content aside

  • 2 mths agoLast active
  • 5Replies
  • 528Views
  • 2 Following