Concat() field not working Editable Grid

Question

Hi! I have an editable grid in which the user can add new rows. I have a problem with the field "Clave &Uacute;nica". Its value is the concat() function of other two fields of each row 
 1) It appears correctly written in the editable grid 
 
 2) It seems not to be flowing correctly to my local variable 
 
 What can I do to fix this? Is my code wrong? 
 My code is below (line 60 is where I configure the value and saveInto for the field): 
 a!localVariables(
 local!LineasPedido: {},
 {
 a!sectionLayout(
 label: "L&#237;neas Pedido",
 labelIcon: "list-alt-solid",
 contents: {
 a!gridLayout(
 label: "A continuaci&#243;n, incorpore las l&#237;neas de pedido correspondientes y pulse el bot&#243;n de creaci&#243;n",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Linea Pedido"),
 a!gridLayoutHeaderCell(label: "Pedido"),
 a!gridLayoutHeaderCell(label: "Proveedor"),
 a!gridLayoutHeaderCell(label: "Material"),
 a!gridLayoutHeaderCell(label: "Clave &#218;nica"),
 a!gridLayoutHeaderCell(label: "Cantidad"),
 a!gridLayoutHeaderCell(label: "Precio Unitario"),
 a!gridLayoutHeaderCell(label: "Importe Total"),
 a!gridLayoutHeaderCell()
 },
 columnConfigs: {
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "ICON")
 },
 rows: a!forEach(
 items: local!LineasPedido,
 expression: a!gridRowLayout(
 contents: {
 a!textField(
 value: fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido'],
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido']
 }
 ),
 a!textField(
 value: fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido'],
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido']
 }
 ),
 a!textField(
 value: fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{464f0883-d6d5-4c58-b054-4de8e9e99902}Proveedor'],
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{464f0883-d6d5-4c58-b054-4de8e9e99902}Proveedor']
 }
 ),
 a!textField(
 value: fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e9a834-b2fb-4f35-a36d-3c526c97f4ac}Material'],
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e9a834-b2fb-4f35-a36d-3c526c97f4ac}Material']
 }
 ),
 a!textField(
 value: concat(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido'],
 "-",
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e9a834-b2fb-4f35-a36d-3c526c97f4ac}Material']
 ),
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{caf81eeb-f499-4adc-b078-f2692f6e38b2}ConcatPedidoMaterial']
 }
 ),
 a!integerField(
 value: fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad'],
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad'],
 a!save(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'],
 if(
 or(
 isnull(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad']
 ),
 isnull(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 )
 ),
 0,
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad'] * fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 )
 )
 },
 required: true,
 validations: {
 if(
 a!isNotNullOrEmpty(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad']
 ) = false,
 "",
 if(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad'] < 1,
 "La cantidad debe ser superior a cero",
 ""
 )
 )
 }
 ),
 a!floatingPointField(
 value: fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit'],
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit'],
 a!save(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'],
 if(
 or(
 isnull(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad']
 ),
 isnull(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 )
 ),
 0,
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad'] * fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 )
 )
 },
 required: true,
 validations: {
 if(
 a!isNotNullOrEmpty(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 ) = false,
 "",
 if(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit'] < 0,
 "El precio unitario debe ser superior a cero",
 ""
 )
 )
 }
 ),
 a!floatingPointField(
 value: if(
 or(
 isnull(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad']
 ),
 isnull(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 )
 ),
 0,
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad'] * fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{47f4bf32-2e41-4c5a-a7e7-9fc7786bd753}PrecioUnit']
 ),
 saveInto: {
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe']
 },
 required: true,
 validations: {
 if(
 a!isNotNullOrEmpty(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe']
 ) = false,
 "",
 if(
 fv!item['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'] < 0,
 "El importe debe ser superior a cero",
 ""
 )
 )
 },
 align: "RIGHT"
 ),
 a!richTextDisplayField(
 value: {
 a!richTextIcon(
 icon: "times-circle",
 link: a!dynamicLink(
 value: remove(local!LineasPedido, fv!index),
 saveInto: local!LineasPedido
 ),
 linkstyle: "STANDALONE",
 color: "NEGATIVE"
 )
 }
 )
 }
 )
 ),
 addrowlink: a!dynamicLink(
 label: "A&#241;adir nueva L&#237;nea de Pedido",
 saveInto: a!save(
 target: local!LineasPedido,
 value: append(
 local!LineasPedido,
 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido'(
 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido': ri!record['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido'],
 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{464f0883-d6d5-4c58-b054-4de8e9e99902}Proveedor': ri!record['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{e11e6206-fc23-4a4b-9819-4db5a5bab685}nomProveedor'],
 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{121ba298-9b36-4826-a191-72811974ee3c}createdOn': now() + intervalds(2, 0, 0),
 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{4d0599e0-d6d6-4ad2-9a4a-8e7f3c270de9}createdBy': loggedInUser(),
 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido': count({ local!LineasPedido }) + 1
 )
 )
 )
 )
 )
 }
 ),
 a!buttonLayout(
 primaryButtons: {
 a!buttonWidget(
 label: "Completar Creaci&#243;n Pedido",
 saveInto: a!save(
 ri!recordLineasPedido,
 local!LineasPedido
 ),
 submit: true,
 style: "PRIMARY",
 validate: true
 )
 },
 secondaryButtons: {
 a!buttonWidget(
 label: "Cancelar",
 value: true,
 saveInto: ri!cancel2,
 submit: true,
 style: "NORMAL",
 validate: false
 )
 }
 )
 }
) 
 Thanks a lot!

Stefan Helzle · Accepted Answer

I repeat myself: " Add the concat command to both fields "idPedido" and "Material" to the saveInto." 
 There is a reason why I mentioned these two fields and not the addRowLink. 
 You probably want the value "ConcatPedidoMaterial" to update whenever the user modifies any of the two other values.

Stefan Helzle · Answer

When following my advice, you modify the underlying data. And that is completely independent of whether you display data data or not. That is the whole trick here. Data is data, and is modified on that level. Displaying that data is a whole different topic.

Concat() field not working Editable Grid

Top Replies