0

Triggering record edition, creation or deletion from a HTML formula field

Being able to "draw" anything using HTML+CSS in a formula field is one of the more powerful features Ninox has to offer.

Sometimes I need to trigger some "internal" Ninox functions within these HTML renders (for example, you can create a custom graph and want to add some buttons that allow to edit a record).

After extensive reading and searching the official Ninox forums, I'm not able to find a proper answer to my question. Some say that Ninext could be the solution, but also that Ninext is deprecated or no longer supported, or also, that better use it in non commercial solutions.

But I still need to "paint" some dynamic content using HTML+CSS and I also need to be able to call some essential Ninox functions, like the ones to show, create or delete a record in a table using the parameters I can pass from within my Script.

For example, I'm developing a solution that manages the categories using a table for storing parent/child relationships. For showing them in a very user friendly way, I'm using a formula field that paints a tree like the following one:

(the source code for the above sample is here: https://iamkate.com/code/tree-views/).

Using Ninox is relatively easy to recreate the above example using "live" the data from my Categories table. But I need to add the ability to at least open the record view of the selected category when the user clicks the category name, and don't know how to communicate with Ninox from this HTML view. 

Any news about this topic? Is possible or better look for another solution?

6 replies

null
    • Fred
    • 13 days ago
    • Reported - view

    popping up records has been covered in this forum. I've attached a sample DB of how it can be done in two ways.

    Here is a list of what can be done in html:

    database.create
    database.update
    database.remove
    ui.openRecord
    ui.popupRecord
    ui.openFullscreen
    ui.closeFullscreen
    ui.closeRecord
    ui.closeAllRecords
    ui.openTable
    ui.openCalendar
    ui.openSearch
    ui.openHome
    
      • Consultant and developer
      • Javier
      • 13 days ago
      • Reported - view

      Great! I'll give it a try!

    • Rafael Sanchis
    • Rafael_Sanchis
    • 13 days ago
    • Reported - view

    Hi Javier 

    also trying to find something similar

    • Consultant and developer
    • Javier
    • 13 days ago
    • Reported - view

    Last but not least: is there a way to add a record to a database? I can't find any example of database.update nor database.create methods, and I'm not sure is this is the proper way to add a new record...