is it posssible to have a button or something trigger that? or an automation (like if row changed)? thanks
hi, how did you do it with the automation? i cant get it to work
1 Like
I did not find any automations that work. @Paul_Danyliuk 's suggestion is the only thing that worked. Probably not ideal in terms of resource optimization since it is always recalculating (now() is a volatile function…) Any other better/more efficient ideas to address this issue @Eric_Koleda ?
this is how my formula looks now:
ParseJson(_Merge(thisRow.[Upload invoice file here]) + “”, “#/publicUrl”).Concatenate(If(Now(), “”, “”))
You can use Now(“minute”) instead. Other options are “hour” and “day”
2 Likes
@Jean_Marc_Dieu - Unfortunately there still isn’t any way to get a formula to recalculate after the virus scan is complete.