ContributionsMost RecentMost LikesSolutionsRe: New Summary Report CalculationAh, so Sunday is the day. Thank you. I thought it had been released already. Thanks very much. ------------------------------ Nathan Allan ------------------------------ New Summary Report CalculationIn the April release it mentions a new way to calculate aggregate data in a summary report that would solve the "average of averages" problem. But there is no reference or name of a function on how to do actually do this. In my table I have a profit margin field, but in my summary table which is by month, I don't want to just take the average of that field, as it will give me an incorrect number. I want to do the formula on the actual summed data. Is this possible now? Or am I misunderstanding the release? ------------------------------ Nathan Allan ------------------------------ 1 Child to Multiple ParentsI'm wondering if this is possible. I have a multi-select text field, for market (i.e. Denver, Phoenix, Los Angeles) to determine which markets this vendor services. I also have a table that has 1 record per market and has contact info for our team in that market. I would like to relate these two tables together, so that on the vendor table, I can see the denver, phoenix, and LA contact info. Is this possible? Thanks! ------------------------------ Nathan Allan ------------------------------ Re: Pull an Attachment from an Email to a File Attachment field in QBMicrosoft Outlook Channel ------------------------------ Nathan Allan ------------------------------ Pull an Attachment from an Email to a File Attachment field in QBI have a pipeline that works nicely. It triggers when an email is received and creates a record in QB and sends an email back to the recipient. One last thing I would like to add is if the incoming email has an attachment to be able to attach it to the record in QB. Anyone have any luck doing this? ------------------------------ Nathan Allan ------------------------------ Re: New branding, are you guys serious?Ya, the new branding and logo are not good. Previously it looked clean and professional. This really does look fake/scammy. Probably could have used that time to work on something more productive. ------------------------------ Nathan Allan ------------------------------ Re: Formula URL - To add a new record and update the current recordYes, here's the current code. URLRoot() & "db/" & [_DBID_RENEWALS] & "?a=API_GenAddRecordForm&_fid_108=" & URLEncode ([NAMEID])&"&_fid_9=Yes&_fid_6=" &[OID_Used_For_Key]& "&_fid_42=Pending&_fid_45=" & ToText(User()) & "&z=" & Rurl() ------------------------------ Nathan Allan ------------------------------ Formula URL - To add a new record and update the current recordI currently have a formula url button that adds a record to table y when I push it with certain fields from that current record in table x. What I need to also be able to do is, update a field of the current record in table x. Is this possible and what would the syntax look like? Thanks! ------------------------------ Nathan Allan ------------------------------ Re: Access the date/time in a logged field?Perfect. Thanks a ton! ------------------------------ Nathan Allan ------------------------------ Re: Access the date/time in a logged field? Yes, here is an example. I'd like to capture the date from the most recent log that says completed so Nov-10-20 12:40 PM instead of the one at 1:11 PM. ------------------------------ Nathan Allan ------------------------------