Good Evening support and Everyone,
I am trying for some time to create a calculated field in a table on a Portal. I can add an Action but not any condition.
This table has the aim to gather all certificates of equipment and this calculated field should calculate time left to expire.
then i'll check what is the best way to issue some email alerts when this date is reaching.
As soon as I click on add a CONDITION, it is getting me this set up, and it seems that I can't change it.
Any one can help me on this subject?
Thank you in advance.
Hi @Joao_Santos
Assuming your certificate attachment field is text type, then try pressing ctrl + F5 on the calculation window
For me as soon as I enter double quotes and hit ok then it is converted to two double quotes. Screenshot below
Ctrl + F5 will solve your problem I think. Remove the calculation completely and try again
Hope it helps.
------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
Dear ragavanrajan, Thank you for your prompt reply.
This will be used surely for the highlight or to set a field with priority number.
But i would like to have a calculation field with the number of days missing.
Do you have an idea why i cannot add a condition ?
Best regards
Hi @Joao_Santos
You can try setting the business rules in
1. Table> your table > Business rules > Add business rule
Hope it helps.
------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
Fubar
62
Super User 2025 Season 2
Lucas001
48
Super User 2025 Season 2
KevinGador
44
Super User 2025 Season 2