Issue with ConfiForms Field Definition Displaying Expression Data Instead of Status

[Peiman Parsa]

We have been experiencing an issue with Confiforms. We created a ConfiForms Field Definition for our status using this expression:

IF([entry.OrderingNonEu] && NOT([entry.NonEuIsOkay.upperCase()]), 1, IF(NOT([entry.Approved.upperCase()] && [entry.Approved2.upperCase()] && ZEROIFEMPTY("[entry.Necessary]")), 2, IF(NOT([entry.NetValue] < 10000 || [entry.ApprovedByDirector.upperCase()]), 3, IF(NOT([entry.Committed.upperCase()]), 4, IF(NOT([entry.PartialInvoicesPaid.upperCase()]) && NOT([entry.DeliveryCompleted.upperCase()] && [entry.DocumentsComplete.upperCase()]), 5, IF(NOT([entry.DeliveryCompleted.upperCase()] && [entry.DocumentsComplete.upperCase()]), 6, IF(NOT([entry.Completed.upperCase()] && [entry.PaymentDone.upperCase()]), 7, IF(NOT(NOT([entry.InventoryNecessary.upperCase()]) || [entry.InventoryStickerDone.upperCase()] && [entry.InventoryDone.upperCase()]), 8, 9) ))))))))

It worked well until the first of July. Since then (possibly related to an update), some of the order forms do not show the status of the order. Instead, they display the expression data instead of the status:

Thanks for your help.

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Peiman Parsa 

Is this a formula and the error for the same status field?

This does not look like it matches - I mean the formula and the error message you get

Alex

[Peiman Parsa]

Hi Alex,

Thank you for responding. We have a "ConfiForms Field Definition" with the name "Status" and the following expression:

IF([entry.OrderingNonEu] && NOT([entry.NonEuIsOkay.upperCase()]),1,IF( NOT([entry.Approved.upperCase()] && [entry.Approved2.upperCase()] && ZEROIFEMPTY("[entry.Necessary]")),2,IF( NOT([entry.NetValue]<10000 || [entry.ApprovedByDirector.upperCase()]),3,IF( NOT([entry.Committed.upperCase()]),4,IF( NOT([entry.PartialInvoicesPaid.upperCase()]) && NOT([entry.DeliveryCompleted.upperCase()] && [entry.DocumentsComplete.upperCase()]),5,IF( NOT([entry.DeliveryCompleted.upperCase()] && [entry.DocumentsComplete.upperCase()]),6,IF( NOT([entry.Completed.upperCase()] && [entry.PaymentDone.upperCase()]),7,IF( NOT(NOT([entry.InventoryNecessary.upperCase()]) || [entry.InventoryStickerDone.upperCase()] && [entry.InventoryDone.upperCase()]),8,9))))))))

When we register the order in the form, the status should be something like "Waiting" or "Ready to pay". However, instead of "Ready to pay", the status is showing the following error:

[IF(3=1,'Waiting for non-EU approval', IF(3=2,CONCAT('Waiting for approval (', IF(NOT(TRUE) && NOT(TRUE),'all approvers', IF(NOT(TRUE),'project approver', IF(NOT(TRUE),'master approver',''))), IF(NOT(ZEROIFEMPTY('1')), IF(NOT(TRUE) || NOT(TRUE),' and necessity/fund availability','necessity/fund availability'),''),')'), IF(3=3,'Waiting for director's approval', IF(3=4,'Ready to order', IF(3=5,'Waiting for partial invoice payment', IF(3=6,'Waiting for delivery', IF(3=7,'Waiting for payment', IF(3=8,'Needs inventory','Completed'))))))))] could not be calculated, begin 530, end -1, length 538

Best regards,
Peiman

[Alex Medved _ConfiForms_]

Looks like you have registered a duplicate for this - https://community.atlassian.com/t5/Confluence-questions/Confiform-expression/qaq-p/2735475 

See the comment I have posted there