Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Populating data dynamic on confi form tabular view

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 

 

1 answer

1 accepted

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

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 

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

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

Can you please suggest the alternate.

What alternative!? 

What does not work for you? The formula is recalculated on each render - meaning ALWAYS

After applying the condition also the status is not updating.please find the attached image for your reference.

20210715_145442.jpg

I am unsure what this screenshot should illustrate... and what do you mean by "applying condition"

but here is what I was trying to explain

The form

Screenshot 2021-07-15 at 13.44.14.png

And the status field with formula as mentioned in one of my previous comments

Screenshot 2021-07-15 at 13.44.24.png

I have used the same way but when I am registering the data it worked fine.

I am using tabular view to show the data but in the tabular view the status is not reflecting based on the condition.

The above screenshot is the data in the tabular view.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

🏑 Atlympic Event: Confluence

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

179 views 6 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you