Grid Plus Configuration error

Looks like the issue is with 'queryRuleName' and 'colConfigRuleName' configuration in your code. Those should have rule! prefix. Please refer below for syntax reference. 

 gridsubmitchanges(
        queryRuleName: rule!RE_queryRule,
        colConfigRuleName: rule!RE_columnConfig,
        createData: local!creates,
        editData: local!edits,
        deleteData: local!deletions,
        createModel: cons!RE_CREATE_OR_UPDATE,
        editModel: cons!RE_CREATE_OR_UPDATE,
        deleteModel: cons!RE_DELETE
      )

i see the configuration in other thread. Nevermind i change but now the result it's this (i'l do the creation, the other action if you see it's disabled).

Great! So your earlier issue is resolved. Would be good if you verify the above answer.

as for this error- The error says some issues lies within a foreach expression where you have a!fromjson(). So can you check the related code block or share here so that we can get some insights and help

This error it's not related to the code that i wrote. After the click on the submit changes in the local!variable "local!submitChanges" i have the error (it's return from the plug-in code).

"{""errorOccurred"":""Expression evaluation error at function a!forEach [line 5]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!fromJson [line 8]: The jsonText parameter was not valid JSON.""}"

okay so lets check few things:

1. Is the processModel mentioned against createModel, has activity chaining enabled across all nodes?

2. Does the processModel has process variable named 'record' in it and has 'Multiple' set to true()?

3. Is the 'colConfigRuleName' mentioned in gridsubmitchanges() same as the columnConfigs in gridpluslayoutField()? 

Also As you have disabled edit and delete, you can remove the related attributes from the gridSubmitChanges code. Earlier code I shared was for reference to show the syntax of queryRuleName and colConfigRuleName. 

now, i'll do all the raccomandation but now i have another error after the submit:

"{""errorOccurred"":""class [Lcom.appiancorp.suiteapi.type.TypedValue; cannot be cast to class [Ljava.util.Map; ([Lcom.appiancorp.suiteapi.type.TypedValue; is in unnamed module of loader com.appiancorp.tomcat.loader.AppianWebappClassLoader @2a49fe; [Ljava.util.Map; is in module java.base of loader 'bootstrap')""}"

I think that the real problem, it's how to configure the rule instead colConfigRuleName (i don't have information abut appian in the documentation). Can you help me?

In line 13 of your code you have columnConfigs, try to replace the expression there with rule!TNSM_columnConfig() . Also is it possible do share the code if the rule if the above doesn't work and errors out still!

I have now this situation:

the rule that i recall it's this:

But i have the error : 

Can you help me?

All the configurations looks good! This component has specific expectation for configuration including no extra commas or not changing the of fields in the gridcolconfig components. For now I can see only two things which are not explicitly mentioned as causing the error but might! 
firstly in line 14, if you do the need hidden values either remove it or make the curly braces proper there without any spaces. You can try making it null as well to see if it works. Similarly try removing validations as well as you are not using jt.  Secondly in the col configs rule extra commas is there. Get rid of that too and retry

I'm seeing a similar error after clicking Submit Changes. See code below.

Also Process model contains a pv called record (multiple + parameter), fully chained

a!localVariables(
  local!submitChanges:{},
  local!creates: {},
  gridPlusLayoutField(
    enableCreate: true,
    enableEdit: false,
    enableDelete: false,
    queryRuleName: rule!FOS_getPPSBasisGridPlusWithFields,
    queryRuleInputs: null,
    columnConfigs: rule!FOS_PPSColumnConfigGridPlus(),
    createDataValue: local!creates,
    createDataSaveInto: local!creates,
    editDataValue: {},
    editDataSaveInto: {},
    deleteDataValue: {},
    deleteDataSaveInto: {},
    submitChangesValue: local!submitChanges,
    submitChangesSaveInto: a!save(
      target: local!submitChanges,
      value: gridsubmitchanges(
        queryRuleName: rule!FOS_getPPSBasisGridPlusWithFields,
        colConfigRuleName: rule!FOS_PPSColumnConfigGridPlus,
        createData: local!creates,
        editData: null,
        deleteData: null,
        createModel: cons!FOS_write_PPS_BASIS,
        editModel: null,
        deleteModel: null
      )
    )
  )
)

I'm seeing a similar error after clicking Submit Changes. See code below.

Also Process model contains a pv called record (multiple + parameter), fully chained

a!localVariables(
  local!submitChanges:{},
  local!creates: {},
  gridPlusLayoutField(
    enableCreate: true,
    enableEdit: false,
    enableDelete: false,
    queryRuleName: rule!FOS_getPPSBasisGridPlusWithFields,
    queryRuleInputs: null,
    columnConfigs: rule!FOS_PPSColumnConfigGridPlus(),
    createDataValue: local!creates,
    createDataSaveInto: local!creates,
    editDataValue: {},
    editDataSaveInto: {},
    deleteDataValue: {},
    deleteDataSaveInto: {},
    submitChangesValue: local!submitChanges,
    submitChangesSaveInto: a!save(
      target: local!submitChanges,
      value: gridsubmitchanges(
        queryRuleName: rule!FOS_getPPSBasisGridPlusWithFields,
        colConfigRuleName: rule!FOS_PPSColumnConfigGridPlus,
        createData: local!creates,
        editData: null,
        deleteData: null,
        createModel: cons!FOS_write_PPS_BASIS,
        editModel: null,
        deleteModel: null
      )
    )
  )
)

I have removed the null parameters in the gridPlusLayoutField(). Can you try with this 

a!localVariables(
  local!submitChanges:{},
  local!creates: {},
  local!edits: {},
  local!deletions:{},
  gridPlusLayoutField(
    enableCreate: true,
    enableEdit: false,
    enableDelete: false,
    queryRuleName: rule!FOS_getPPSBasisGridPlusWithFields,
    columnConfigs: rule!FOS_PPSColumnConfigGridPlus(),
    createDataValue: local!creates,
    createDataSaveInto: local!creates,
     editDataValue: local!edits,
    editDataSaveInto: local!edits,
    deleteDataValue: local!deletions,
    deleteDataSaveInto: local!deletions,
    submitChangesValue: local!submitChanges,
    submitChangesSaveInto: a!save(
      target: local!submitChanges,
      value: gridsubmitchanges(
        queryRuleName: rule!FOS_getPPSBasisGridPlusWithFields,
        colConfigRuleName: rule!FOS_PPSColumnConfigGridPlus,
        createData: local!creates,
         editData: local!edits,
        deleteData: local!deletions,
        createModel: cons!FOS_write_PPS_BASIS,
        editModel:null,
        deleteModel: null
      )
    )
  )
)

New error now using your updated code

Looks like the ediDataValue and deleteDataValue are required. I have updated code in my earlier comment. Try and update accordingly. 

thanks, made those changes and now back to my original error I previously shared.

Oh wow!

In that case I would suggest to get in touch with Appian Support team. All the configuration is as per documentation and should work. 

I have a solution that works from Support:

The product team has confirmed that this is a bug.

It seems that the griddatecolconfig() is expected as one of the column config but in reality it is not required.

The product team is working on the fix.

Meanwhile, you can just add griddatecolconfig() on createdOn field as a column config and let me know if this works.

I have tested this myself, and it does indeed fix the error

Good to know! Thank you for sharing this Guy 

 marcom0706  would be good if you to click Verify Answer for Guy’s latest comment so that others can get quickly refer it if they face similar issue.