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; } } }

Populating data dynamic on confi form tabular view

Ananda Sravya

I have a form and tabular view corresponding to it.

In that tabular view I have two columns 1. Due Date 2.status.

I want the status values to populate based on the dates in the tabular view without any manual activity.

Ex: Due dare: 12th Jult 2021

If Current date is 1st July want the status like available

If Current date is 10th July then approaching sla else due

Accepted answers

Alex Medved _ConfiForms_

You can set up a status field to be a formula field with an expression something like this

IF(NOW()-[entry.dueDate]<0, IF([entry.dueDate]-NOW()< 172800000, "Approaching SLA", "DUE"), "Available")

Assuming the field to store the Due Date is named "dueDate"

"Approaching SLA" status will be shown when now and due date is smaller than 2 days (in milliseconds it is 172800000 and that is what I am comparing to here)

Alex

All comments

Alex Medved _ConfiForms_

You can set up a status field to be a formula field with an expression something like this

IF(NOW()-[entry.dueDate]<0, IF([entry.dueDate]-NOW()< 172800000, "Approaching SLA", "DUE"), "Available")

Assuming the field to store the Due Date is named "dueDate"

"Approaching SLA" status will be shown when now and due date is smaller than 2 days (in milliseconds it is 172800000 and that is what I am comparing to here)

Alex

Ananda Sravya

Thanks for your response. But the conditions are reflecting when we are registering the data in form but in the tabular view the data is not changing/modifying automatically based on these conditions.

Could you please suggest me

Alex Medved _ConfiForms_

As this formula contains NOW() function, ConfiForms is smart enough to recalculate the formula on EVERY view and does not require you to modify the record

Alex

Ananda Sravya

I tried the same but didn't worked for me.

Can you please suggest the alternate.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms