ContributionsMost RecentMost LikesSolutionsRe: Editin Button working in a report but not working from same report in a Dashboard To your first question, yes I can confirm that he will not get the access error if he clicks the button anywhere but in the Dashboard. For your second question, testing as the user he can click the edit pencil on any record for the report where the button resides and enter the edit form. ------------------------------ George Bramhall ------------------------------ Editin Button working in a report but not working from same report in a Dashboard access issue when editing a record with a button from a report within a Dashboard: <qdbapi> <action>API_EditRecord</action> <errcode>3</errcode> <errtext>Insufficient permissions</errtext> <errdetail>You don't have permission to access that page.</errdetail> <username>ilya@maximind.ca</username> </qdbapi> However no access issue when clicking the same button in the native report (not from the Dashboard): Testing as a specific so user get the expected error upon clicking the button: <qdbapi> <action>API_EditRecord</action> <errcode>2</errcode> <errtext>Invalid input</errtext> <errdetail>ILYA BAM can edit data but you're testing as that user, so your change wasn't saved</errdetail> <rid>4295</rid> <num_fields_changed>0</num_fields_changed> <update_id/> </qdbapi> Any idea why user can't edit the records within the dashboard? ------------------------------ George Bramhall ------------------------------ Re: Query that determines the Maximum number in a set of records.Thanks Mark, I am trying to use the query result to filter a report so the pipeline approach will not work. For the same reason, I don't think the Max record id will help. I do have a multi-text list of values from a query, but I don't know how to get the maximum value in that list in the query result. ------------------------------ George Bramhall ------------------------------ Re: Query that determines the Maximum number in a set of records.Not sure how I would use the Max function in a Query formula. ------------------------------ George Bramhall ------------------------------ Query that determines the Maximum number in a set of records.Is it possible to create query that results in the maximum value for a set of records? I see SumValues and Size, but no Maximum. ------------------------------ George Bramhall ------------------------------ Re: Deactivated users getting added back to my appOk thanks for the tip. ------------------------------ George Bramhall ------------------------------ Re: Access to FieldsSo it sounds like I need to create a new field (snap shot or pipeline filled field) sourced from the restricted field that then is used in the formula field. ------------------------------ George Bramhall ------------------------------ Access to FieldsIs it true that if I hide (no view) a field from certain roles, e.g. pay rate for employees, that anywhere that the field is used (e.g. a formula field) is also not viewable to those roles or viewable to those roles minus the amount of the hidden field? ------------------------------ George Bramhall ------------------------------ Re: Google Connection Key fieldFor anyone that is interested, this is what QB Technical Support says about this (beware!) "I've reached out to the Sync Table team and received further clarity on this matter. You won't be able to "fix" this matter from your end. It's possible that SRE can rename your keyfield to match the connection." ------------------------------ George Bramhall ------------------------------ Pipeline to Pre-fill a many to many table triggered by the addition of Parent RecordsI have a many to many table that includes a distance value between 2 related parent table records. When either a Parent 1 or Parent 2 record is added I want to create a record in the many to many table ... result being that for each Parent 2 there will be distance for Parent 1. Currently there are 300 records in Parent 1 and 60 records in Parent 2. I have manually imported from a csv 18000 records in to the many to many table. What does the pipeline look like that creates additonal records automatically when either a Parent 1 or Parent 2 record is added. ------------------------------ George Bramhall ------------------------------