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

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:

Screenshot 2024-06-22 095511.png

Thanks for your help.

Accepted answers

Alex Medved _ConfiForms_

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

All comments

Alex Medved _ConfiForms_

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

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