JoshCollins
Qrew Assistant Captain
Joined 7 years ago
User Profile
User Widgets
Contributions
Can I Import Credit Card Transactions from Quickbooks?
I am trying to build a connected table between Quick Base and Quickbooks Online and I specifically want to sync my credit card transactions. I see that I can sync bills, but I can not find a way to sync other expenses, like credit card line items or checks. Am I missing something simple? Any insight or ideas would be greatly appreciated! Thank you!98Views0likes2CommentsRe: Help With Formula For Weighted Average Field
Thanks Mark! I had to play around with some add'l parenthesis but the formula it worked like a charm! As far as the double post...that's weird! I looked for a way to delete the duplicate but couldn't find a way. ------------------------------ Josh Collins ------------------------------25Views0likes0CommentsHelp With Formula For Weighted Average Field
Hello, I am trying to fix a formula for a numeric formula field that calculates the weighted average build cost of house plans we build. Here is the formula: (([3 Month Average Build Cost] * 10) + ([6 Month Average Build Cost] * 6) + ([1 Year Average Build Cost] * 3) + [2 Year Average Build Cost]) / 20 The Field References are summary fields. The numeric value is the "weight" we are giving to that summary field. The problem we are having is that occasionally the Summary Field used in the formula is blank/null and it causes the result of the formula to be blank. What I believe needs to happen is for the formula to simply disregard blank values and continue the formula calculation. For instance, see the attached screenshots. 3 Month Average Build Cost is blank and therefore the "Weighted Average" formula result is blank. Rather, it should still calculate the remainder of the 6mo, 1yr and 2yr averages. The other obvious issue is that if any part of the formula is blank then the number by which the whole formula is divided would change. In the above formula it is divided by 20 because it assumes there will always be a value in each field. If a field were blank, then the divisor would also need to be reduced by the "weight" of whichever field were blank. Hopefully I've explained this well and the result I'm looking for is clear. I'm guessing I'm going about the formula all wrong! ------------------------------ Josh Collins ------------------------------50Views0likes2CommentsHelp With Formula For Weighted Average Field
Hello, I am trying to fix a formula for a numeric formula field that calculates the weighted average build cost of house plans we build. Here is the formula: (([3 Month Average Build Cost] * 10) + ([6 Month Average Build Cost] * 6) + ([1 Year Average Build Cost] * 3) + [2 Year Average Build Cost]) / 20 The Field References are summary fields. The numeric value is the "weight" we are giving to that summary field. The problem we are having is that occasionally the Summary Field used in the formula is blank/null and it causes the result of the formula to be blank. What I believe needs to happen is for the formula to simply disregard blank values and continue the formula calculation. For instance, see the attached screenshots. 3 Month Average Build Cost is blank and therefore the "Weighted Average" formula result is blank. Rather, it should still calculate the remainder of the 6mo, 1yr and 2yr averages. The other obvious issue is that if any part of the formula is blank then the number by which the whole formula is divided would change. In the above formula it is divided by 20 because it assumes there will always be a value in each field. If a field were blank, then the divisor would also need to be reduced by the "weight" of whichever field were blank. Hopefully I've explained this well and the result I'm looking for is clear. I'm guessing I'm going about the formula all wrong! ------------------------------ Josh Collins ------------------------------135Views0likes1CommentFormula Help for Weighted Average Field
Hello, I am trying to fix a formula for a numeric formula field that calculates the weighted average build cost of house plans we build. Here is the formula: (([3 Month Average Build Cost] * 10) + ([6 Month Average Build Cost] * 6) + ([1 Year Average Build Cost] * 3) + [2 Year Average Build Cost]) / 20 The Field References are summary fields. The numeric value is the "weight" we are giving to that summary field. The problem we are having is that occasionally the Summary Field used in the formula is blank/null and it causes the result of the formula to be blank. What I believe needs to happen is for the formula to simply disregard blank values and continue the formula calculation. For instance, see the attached screenshots. 3 Month Average Build Cost is blank and therefore the "Weighted Average" formula result is blank. Rather, it should still calculate the remainder of the 6mo, 1yr and 2yr averages. The other obvious issue is that if any part of the formula is blank then the number by which the whole formula is divided would change. In the above formula it is divided by 20 because it assumes there will always be a value in each field. If a field were blank, then the divisor would also need to be reduced by the "weight" of whichever field were blank. Hopefully I've explained this well and the result I'm looking for is clear. I'm guessing I'm going about the formula all wrong! ------------------------------ Josh Collins ------------------------------64Views0likes1CommentFormula Help for Weighted Average Field
Hello, I am trying to fix a formula for a numeric formula field that calculates the weighted average build cost of house plans we build. Here is the formula: (([3 Month Average Build Cost] * 10) + ([6 Month Average Build Cost] * 6) + ([1 Year Average Build Cost] * 3) + [2 Year Average Build Cost]) / 20 The Field References are summary fields. The numeric value is the "weight" we are giving to that summary field. The problem we are having is that occasionally the Summary Field used in the formula is blank/null and it causes the result of the formula to be blank. What I believe needs to happen is for the formula to simply disregard blank values and continue the formula calculation. For instance, see the attached screenshots. 3 Month Average Build Cost is blank and therefore the "Weighted Average" formula result is blank. Rather, it should still calculate the remainder of the 6mo, 1yr and 2yr averages. The other obvious issue is that if any part of the formula is blank then the number by which the whole formula is divided would change. In the above formula it is divided by 20 because it assumes there will always be a value in each field. If a field were blank, then the divisor would also need to be reduced by the "weight" of whichever field were blank. Hopefully I've explained this well and the result I'm looking for is clear. I'm guessing I'm going about the formula all wrong! ------------------------------ Josh Collins ------------------------------207Views0likes1CommentRe: How To Remove HTML from Rich Text field so it doesn't show in Email Notifications and Headers, etc?
Hey Blake, thanks for the tip. I added the quotes and the error went away. However, the HTML is still showing in the sample data and the email subject line. See attached. ------------------------------ Josh Collins ------------------------------56Views0likes0CommentsRe: How To Remove HTML from Rich Text field so it doesn't show in Email Notifications and Headers, etc?
Thanks for the suggestion Angel. However, it doesn't seem to be working. I am getting a syntax error. Please see attached. ------------------------------ Josh Collins ------------------------------137Views0likes2CommentsHow To Remove HTML from Rich Text field so it doesn't show in Email Notifications and Headers, etc?
Hello, does anyone know how to hide the HTML formula in a Rich Text Field from displaying in column headers, email notifications, etc? See attached image 1. You can see that the HTML is showing at the beginning of the "Sample Data." See attached image 2. You can see that the HTML is showing in the email subject line. Can this be masked/removed so only the data is showing? Thanks! ------------------------------ Josh Collins ------------------------------217Views0likes4Comments