MarkComish
Qrew Assistant Captain
Joined 5 years ago
User Profile
User Widgets
Contributions
Share with clients
I love Quick Base but the one thing I hate is I have a Workflow (Project Manager App) and I would love to share each clients information with a contact from their company. It would be cost prohibitive to buy a user license for each person, if I could even only make visible client specific info. Any ideas? Any chance this would be coming? Any chance a pipeline might be fully integrated with another project management solution. ------------------------------ Mark Comish ------------------------------Re: Split Formula Duration field into Hours and Minutes
I am on the Premier Plan. I believe we get 3 integrations in our plan. I am not sure the cost of adding above that. You can build all the Quick Base to Quick Base pipelines you want but they do count as "Steps" when they run. We get 2000 "Steps" per month. It is basically the number of times we run a pipeline. It is a bit confusing as it can be more than 1 "Step" each time a pipeline runs based on things it does. Sorry to be so vague. I have run 200 "Steps" in 10 days so the number seems like it will be enough for my use. Let me know if there is anything else I can share. ------------------------------ Mark Comish ------------------------------Re: Split Formula Duration field into Hours and Minutes
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 ------------------------------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 ------------------------------Re: Adding Duration Fields
As usual you are the man!!! Thank you! Another question On Grid Edit I am pulling from from a field on another table "Opportunities" (Parent Table). It shows all opportunities but I only want the ones that are from a certain [Division]. I can't seem to figure out how to limit it. Thanks as always ------------------------------ Mark Comish ------------------------------Adding Duration Fields
I am trying to add duration fields but if one is blank the total doesn't show. Any suggestions? [End Time 1] - [Start Time 1] = [Time 1 Total] [End Time 2] - [Start Time 2] = [Time 2 Total] [End Time 3] - [Start Time 3] = [Time 3 Total] So if [Time 1 Total] is 1 hour and [Time 2 Total] is 30 min and [Time 3 Total] is blank it won't give me a [Total Time] ([Time 1 Total]+[Time 2 Total]+[Time 3 Total]) How do I get a total if one of the [Time Total Fields] is blank (null) ------------------------------ Mark Comish ------------------------------
