Key-Value / table extensions

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PiotrGo
    Junior Member
    • Jan 2024
    • 2

    #1

    Key-Value / table extensions

    Hi,

    While working with EspoCRM, I noticed that there is no field type that could dynamically and flexibly store multiple key-value values.

    With the help of AI, I created an extension that adds a new field type: key-value.

    It makes it possible to build everything from simple fields with a single value to complex tables with multiple headers, summaries, coloring, sorting and filtering functions, and finally Excel export.
    Each value can be a link to another place in EspoCRM or to any other location.

    I’m looking for someone to collaborate with who could help polish minor bugs and turn this into a commercial product.

    Formula Script functions for handling it:
    • keyValue\addKey(JSON, KEY_OR_INDEX, VALUE, [ALIGN], [LINK], [VIEW_MODE], [STYLE])
    • keyValue\addTableRow(JSON, ROW_KEY, COL2, COL3, ...)
    • keyValue\addValue(JSON, KEY_OR_INDEX, VALUE, [ALIGN], [LINK], [VIEW_MODE], [STYLE])
    • keyValue\appendTableRow(JSON, ROW_KEY, COL2, COL3, ...)
    • keyValue\get(JSON, KEY_OR_INDEX)
    • keyValue\removeKey(JSON, KEY_OR_INDEX)
    • keyValue\removeValue(JSON, KEY_OR_INDEX, VALUE_OR_INDEX, [ALIGN], [LINK], [VIEW_MODE], [STYLE])
    • keyValue\setTableHeaders(JSON, HEADER_KEY, HEADER2, HEADER3, ...)
    • keyValue\setTableSort(JSON, COLUMN_NAME_OR_INDEX, [DIRECTION])



      Simple table ASC / DESC sorting:



      Filtering, number of filtered rows / total:
      ​​​

      List view,
      ​​

      ​​a table with multiple header rows:​​
  • rabii
    Active Community Member
    • Jun 2016
    • 1384

    #2
    sounds interesting - i can help
    Rabii
    EspoCRM Custom Development

    🔗 Portfolio & Builds

    Comment

    Working...