Qrew Tips - The Qrew Knowledge Base
Qrew tips and more
Recent Content
Expanded URL from Reports
Hello, I was hoping to get some guidance on how to access the expanded url for reports. I have two identical apps and would love to cut some time but copying reports from one app to the other. Discussion about this topic - https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=8c484de1-b122-4c73-b918-72d25064962a&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer the upside down ellipses has this option greyed out but is there another way? ------------------------------ Tim D ------------------------------
Pipeline Error --> "Quickbase reported an error: No error"
Hi * I'm creating a pipeline and as soon as I select the "Table A" in "Trigger: Record Update" step, the pipeline is showing error --> "Quickbase reported an error: No error" * If I refresh the pipeline, the "Table A" assignment goes blank again. * This error is shown only for one table (Table A), but if I select (Table B) this error is not shown and everything working as expected. * I have checked the "Role Permission", all are good. What can be the solution? Thanks ------------------------------ vivek vishwanath ------------------------------
View query record if single record otherwise view query list
I am creating some buttons in a Formula - Rich Text field. They will allow users to quickly jump from one table to the next using the table to table relationships we have set up. Mainly what they will be seeing is a list of related records based on a query. For example, if I am in the Customers Table and I click on the Invoices button it will take me to the invoices table and I can see all the invoices related to that customer. If there is only one invoice I would like the button to take me directly to that invoice record and not view it in list mode. Is there a way to use the query and set up an if statement that would check the length of the query response and if there is only one then view that record. Below is an example of the query code I am using for one of the buttons. URLRoot() & "db/" & [_DBID_INVOICES] & "?a=q&query=" & "{'6'.TV.'" & [Record ID#] & "'}"
