nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issue with Formula Displaying Instead of Value in Status Field

Peiman Parsa

I hope this message finds you well. I am reaching out regarding an issue we’ve encountered with the status field in ‘ConfiForms Field’ Macro .

When trying to display the status value, we are seeing the formula itself rather than the expected value (e.g., “Ready to order”). Specifically, we are receiving the following error:

Error:
Expression:
[IF(4=1,'Waiting for non-EU approval', IF(4=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(4=3,'Waiting for director's approval', IF(4=4,'Ready to order', IF(4=5,'Waiting for partial invoice payment', IF(4=6,'Waiting for delivery', IF(4=7,'Waiting for payment', IF(4=8,'Needs inventory','Completed'))))))))] could not be calculated, begin 530, end -1, length 538

This issue results in the formula being displayed in the status field rather than the appropriate value. Could you please assist us in troubleshooting this issue? We would appreciate any guidance on how to resolve it.

Best regards,

Accepted answers

All comments

Alex Medved _ConfiForms_

Please use double quotes for parameters, as in documentation

https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions

Alex

Peiman Parsa

This is our formula expression in ‘ConfiForms Field Definition’ Macro , and it worked until two days ago. We didn't change anything.

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))))))))

Do we need double quotes?

Alex Medved _ConfiForms_

Of course you do, as in the documentation

Also, what does something like this do in your oinion?

[entry.DeliveryCompleted.upperCase()] && [entry.DocumentsComplete.upperCase()]

Especially when the values are EMPTY, form example and you get a

NOT(&&)

as an expression!?

Peiman Parsa

I mistakenly sent the status field. This is the status message that caused the problem:

IF([entry.Status]=1,'Waiting for non-EU approval', IF([entry.Status]=2,CONCAT('Waiting for approval (', IF(NOT([entry.Approved.upperCase()]) && NOT([entry.Approved2.upperCase()]),'all approvers', IF(NOT([entry.Approved.upperCase()]),'project approver', IF(NOT([entry.Approved2.upperCase()]),'master approver',''))), IF(NOT(ZEROIFEMPTY('[entry.Necessary]')), IF(NOT([entry.Approved.upperCase()]) || NOT([entry.Approved2.upperCase()]),' and necessity/fund availability','necessity/fund availability'),''),')'), IF([entry.Status]=3,'Waiting for director's approval', IF([entry.Status]=4,'Ready to order', IF([entry.Status]=5,'Waiting for partial invoice payment', IF([entry.Status]=6,'Waiting for delivery', IF([entry.Status]=7,'Waiting for payment', IF([entry.Status]=8,'Needs inventory','Completed'))))))))

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

addon-com.vertuna.confluence.plugins.confiforms

confiforms