We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 4172
    • 5,888 Posts
    in the two configs for SellerNotes and LeadNotes, you need:

        "check_resid":1,
        "check_resid_TV":"",
        "join_alias":"Seller",
        "has_jointable":"no",

    and
        "check_resid":1,
        "check_resid_TV":"",
        "join_alias":"Lead",
        "has_jointable":"no",
      -------------------------------

      you can buy me a beer, if you like MIGX

      http://webcmsolutions.de/migx.html

      Thanks!
      • 37143
      • 74 Posts
      thanks Bruno, I am getting closer. I have the migxDB TV items getting saved and appearing in the grid. However, I can't edit/delete any of them, just add.

      Also, in the Leads Grid, the notes do not display anymore (i was using getimagelist before with success).

      I checked for my ID field, which I believe I have setup properly. I have used the schema you posted in last note.

      Can u advise?

      {
        "formtabs":[
          {
            "MIGX_id":3,
            "caption":"Notes",
            "print_before_tabs":"0",
            "fields":[
              {
                "MIGX_id":9,
                "field":"note",
                "caption":"Enter the note below",
                "description":"",
                "description_is_code":"0",
                "inputTV":"",
                "inputTVtype":"richtext",
                "validation":"",
                "configs":"",
                "restrictive_condition":"",
                "display":"",
                "sourceFrom":"config",
                "sources":"",
                "inputOptionValues":"",
                "default":"",
                "useDefaultIfEmpty":"0",
                "pos":1
              },
              {
                "MIGX_id":10,
                "field":"author",
                "caption":"Your Name",
                "description":"",
                "description_is_code":"0",
                "inputTV":"",
                "inputTVtype":"hidden",
                "validation":"",
                "configs":"",
                "restrictive_condition":"",
                "display":"",
                "sourceFrom":"migx",
                "sources":"",
                "inputOptionValues":"",
                "default":"@CHUNK getuser",
                "useDefaultIfEmpty":"0",
                "pos":2
              },
              {
                "MIGX_id":20,
                "field":"id",
                "caption":"",
                "description":"",
                "description_is_code":"0",
                "inputTV":"",
                "inputTVtype":"",
                "validation":"",
                "configs":"",
                "restrictive_condition":"",
                "display":"none",
                "sourceFrom":"config",
                "sources":"",
                "inputOptionValues":"",
                "default":"",
                "useDefaultIfEmpty":"0",
                "pos":3
              },
              {
                "MIGX_id":21,
                "field":"date",
                "caption":"",
                "description":"",
                "description_is_code":"0",
                "inputTV":"",
                "inputTVtype":"date",
                "validation":"",
                "configs":"",
                "restrictive_condition":"",
                "display":"",
                "sourceFrom":"config",
                "sources":"",
                "inputOptionValues":"",
                "default":"now",
                "useDefaultIfEmpty":"0",
                "pos":4
              }
            ],
            "pos":1
          }
        ],
        "contextmenus":"update||duplicate||recall_remove_delete||remove",
        "actionbuttons":"addItem",
        "columnbuttons":"update||duplicate||recall_remove_delete||remove",
        "filters":"",
        "extended":{
          "migx_add":"Add Note",
          "disable_add_item":"",
          "add_items_directly":"",
          "formcaption":"",
          "update_win_title":"",
          "win_id":"notes",
          "maxRecords":"",
          "addNewItemAt":"bottom",
          "multiple_formtabs":"",
          "multiple_formtabs_label":"",
          "multiple_formtabs_field":"",
          "multiple_formtabs_optionstext":"",
          "multiple_formtabs_optionsvalue":"",
          "actionbuttonsperrow":4,
          "winbuttonslist":"cancel||done",
          "extrahandlers":"",
          "filtersperrow":4,
          "packageName":"leads",
          "classname":"Notes",
          "task":"",
          "getlistsort":"",
          "getlistsortdir":"",
          "sortconfig":"",
          "gridpagesize":"",
          "use_custom_prefix":1,
          "prefix":"crm_",
          "grid":"",
          "gridload_mode":2,
          "check_resid":1,
          "check_resid_TV":"",
          "join_alias":"",
          "has_jointable":"yes",
          "getlistwhere":"",
          "joins":"",
          "hooksnippets":"",
          "cmpmaincaption":"",
          "cmptabcaption":"",
          "cmptabdescription":"",
          "cmptabcontroller":"",
          "winbuttons":"",
          "onsubmitsuccess":"",
          "submitparams":""
        },
        "columns":[
          {
            "MIGX_id":4,
            "header":"ID",
            "dataIndex":"id",
            "width":"",
            "sortable":"false",
            "show_in_grid":"0",
            "customrenderer":"",
            "renderer":"",
            "clickaction":"",
            "selectorconfig":"",
            "renderchunktpl":"",
            "renderoptions":"",
            "editor":""
          },
          {
            "MIGX_id":1,
            "header":"Note",
            "dataIndex":"note",
            "width":500,
            "sortable":"false",
            "show_in_grid":1,
            "customrenderer":"",
            "renderer":"",
            "clickaction":"",
            "selectorconfig":"",
            "renderchunktpl":"",
            "renderoptions":"",
            "editor":"this.textEditor"
          },
          {
            "MIGX_id":2,
            "header":"Author",
            "dataIndex":"authorname",
            "width":50,
            "sortable":"false",
            "show_in_grid":1,
            "customrenderer":"",
            "renderer":"this.renderChunk",
            "clickaction":"",
            "selectorconfig":"",
            "renderchunktpl":"[[+author:userinfo=`username`]]",
            "renderoptions":"",
            "editor":""
          },
          {
            "MIGX_id":3,
            "header":"Date",
            "dataIndex":"date",
            "width":75,
            "sortable":"false",
            "show_in_grid":1,
            "customrenderer":"",
            "renderer":"this.renderDate",
            "clickaction":"",
            "selectorconfig":"",
            "renderchunktpl":"",
            "renderoptions":"",
            "editor":""
          }
        ]
      }





      Quote from: Bruno17 at Feb 23, 2016, 07:16 PM
      in the two configs for SellerNotes and LeadNotes, you need:

          "check_resid":1,
          "check_resid_TV":"",
          "join_alias":"Seller",
          "has_jointable":"no",

      and
          "check_resid":1,
          "check_resid_TV":"",
          "join_alias":"Lead",
          "has_jointable":"no",
      [ed. note: [email protected] last edited this post 8 years, 2 months ago.]
        • 4172
        • 5,888 Posts
        doesn't look bad to me.
        Does it work, when you set the system-setting 'debug' to 0?
          -------------------------------

          you can buy me a beer, if you like MIGX

          http://webcmsolutions.de/migx.html

          Thanks!
          • 37143
          • 74 Posts
          no, didnt seem to do anything when i added 0

          Quote from: Bruno17 at Feb 23, 2016, 07:51 PM
          doesn't look bad to me.
          Does it work, when you set the system-setting 'debug' to 0?
            • 4172
            • 5,888 Posts
            possible to have access to the manager?
              -------------------------------

              you can buy me a beer, if you like MIGX

              http://webcmsolutions.de/migx.html

              Thanks!
              • 37143
              • 74 Posts
              of course, ok to email you?

              Quote from: Bruno17 at Feb 23, 2016, 08:01 PM
              possible to have access to the manager?
                • 4172
                • 5,888 Posts
                email or PM, yes
                  -------------------------------

                  you can buy me a beer, if you like MIGX

                  http://webcmsolutions.de/migx.html

                  Thanks!
                  • 37143
                  • 74 Posts
                  thanks, sent you an email, please check your spam in case....

                  Quote from: Bruno17 at Feb 23, 2016, 08:30 PM
                  email or PM, yes
                    • 4172
                    • 5,888 Posts
                    see, how I did the LeadNotes-grid under Leads and the config named 'leadnotes'
                    you will need to make the same for SellerNotes and have another config named 'sellernotes'
                      -------------------------------

                      you can buy me a beer, if you like MIGX

                      http://webcmsolutions.de/migx.html

                      Thanks!
                      • 4172
                      • 5,888 Posts
                      btw.: we are a bit off-topic now
                        -------------------------------

                        you can buy me a beer, if you like MIGX

                        http://webcmsolutions.de/migx.html

                        Thanks!