Suggestions on writing a pipeline that....

Question

Any suggestions on a pipeline that searchs thru a table looking for a record with a date, capturing a number value in that record and then searching the same table for a record with the next date (next date that follows the prior record date) and then inserts the captured value in a different number field in the "follow on date" record.
------------------------------George Bramhall------------------------------

ChayceDuncan · Answer

I wouldn't necessarily try and do it with Pipelines to do the search. If possible you might consider trying to do a formula-query to 'find' your records/get the values that you need and then use the Pipeline to move/copy the value.

------------------------------
Chayce Duncan
------------------------------

Sign up

Login to the community