Hi! I have the following editable grid, in which some values are passed from another record and other ones are completed by the user
When I run the process model, it seems to work properly, auto-generated values appear and the user completes the rest of values:
But after this, the auto-completed values don´t appear in the record! I´m using a WriteRecords function directly in the interface, not in the process model
My configuration is the following one:
I´m using the fv!item to save the values into the local variables, the appending to create new rows and finally using the writeRecords function. But it fails for the variables in which the value is a rule input from a previous interface (idFactura, idPedido, proveedor). The rest of them are saved correctly. What can I do? Thanks a lot!
My code is the following:
a!localVariables( local!data, { a!gridLayout( label: "A continuación, incorpore las líneas de factura correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), 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:"ICON") }, rows: a!forEach( items: local!data, expression: a!gridRowLayout( contents: { a!textField(value:ri!recordFact['recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{6f993c32-7f64-424a-859f-d779194c4a18}id_factura'], saveInto: {fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{9c440183-9c71-423b-a300-eb4c3ea747fb}idFactura']} ), a!textField(value:ri!recordFact['recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{e8009662-ca1c-43da-9c72-2840463214be}id_pedido'], saveInto: {fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{60774c8e-9b47-486f-9fea-b32c525c05fd}idPedido']} ), a!textField(value:ri!recordFact['recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{c2a60669-567e-41b8-acdd-29729912b3e5}nomProveedor'], saveInto: {fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{844be35b-6de5-434e-9c69-e7c7b8a148dd}proveedor']} ), a!textField(value:fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{019eb28b-727b-4e2c-8160-1bcf8a747ef1}material'], saveInto: {fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{019eb28b-727b-4e2c-8160-1bcf8a747ef1}material']} ), a!floatingPointField( value: fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'], saveInto: {fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'], a!save(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{53f231a2-9bf7-40a1-af07-74373fa7bd9f}importe'],if( or(isnull(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad']), isnull(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'])), 0, fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'] * fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'] ) )}, required: true, validations: {if(a!isNotNullOrEmpty(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'])=false,"", if( fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'] < 0, "El precio unitario debe ser superior a cero", "" ))}), a!integerField( value: fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'], saveInto:{fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'], a!save(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{53f231a2-9bf7-40a1-af07-74373fa7bd9f}importe'],if( or(isnull(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad']), isnull(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'])), 0, fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'] * fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'] ) )}, required: true, validations: {if(a!isNotNullOrEmpty(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'])=false,"", if( fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'] < 1, "La cantidad debe ser superior a cero", "" ))}), a!floatingPointField( value: if( or(isnull(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad']), isnull(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'])), 0, fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{b1b5fc0b-5be4-45be-8342-381cdc56017d}cantidad'] * fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{eda9bda7-ae57-44e7-a651-d097c8581021}precioUnit'] ), saveInto: {fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{53f231a2-9bf7-40a1-af07-74373fa7bd9f}importe']}, required: true, validations: {if(a!isNotNullOrEmpty(fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{53f231a2-9bf7-40a1-af07-74373fa7bd9f}importe'])=false,"", if( fv!item['recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura.fields.{53f231a2-9bf7-40a1-af07-74373fa7bd9f}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!data, fv!index), saveInto: local!data ), linkstyle: "STANDALONE", color: "NEGATIVE" ) } ) } ) ), addrowlink: a!dynamicLink( label: "Añadir nueva Línea de Factura", value: append( local!data, 'recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}CPF Lineas Factura'() ), saveInto: local!data ) ) , a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Completar Creación Factura", saveInto: a!writeRecords( records:local!data, onSuccess: {a!save(local!data, fv!recordsUpdated) } ), submit: true, style: "PRIMARY", validate:true ) }, secondaryButtons: { a!buttonWidget( label: "Cancelar", value: true, saveInto: ri!cancel2, submit: true, style: "NORMAL", validate: false ) } ) } )
Discussion posts and replies are publicly visible
And the problem with your first 3 columns is, the data you're using to auto-populate the values would never actually be saved into the saveInto target - because as always, the saveInto for a component only ever executes after the user has interacted with the component (i.e. has entered a changed value for it). If you wish the values in question to also appear in the local!data record value, you'd need to make sure each row in local!data already has the necessary value at the point of creation, in which case you'd be able to set the "value" and "saveInto" parameters both to reference the fv!item[field] data you've already stored.
FWIW, i've amended your AddRowLink code to (approximately) represent what you'd need to do to initialize the values for those three columns appropriately, considering you seem to be loading them based on the static value of a single-row Rule Input upon creation. You'll need to adjust the "record type data" calls manually after putting this back into your interface, since the references don't translate to/from Plaintext very well.
addrowlink: a!dynamicLink( label: "Añadir nueva Línea de Factura", /* the "value" parameter here is 100% unnecessary - just do everything within your a!save() statement */ /* value: append( local!data, 'recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}'( idFactura: ri!recordFact[id_factura], idPedido: ri!recordFact[id_pedido], nomProveedor: ri!recordFact[proveedor] ) ), */ saveInto: a!save( target: local!data, value: append( local!data, 'recordType!{6e637180-b344-49d2-a1f7-f87eed0041ba}'( idFactura: ri!recordFact[id_factura], idPedido: ri!recordFact[id_pedido], nomProveedor: ri!recordFact[proveedor] ) ) ) )
Thanks a lot! I I was writing the first response and did not see it until I send the message. I´m going to try this to see if I can make this work properly!
carlosp5114 said:I´m going to try this to see if I can make this work properly!
Great, please keep me posted!
Hi Mike, I tried to put this as you have shown me (I changed the local variable name "data" for "grid" in all cases:
When I try to create a new row, the following error appears: "Interface Definition: Expression evaluation error [evaluation ID = 4N73O] : An error occurred while executing a save: Expression evaluation error at function 'append' parameter 2 [line 107]: Keys must be record field references or record relationship references"
docs.appian.com/.../reference-records.html
carlosp5114 said:I changed the local variable name "data" for "grid" in all cases
As long as that's still the one you're referencing for your Grid Row Layout a!forEach(), then that should be fine.
carlosp5114 said:Keys must be record field references or record relationship references"
My suggested code may have been a touch misleading. The highlighted items here will need to be changed to recordtype field references the fields of recordType!CPS Lineas Factura.
Thanks a lot Mike! I changed this and works properly!
Now I´m trying to unify both interfaces (invoice creation + invoice lines).
But the fact is that, in the code I passed you yesterday, I was using the WriteRecords function inside the interface. And Stephan told me that the best practice was not to use it at the same time as the Write Records Smart Service.
By now, I´m storing the editable grid new values in the local variable (local!grid). But I want this info to be passed to a rule input, and then to the process model. How can I afford this?
This is how I was saving the values: