GeorgeBramhall1
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Button that adds record #2 from record #1 in same table ... but returning to record #1 after save.
I figured it out. Instead of selecting open on same page in button, I selected open in new window and now when we save we stay on the same record. Sometimes we need to take a break from a challenge and start fresh later.25Views0likes1CommentRe: 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 ------------------------------9Views0likes4CommentsEditin 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 ------------------------------9Views0likes6CommentsRe: 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 ------------------------------108Views0likes0CommentsAccess to Fields
Is 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 field
For 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 ------------------------------10Views0likes1Comment