Conditional Between 2 Tables.

Question

Hello,

I was addressed with something I am not familiar with.

My colleague would like to have the following:
A red flag to appear when something is not uploaded.

The breakdown:
We have 1 table, that has all of our information on. It is called "Water Systems". And it has any and all information pertaining to that specific water system.
We have another table called "Documents" and this table allows us to display documents on the "Water Systems" pages. 
I was asked to have a Red Flag displayed when a document is NOT uploaded to the water system, so we can see that we need to take action. 
We have paper reports we upload each month to the documents for each water system, sometimes, a month will get missed for a specific water system and we miss it too, because we manage so many water systems across the state. 
Is there a way to make a red flag when a document is not uploaded to the water system one month?

------------------------------Newman, Savi------------------------------

ChayceDuncan · Answer

Using your relationship you can add a summary field that counts the # document that meet the condition that you want. That condition could be something like uploaded in the last 30 days and is of type ____ as an example. Then in your water system, you can make a checkbox, or formula rich text that checks if that # is 0, and you know it doesn't have a document uploaded yet.

------------------------------
Chayce Duncan
------------------------------

Sign up

Login to the community