Topics in Quick Base 1970-01-01T00:00:00Z 11118 11103 0 0 0 157 7633507 error on API_FindDBByName 2017-11-18T11:03:24Z 2017-11-18T11:03:24Z Vinayak Pavaskar vinayak_pavaskar I am new to quickbase. I have a task to fetch user details using quickbase API. I am trying to connect to each app using API_FindDBByName. but for few apps I get following error "Exception of type 'Intuit.QuickBase.Core.Exceptions.UnableToParseXmlException' was thrown." can somebody help me to understand as what could be the possible reason question 0 1 1 create 7633336 Combo Primary Key 2017-11-17T23:54:19Z 2017-11-17T23:17:39Z Shari Moehlenkamp shari_moehlenkamp How do I set two fields in a table as a combo primary key, like in Access?&nbsp; Thanks! question 1 2 1 comment 7633222 Highlight row based on number of weeks 2017-11-17T21:34:35Z 2017-11-17T19:01:03Z Greg Bearringer greg_bearringer I am attempting to create a report that will display any task that has been assigned to be based on the due date in relation to today. I was anything due &gt; than two weeks in the future to be green, anything due in the next two weeks to be orange, and anything overdue to be red. I have tried a few things, but I can't get the weeks function to work because it's a "duration" and not a date.&nbsp; question 1 2 1 comment 7633287 Need help moving children records to a new table 2017-11-17T21:30:42Z 2017-11-17T21:09:31Z Cameron Hughes cameron_hughes_71luf0o0x432k I have a parent record that has a variable amount of children records. When I set a field in the parent record to Approved, I want the 4 children records to be written to a "Final" table.<br /><br />At the moment I have a button on the parent record that will set a field to Approved. The children records all have a lookup field that retrieve the Approved info.<br /><br />Apparently a quickbase action cant look at a lookup value, so i created a formula text field that is equal to the lookup field.<br /><br />I want quickbase to see that the formulas value has changed, and then run an action to move each record to the new table.<br /><br />It seems like when a lookup or a formula field change, that the date modified does not. Any suggestions? question 2 3 1 comment 7632965 Auto re-order steps in a process 2017-11-17T19:53:56Z 2017-11-17T11:01:20Z Adam Cozine adam_cozine_2l7jbpx5itap2 This seems like it should be very basic, but am unable to figure it out.&nbsp; I am building out a detailed process.&nbsp; Step #1, Step #2, Step #3 to be used as a template.&nbsp; The process is ever changing.&nbsp; How do I enter a new step after Step #2, so that it now becomes Step #3, and the previous Step #3, is now Step #4.&nbsp; Thank you!&nbsp; question 6 4 1 comment 7574817 Record owner of record created with QuickBase Actions 2017-11-17T17:16:07Z 2017-08-16T12:44:21Z Yoel Kuliasko yoel_kuliasko I have setup an action using QuickBase actions, where adding a record in one table creates a record in another table. It appears that I (administrator) am the record owner in the other table of all records created by the action. (I would want the record owner of the original record also to be the owner of the by the action created record)<br />Is this intended? Is this because I'm owner of the action? Am I overlooking something?<br />Thanks, question 11 7 1 comment 7632589 Outlook to QuickBase Help 2017-11-17T17:05:07Z 2017-11-16T19:41:58Z Ryan ryan_wianecki Looking for a way to have emails in Outlook be sent to Quick Base to create a Pipeline List. I know there's the connected tables option to Microsoft&nbsp;Exchange but our email service is controlled by outside security so I am not authorized to link it that way. Just looking for another solution that may work best. Or if anyone has a better way of tracking Sales leads that are created from outlook, open to listening. question 2 4 1 comment 7632709 Quick Base Database Access 2017-11-17T16:55:50Z 2017-11-16T22:56:25Z Robert Garrow robert_garrow I need to see the QB database that underlies the tables in my Quick Base App.&nbsp;&nbsp; How can I do that? question 1 5 1 comment 7442103 URL Button to show a form element in pop up window? 2017-11-17T16:31:12Z 2017-01-06T16:22:12Z Tony tony_hwnf1firw6wkw Basically, this is just an aesthetic request. &nbsp;How can I have a javascript window to pop up and show a specific&nbsp;field? &nbsp;ie<br /><br />&lt;button: Show name &gt;<br /><br /> Pop up window:<br />George Washington question complete 11 8 3 comment field, button, javascript, form, url 7633035 Schedule Tool with Dates across the top 2017-11-17T13:57:11Z 2017-11-17T13:57:11Z Jessica jessica_2y7krc2r77n5a We are using a scheduling tool that is essentially just an Excel spreadsheet in this format:<br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1673267/RackMultipart20171117-109161-10hxt9p-Schedule_inlineJPG1510926536" /><br /><br />I'd love to move it into QuickBase to be able to do reporting off of it.&nbsp; So far, I have created tables for Date, Project and Resource (employee).&nbsp; I've made a Schedule table and built is as a child table of all three tables. I can bring them together as below:<br /><img src="" /><br /><br />My question is: can i create a report where the Dates will go across the top of the report, like in my screenshot above?&nbsp; <br /><br />I know I'll get too much push back if I can't get it into the format people are used to.&nbsp; I'm okay with using Javascript to accomplish this. question 0 2 1 create 7632902 Report filter(Reporting Manager is the current user) is not working for me 2017-11-17T12:37:31Z 2017-11-17T07:23:03Z Gayathri A gayathri_a_a0ftekk70xy0z &nbsp;I'm trying to filter the records based on the current user. I have a field named "Employee - Reporting Manager" which is a user lookup field. In the reports filter, I have set the criteria as "Employee - Reporting Manager" is the current user. In this field, I have a value(Gayathri, A). But when I log in as this user, this particular record is not being displayed in the report. Not sure where it is going wrong. question 6 3 1 comment 7628545 How to get the User status (deactivated, denied etc...) in the formular field 2017-11-17T10:23:11Z 2017-11-09T19:04:32Z Kelechi kelechi_gn2ez9c1okxnz On the quickbase table, if it shows that a user is deactivated. How can i detect using a formular field that that user is deactivated.<br /><br /><a href="" rel="nofollow" target="_blank" title="Link https//helpquickbasecom/user-assistance/about_user_statushtml"></a> question 2 3 1 comment 7631271 Create URL formula that redirect and also calls a script 2017-11-17T09:59:24Z 2017-11-14T19:06:46Z Ana ana_5a3aq1cckgici I need to create a button that will update a record and redirect back to the edit form, and at the same time, trigger a script to run in the background.&nbsp;<br />The orginal URL formula field states the following:<br /><b>URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord&amp;AppToken=XXXXX&amp;rid=" &amp; URLEncode ([Record ID#])&amp; "&amp;_fid_233=yes&amp;_fid_254=" &amp; Now() &amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid=" &amp; [Record ID#])</b><br />Now, to add a call to a script page, I am at a loss. In most cases, I would do a separate button to call it, but it should only be called once on the page, and triggered when the button above is clicked. It makes sense then to add it to the same formula URL field. My initial thought was to just add it to the URL, but is not currently working. So I am not sure what to do next. Below is the text I need to add.&nbsp;<br /><b>$.getScript('" &amp; URLRoot() &amp; "db/" &amp;Dbid() &amp; "?a=dbpage&amp;pagename=PAGENAME.JS&amp;rand='+Math.random())\"</b><br />The worst part is, I had this working a few weeks ago, and I cannot find my documentation for how I ended up getting it to work.&nbsp;<br />Any ideas would be appreciated, thanks! question 2 2 1 comment 7632611 Quick Base Data Center Switchover 2017-11-16T20:12:13Z 2017-11-16T20:12:13Z Andrew Scarpetti andrew_scarpetti <b><u>Overview</u></b><br /><br /> &nbsp;<br /><br /> In order to ensure the availability of the Quick Base platform, Quick Base hosts the platform in two geographically diverse data centers located in Las Vegas, NV and Denver, CO.&nbsp; Quick Base can run actively in only one location at a time with the other location running in standby mode.&nbsp; We periodically need to switch between the two data centers as part of our normal disaster recovery plan validation process.&nbsp; Since May 6, 2017, Quick Base has been active in our Las Vegas data center.&nbsp; On Saturday, December 9, 2017, between 12:00 AM and 2:00 AM Eastern US Time, we plan to switch Quick Base to be active in our Denver, CO data center.&nbsp; The Quick Base platform instances in both sites are always identical so there will be no change in Quick Base function or performance.&nbsp; Switching between data centers allows us to ensure that Quick Base’s disaster recovery plan is tested and working properly should there ever be a real disaster.<br /><br /> &nbsp;<br /><br /> <b><u>Key Messages</u></b><br /><br /> &nbsp;<br /><br /> 1.&nbsp;&nbsp; As part of our disaster recovery plan validation process, Quick Base will be switching the active instance of the platform, i.e., the instance used by our customers and partners, from our Las Vegas, NV data center to our Denver, CO data center.<br /><br /> 2.&nbsp;&nbsp; There will be NO change in how Quick Base functions or performs and NO change in Quick Base’s availability, disaster recovery, security, or compliance (<a href="" rel="nofollow" target="_blank" title="Link:"></a>).<br /><br /> 3.&nbsp;&nbsp; There will be NO change in the certificates used by Quick Base.<br /><br /> 4.&nbsp;&nbsp; The specific IP address that is resolved by your browser or API program when you access Quick Base will change but your company’s name resolution (DNS) servers should automatically return the proper address for our Denver, CO data center.&nbsp; In some cases, you may need to restart your browser or API program.<br /><br /> 5.&nbsp;&nbsp; Customers and partners who whitelist the IP address ranges used by Quick Base can verify that they have all the applicable ranges by checking out this link: <a href="" rel="nofollow" target="_blank" title="Link:"></a><br /><br /> 6.&nbsp;&nbsp; We are currently planning to switch data centers on Saturday, December 9, between 12:00 AM and 2:00 AM Eastern US Time.<br /><br /> 7.&nbsp;&nbsp; Quick Base will be down during the switch for no more than that 2 hour period and that down time is the only impact of the switch on customers and partners. update 0 2 2 create 7632550 EMPOWER2018 Call for Speakers 2017-11-16T18:42:08Z 2017-11-16T18:42:08Z Andrew Scarpetti andrew_scarpetti Share your Quick Base knowledge at our biggest user conference!&nbsp; Speakers will receive one&nbsp;<strong>complimentary Full Conference Pass</strong>&nbsp;($899 value) to EMPOWER2018 and a&nbsp;<strong>10% discount code to share</strong>&nbsp;with colleagues.&nbsp; View the details here:&nbsp;<a href=";pageid=101" rel="nofollow" target="_blank" title="Link:;pageid=101">;pageid=101</a> update 0 2 2 create