Pipelines CSV Handler
I'm receiving a .CSV file via the Pipelines 'CSV Handler'. In the second step I'm using 'Iterate over CSV Records'.
What I am trying to do is use the csv which looks like this:
I want ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIs the file format regular CSV? I had a problem where I inadvertently was testing with a CSV UTF -8 file.
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
- Yes, definitely just a standard .csv. I'm completely stumped on this one. I found a way to do this with Zapier but it creates an "Order" for each row in the .csv. Still stuck on this problem.
------------------------------
Jeff Peterson
------------------------------- I assume that Orders has a one-to-many relationship with Warehouse Requests. It seems like you're going to want to have two Pipelines. You're going to want to bring the Date Created or some other standard field into Warehouse Requests from Orders
One which reads this data into the Warehouse Requests table because it is actually what each line represents.
Second One that is triggered On A New Event with Warehouse Requests. Use the standard field that you brought into Warehouse Requests as the filter to decide whether or not to create an Order. If you need to create the Order, then create it.
I hope that this helps.
------------------------------
John Crosland
------------------------------
