Goodnight,
I am creating an application and my workflow does not send the emails, I create a behavior which has an initial state of โopenโ and with the behavior it goes to โcompletedโ my rule does not send the emails and I have a pro account and the project is deployed, thanks for your attention.
If u navigate to workflow sections of u press LOG BUTTON is there any error?
Hi, I get the following error:
Properties:
{
โAppIdโ: โ8822662a-8754-4f90-8f84-5f7d17622d5cโ,
โAppTemplateVersionโ: โ1.000135โ,
โRuleNameโ: โOrderUpdateRuleโ,
โEventTypeโ: โChangeโ,
โInvokedByโ: โUpdateโ,
โServerโ: โprodu99110000J0โ,
โIgnoreSecurityFiltersโ: false,
โTableNameโ: โOrdersโ,
โRuleTableNameโ: โOrdersโ,
โOperationUpdateModeโ: โUPDATES_ONLYโ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โ=AND( [Estado]=โCompletadoโ, [_THISROW_BEFORE].[Estado] <> [_THISROW_AFTER].[Estado] )โ,
โMatchesConditionโ: โTrueโ,
โActionNotPerformedโ: โ3 errors present.โ,
โActionResultsโ: โCreated 1 ActionResultsโ,
โAction Typeโ: โEmailโ,
โAction Nameโ: โAction 1โ,
โErrorsโ: โError: Workflow rule โOrderUpdateRuleโ action โAction 1โ Attachment template. Expression โSubTotalโ is invalid due to: Expression โSubTotalโ could not be parsed due to exception: Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: indexโฆ Error: Workflow rule โOrderUpdateRuleโ action โAction 1โ Attachment template. Expression โDescuentoโ is invalid due to: Expression refers to undefined field. Error: Workflow rule โOrderUpdateRuleโ action โAction 1โ Attachment template. Expression โIVAโ is invalid due to: Expression refers to undefined field.โ,
โEmailToโ: โโ,
โEmailCCโ: โโ,
โEmailBCCโ: โโ,
โEmailFromDisplayโ: โโ,
โEmailReplyToโ: โnoreply@appsheet.comโ,
โEmailPreHeaderโ: โFactura de Ventaโ,
โEmailSubaccountโ: null,
โEmailSubjectโ: โFactura de Venta - William J - Ced/Nit: 1,094,988,415 - 10/17/2019 9:05:26 AMโ,
โEmailTitleโ: โAlert: Update to application โApp Toma Pedidoโ table โOrdersโโ,
โEmailAttachmentโ: โName: โFactura de Venta - William J - Ced/Nit: 1,094,988,415.pdfโ Archive: AttachAndDoNotArchive FileName: โโ MIME Type: โapplication/pdfโ PageOrientation: โPortraitโ PageSize: A4 AttachmentByteLength: 0 AttachmentTextLength: 26163 PDFCount: 1โ,
โEmailOtherAttachmentsโ: โโ,
โAppTemplateNameโ: โtest1-1102311โ,
โOperationโ: โWorkflow actionโ,
โResultโ: โFailureโ
}
Thank you for your cooperation
Expression โSubTotalโ is invalid due to: Expression โSubTotalโ could not be parsed due to exception: Index was out of range. Must be non-negative and less than the size of the
Etc etcโฆu have problems with formulas in email templateโฆjust correct them
hello this is my expression in the template, I donโt know how to correct it.
<<Start:[Related Order Details]>><<[Producto].[IdProducto]>>
<<[Producto].[P_IVA]>>
<<[Producto].[Nombre]>>
<<[Cantidad]>>
<<[Descuento]>>
<<[Producto].[Precio Unidad]>>
<<[SubTotal]>>
<<[IVA]>>
<><>
There are two independent problems.
The error message โError: Workflow rule โOrderUpdateRuleโ action โAction 1โ Attachment template. Expression โSubTotalโ is invalid due to: Expression โSubTotalโ could not be parsed due to exception: Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: indexโฆโ is occurring because of an AppSheet bug.
The name โSubTotalโ is an Excel function name. When we attempted to parse that name we treated it as a Excel function and expected it to be followed by parenthesized argument list. I have fixed that problem. If testing goes well, that change should be released on Friday afternoon Seattle time.
After that bug fix is released, you will begin seeing the proper error message which is:
โError: Workflow rule โOrderUpdateRuleโ action โAction 1โ Attachment template. Expression โSubTotalโ is invalid due to: Expression refers to undefined field.โ
You are seeing the undefined field name errors for fields โSubTotalโ, โDescuentoโ, and โIVAโ because your attachment template is incorrect. These three fields reside in table โOrder Detailsโ. These three fields are referenced in two places in your template. The first reference to these fields is inside the << Start >> expression, which is valid. The second reference to these fields is outside the << Start >> expression near the bottom of your template. The second reference is invalid because the current record at that point in the template is the โOrderโ record. The โOrderโ record does not contain these three fields.
I forgot to say that if you fix the template problem described in the last paragraph, you can circumvent the first problem I described.
Thanks for the help, with your recommendations I solved my problem and the application already works fine.
Glad to hear that it is working.
Good
morning, I just received an message from appsheet that says that I will cancel
my app for exceeding the number of users, in the information of the app it says
that four users of those two appear in the app and should only leave two, I
want to know how definitely delete those two users since they do not use the
app and that appsheet does not close my application. Thank you
Please contact support@appsheet.com directly for help.
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |