I have a table of Collection Events where each collection event is later assigned a Disposal Event. (There are many collection events associated with a single Disposal Event)
Iโve been unable to solve the expression needed to fire a workflow from the Collection Event table if in the associated Disposal Event table the [Timestamp] column = Today()
All Iโve been able to come up with is something like:
IN(Disposal Event), [Timestamp]= Today())
Any thoughts? Thanks in advance.
When and how is this workflow supposed to be initiated? Is [Timestamp] a Date or a Datetime?
Is there a field in your collection eventโs table that links the records to the Disposal event record?
Are you using a reference? If so you could try using a de-reference formula:
[Disposal_Event].[Timestamp] = today()
Otherwise youโll need to do a lookup of the disposal eventโs timestamp, something like:
LOOKUP([_thisrow].[Disposal_Event], Disposal Event Table, Event ID, Timestamp) = today()
Like Bahbus was saying, it will depend on the type of the Timestamp column. Today is a DATE, if youโre using a DateTime, youโll need to wrap things in a DATE() formula to force it into a date type.
DATE([Disposal_Event].[Timestamp]) = today()
DATE(LOOKUP([_thisrow].[Disposal_Event], Disposal Event Table, Event ID, Timestamp)) = today()
@Bahbus @MultiTech_Visions Thank you. Let me try these suggestions and Iโll report back it anything works, else some clarification on the need. This has been a tricky challenge since the beginning of the app build. Iโm still trying to fully understand the best way to solve this thing.
Donโt feel bad. I scrapped and started over like 6 times before I got my data structured in a way that works quickly and efficiently.
Below comes up as a valid expression. The goal is:
AND(DATE(LOOKUP([_thisrow].[Disposal Event], Disposal Event, Disposal Key, Timestamp)) = today(),(ISNOTBLANK([Destruction Signature])))
Looks like it should
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |