Pipeline shows 0 records found?
Made a scheduled pipeline to look at a "formula - duration" field on Table A (Calendar) that signifies how many days until an event there are. If it is between 0-75 days, it should create a new reco...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf the field you are comparing to in native, Quickbase is a duration field then you're being tripped up by the unit of measure issue. There is some possibility that if you compare the range to 75 days instead of 75 it might work. But if that doesn't work, then I suggest you make a new formula numeric field in native. Quickbase called [duration in days]; with the formula of
ToDays([My duration field])
that will give you a nice clean numeric field to use for the comparison in a pipeline
Yes it was initially set to smart units, where I set the filter up as "0 days to 75 days" but it completely failed doing that. So I switched it to just being "Days", which gives the numeric value. But now it runs fully but it discovers no records.
