Thank you Don! Worked like a charm.
So for I have built Pipelines for Quick Books Online and Mail Chimp. I have had great success with building from Quick Base to Mail Chimp or Quick Base to Quick Books Online.
I have not had good success going from Quick Books Online to Quick Base or from Mail Chimp to Quick Base. I have a support ticket in as it won't trigger in this direction. It has been several days and no solution yet.
On the Pipelines that work they are great. Takes a little effort to get the hang of it but I really like them. Right now I have the following working...
1. Update a contact in Quick Base and then a pipeline to also update the record in Mail Chimp (something I could never get to work with Zapier. Zapier only worked with a new record in Quick Base.
2. When a time log is created in Quick Base it passes this info to Quick Books Online and creates a "Time Charge"
Still lots of pipelines I want to build once they are working in both directions better.
------------------------------
Mark Comish
------------------------------
Original Message:
Sent: 03-07-2020 16:56
From: Don Larson
Subject: Split Formula Duration field into Hours and Minutes
Mark,
Congratulations on Pipeline access. You are among a select few to have the tool set. Please do a few posts on how it works and how easy or hard it is to work with.
Total Hours is a Formula Numeric
ToNumber(Left(ToText(ToHours([Total Time])),"."))
Total Minutes is a Formula Numeric
ToNumber("." & (Right(ToText(ToHours([Total Time])),".")))*60
------------------------------
Don Larson
Paasporter
Westlake OH
Original Message:
Sent: 03-07-2020 02:20
From: Mark Comish
Subject: Split Formula Duration field into Hours and Minutes
I have a [Total Time] (Formula Duration) field. I am using pipelines to send the data to Quick Books Online. QBO wants the hours and minutes separated. How can I split the [Total Time] into 2 fields [Total Hours] and [Total Minutes].
[Total Time] = 2:15
I need [Total Hours] = 2
and [Total Minutes] = 15
------------------------------
Mark Comish
------------------------------