Conditional Between 2 Tables.
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...
Forum Discussion
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
------------------------------
That's a great idea, how do I get the condition to be 30 days? I am new to that area of things.
------------------------------
Newman, Savi
------------------------------
Ultimately depends on your exact use case, but you could add a filter in matching criteria and do it based on Date Created during the last 30 days or current month (screenshot below of what the options might look like).
You might use the current month in opposition to 30 days to make sure that something is uploaded for this particular month - otherwise the 30 day mark will work. If you have a different date field you can also use that instead of date created.
------------------------------
Chayce Duncan
------------------------------Thanks! This worked!
------------------------------
Newman, Savi
------------------------------
