ChristopherKnie
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Pipelines Error 34
I'm creating a pipeline that is triggered by the creation of a record and modifies existing records. Every time I run it, I get the following error: "Quickbase reported an error: 34 : You cannot change the value of this field : The field named "[field name]" with field id 64 cannot be modified" The field is a date field. I've tried putting the date in using a jinja template and using the date picker in the pipeline. This is a field I modify manually all the time. I'm using an application token created from my account, which has full edit access to the app. What can I do? ------------------------------ Christopher Knieste ------------------------------Printing a new style timeline report
Hi all! We have a timeline report designed using the new style with color customization and all. We think the new timeline report style is a big improvement on the old one. We'd like to print the whole report to PDF so we can share it with a client, but when we use the Quickbase print dialog the report that appears is the old style with none of the color customization we use. We also tried making the report full screen and printing the page with the browser dialog but it only prints what is visible on the page as its scrolled, not the contents of the viewport containing the whole report. How do I print the entire timeline report as it appears to me on the webpage? Thanks! Chris attached: what I see on the webpage vs what I see when I use the print dialog ------------------------------ Christopher Knieste ------------------------------How best can I obfuscate/encrypt URL query parameters that are passed to a code page on our database?
Hi all! I was asked to develop an app that can present records associated with a particular user in a printable 8.5x11" worksheet-style form. As of now, I accomplish this with a URL button field that links to a code page with a "?userEmail=abcde@email.com" tacked onto the end. My javascript code takes the email from the URL, inserts it into an API_DoQuery, and uses the results to populate the worksheet. My question is: what's the best way I can keep a user from changing the URL to see somebody else's records? My initial thought was to change the URL parameter and base64 encode the email to get something more like "?x=YWJjZGVAZW1haWwuY29t" which is probably obfuscated enough considering that most of the users wouldn't be savvy or interested enough to figure out how to look at other people's records. Honestly none of the records contain terribly sensitive information. Simple base64 obfuscation would probably serve fine. But maybe one of you has a more secure method of accomplishing this outcome! Maybe using an application variable as a key? I don't know but I'm interested in finding out. Thanks in advance for the help!How do I encode ampersands located in an XML Do_Query field string so that they get properly decoded on Quickbase's end?
I have an automated system that, when triggered, uses information associated with the trigger to run a query and update another record based on the result of that query. There are a few fields related to the query that contain ampersands (e.g. "System 1&2") that must be matched for the automation to work. If I attempt to send a message with the ampersand unescaped (e.g.{22.EX.'System 1&2}), it fails because it is invalid XML. If I try to replace the literal ampersand with escaped versions that should be valid XML (e.g. {22.EX.'System 1&2'}, {22.EX.'System 1&2'}) QuickBase returns no error, but the query doesn't find what I expect it to, ostensibly because the escape character isn't then decoded back into an ampersand on the other end. I searched and searched and couldn't find any guidance on this issue for QuickBase in particular because for other systems, these escape characters seem to work. Thanks in advance for your help! Hopefully someone knows how to get around this, aside from replacing all the ampersands in our tables with some XML-conforming substitute.Re: How can I summarize the time cards associated with a particular deliverable or project on a monthly basis?
Hi Tyler! Thanks for responding. I didn't really have any one obstacle. My question was more of a design/workflow problem that I couldn't quite figure out. I was hoping someone would read it and have an immediate idea in mind. The workable solution I found was to create a new field in the Time Cards table that associated the deliverable being worked on with the month in which the work was completed. That way I could create a summary report where each entry was essentially ["Deliverable #1234 - April 2019", 16 hours]. Then I can export that summary table as a csv, and import it into a new table where that first field acts as the key field, the number of hours is filled in,and the other relevant information can be pulled in from the deliverables table with a relationship. I set up a Microsoft Flow flow (is that what they're called?) to automate that export/import process using a series of HTTP requests so it runs each night, keeping that new table more-or-less up to date. If anyone thinks up a better way to accomplish what I'm doing then I'm all ears! But this is what I worked up in the last 24 hours.How can I summarize the time cards associated with a particular deliverable or project on a monthly basis?
Hi! We bill a particular kind of deliverable to our clients on a monthly basis according to the number of hours worked on each deliverable that month. The result I envision for this problem is a table where each record consists of a unique field that is a concatenation of the key associated with the deliverable and the month in which work was completed on that deliverable (e.g. "1234 - April 2019" for deliverable #1234 if work on it was completed this month), the sum number of hours worked on that deliverable in that month (based on our existing Time Cards table), and a number of other fields relating to the deliverable in question. This seems like the best path forward for our use-case based on our billing process, but I don't think I'm necessarily married to it so let me know if I'm way off. We'd like to not have to run a different summary query for every month we want to look at or add a new field for every month of work. I want to run an import or automation on our existing Time Cards table to bring the new billing table up to speed for all existing time cards. Then moving forward, I'd like run an automation (either on a schedule or triggered by each new relevant time card) that either creates a new billing record for the deliverable-month if it doesn't exist, or simply updates an existing record with a new total of hours worked. I've been banging my head against the wall for a couple days trying figure out how to do this but it seems like I keep running up against some limitation with everything I try. Has anyone figured out a similar path or have an idea of how I could do this? I'm fairly savvy with specifying imports and actions and automations, and I could write up scripts if I have to, but naturally I'd rather do what I can in vanilla QuickBase if I can. Thanks in advance for helping! I hope I was anywhere close to coherent. Please let me know if there's anything I can clarify.
