About Anna_Pedersen

Anna_Pedersen · 05-08-2019

Hi Team, I am trying to get a referenced action to work, however it just isnt working. I am thinking it is to do with my referenced rows formula, as the individual action works great.! Any help is greatly appreciated

Anna_Pedersen · 05-03-2019

Hi There, I am trying to count the number of days between two dates (start, end) on a form that appear in another table (public holidays). I have tried a number of options including Select/Filter etc, but cannot get it right! the public holidays tabl...

Anna_Pedersen · 05-11-2019

Hi Steve, Oh what an idiot! i completely forgot about workflow to trigger it! Thank you, thank you

Anna_Pedersen · 05-09-2019

Hi Steve, That didn’t work unfortunately, and the ID column of the Quotes table is the key column. The data is being recorded correctly, but for some reason the ref action is not firing. In the expression builder the result is correct (the quote ID) ...

Anna_Pedersen · 05-03-2019

Steve: COUNT( FILTER( “public holidays”, AND( ([date] >= [_THISROW].[start]), ([date] <= [_THISROW].[end]) ) ) ) Hi Steve Thanks very much! I was so close I modified it as i only needed the count section (it helps me in a calc of fees) COUNT( FILTER(...

My Stats

rvsubman's Bio

Badges Anna_Pedersen Earned

Recent Activity

Action to update another table - not working

Count public holidays between two dates

Re: Action to update another table - not working

Re: Action to update another table - not working

Re: Count public holidays between two dates