Create status in Confiform Table view based on different value of other fields

[Dhiraj Kr_ Gupta]

There is field with valuese of Date in Confiform. So, status should automatically turn In process, completed based on date.

Suppose if difference between current date and date mentioned in the field is 300-365 days then "In process" and if greater than 365 days then Expired.

Date	Status
4/4/23	Expired
28/5/23	In process

[Alex Medved _ConfiForms_ · Accepted solution]

You can use Formula field that will use [entry._now] as current data comparing it to date field in your record

More on functions you can use in the formula you can see here https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions

[Dhiraj Kr_ Gupta]

Thanks Alex.

You are always the saviour