http://m.getsatisfaction.com/companies/quickbase/topics?page=1 Topics in Quick Base 1970-01-01T00:00:00Z 14442 14264 0 0 0 501 http://m.getsatisfaction.com/topics/7898065 7898065 inventory management 2019-06-20T09:59:07Z 2019-06-20T07:26:44Z Walden Wang http://m.getsatisfaction.com/people/10096042 https://www.gravatar.com/avatar/378b295adb8112aa74e9f8c44262605e?d=identicon&s=55&r=PG walden_wang There's one parent table with field quantity which record how many items we have. Each item in parent table will have several child which also have quantity field means how many we consumed. Now I want the formula quantity of parent table - sum (quantity of child table). So I can know how many left? Does anyone happen to know how to make it? Thanks. question 1 2 1 comment http://m.getsatisfaction.com/topics/7436060 7436060 Why is Backing Up MAC to Windows on a USB not working? 2019-06-20T06:21:15Z 2013-12-08T21:01:29Z Pia http://m.getsatisfaction.com/people/8810390 https://www.gravatar.com/avatar/39d1306136f99aecbace6c06088a3316?d=identicon&s=55&r=PG pia_eg8hqxlrayjhu <p>Why can I not see any information other than the Tool Bar and all these little time-stamp icons that look like little hard drives on a MAC. It is a 2013 version of QuickBooks Pro MAC. On the PC version you open quick books and you have your home page and then you can select vendor, employee, customer, etc. and still see everything you need, however, with this MAC version we could not get any of this information to stay up. It would only allow us to write a check or enter a bill but not see the normal items one usually sees.</p><p>I was also trying to back up the information from a MAC to Windows onto a USB. It would not do it. It asked me to set up a password in order to protect the data, which I did, it would act like it was backing it up to the USB, but then it would say data could not be backed up.</p><p>Anyone have any suggestions.<br /></p> question complete 2 2 1 comment timestamp http://m.getsatisfaction.com/topics/7897941 7897941 Rich Text Field 2019-06-20T04:06:01Z 2019-06-19T21:59:39Z Mark Comish http://m.getsatisfaction.com/people/9496039 https://www.gravatar.com/avatar/c1a2b5b2d91250a25aa25fd06f79fc78?d=identicon&s=55&r=PG mark_comish Can you make a Rich Text (formula) field bold and color a word if it exists?&nbsp; I use SendToQuickbase to pull in emails received in outlook.&nbsp; I would like anywhere the message has "From:" to be automatically made bold and / or made to be red.&nbsp; question active 6 3 1 comment http://m.getsatisfaction.com/topics/7897336 7897336 Iterate JS code in a form 2019-06-20T03:41:45Z 2019-06-18T10:50:54Z User56842 http://m.getsatisfaction.com/people/10093281 https://www.gravatar.com/avatar/65cc06286ed4b2daf33e1d76b2c0b9df?d=identicon&s=55&r=PG user56842 I'm trying to have JS run in the background of a form in a loop that sets a couple of field values and then refocuses back to the original entry field (user is using a barcode scanner which is programmed to execute a tab after each scan).<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />First off, this is a form editing an existing record (always) and second, the record can't be saved until the user has completed multiple scans. So no saving and refreshing a page to reload the data/reset triggers.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />All of the code works fine when the form rules trigger the IOL field to run the JS module. However, after it finishes executing once and resets the form fields back to the starting conditions, it will not execute a second time even though the field with the IOL formula has reset.<br /><br />Does anybody know how to trigger JS multiple times on a single form without saving between each run and without user interaction (no button clicks) or how I could get the code to run in an async/await method to run as a loop in the background of the form?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Code below:<br alt="" name="" rel="" target="" title="" type="" value="" />(function(){<br />&nbsp; var querystring=document.location.search;<br alt="" name="" rel="" target="" title="" type="" value="" /> if (/a=er&amp;dfid=11/i.test(querystring)) {<br alt="" name="" rel="" target="" title="" type="" value="" /> var QB_flagTrigger=$("#_fid_55").val();<br /> var QB_barcodeOld;<br /> var QB_barcodeNew;<br /> var QB_newQty=0;<br /> var QB_reqQty=0;<br alt="" name="" rel="" target="" title="" type="" value="" /> function FieldUpdates() {<br /> QB_reqQty=parseInt($("#_fid_60").val(),10)<br /> QB_newQty =parseInt($("#_fid_31").val(),10)+1;<br /> QB_barcodeOld = parseInt($("#_fid_56").val(),10);<br /> QB_barcodeNew = parseInt($("#_fid_30").val(),10);<br /> if(QB_barcodeOld == QB_barcodeNew){<br /> //alert("valid");<br /> $("#_fid_31").val(QB_newQty);<br /> $("#_fid_30").val("");<br /> if(QB_newQty &lt; QB_reqQty){<br /> //alert("not enough qty");<br /> $("#_fid_55").val(3);<br /> }<br /> QB_flagTrigger = $("#_fid_55").val();<br /> } else {<br /> //alert("invalid");<br /> $("#_fid_30").val("");<br /> alert("Invalid Barcode" + "\n" + "Please rescan");<br /> $("#_fid_55").val(3);<br /> QB_flagTrigger = $("#_fid_55").val();<br /> }<br /> return;<br /> }<br alt="" name="" rel="" target="" title="" type="" value="" /> async function IterateLoop() {<br /> while (QB_flagTrigger==1){<br /> await FieldUpdates();<br /> }<br /> }<br alt="" name="" rel="" target="" title="" type="" value="" />IterateLoop()<br /> .then(() =&gt; alert("done and Qty = " + QB_newQty))<br /> .catch((err) =&gt; alert("error"));<br alt="" name="" rel="" target="" title="" type="" value="" /> document.getElementById("_fid_30").focus();<br /> document.getElementById("_fid_30").select();<br alt="" name="" rel="" target="" title="" type="" value="" /> }<br />})();<br /><br />Note that some of the above code was my testing async/await functionality in QB to see if I could put the FieldUpdate function inside of an async function and have the JS load with the form and constantly requery the fields and execute when needed. I probably screwed something up there since I'm new at async and during testing the page ran the loop without actually loading the form for the user to use.<br /><br />Thanks in advance for any help. question active 9 3 1 comment http://m.getsatisfaction.com/topics/7898007 7898007 Any shortcut to make an entire record 'Read Only' 2019-06-20T03:17:26Z 2019-06-20T03:10:12Z Scott Pugh http://m.getsatisfaction.com/people/9734808 https://www.gravatar.com/avatar/cd02886c3fffeef8c411515cb3223856?d=identicon&s=55&r=PG scott_pugh I have a record with a status field.&nbsp; When the status = x I would like to make the entire record ready only.&nbsp; &nbsp; Curious if there is a shortcut to do this other than making a fairly large form rule that sets all fields to read only.&nbsp; Also I would not like to involve different roles to solve this.&nbsp; Thanks. question 1 2 1 comment http://m.getsatisfaction.com/topics/7897878 7897878 Formula Rich Text and Formula URL Syntax 2019-06-20T01:57:09Z 2019-06-19T18:41:52Z Adam Keever http://m.getsatisfaction.com/people/9004340 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11252969/FLIR0191_medium.jpg adam_keever Is there a guide available for the correct syntax for the formula URL and formula Rich Text fields?<br /><br />I cannot find any resources other than bits &amp; pieces from various community posts. question active 3 3 1 comment http://m.getsatisfaction.com/topics/7897592 7897592 Quickbase email I.P address's blacklisted 2019-06-20T00:04:29Z 2019-06-18T23:50:22Z damien page http://m.getsatisfaction.com/people/9314111 https://www.gravatar.com/avatar/ae4dd8284f87e62ee714390b871aba8f?d=identicon&s=55&r=PG damien_page Not sure when the following 2 IP address's that Quickbase use to send out emails were blacklisted, but just posting to make others aware in case they are missing emails...<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><p alt="" name="" rel="" target="" title="" type="" value="">35.167.233.208</p> <p alt="" name="" rel="" target="" title="" type="" value="">34.223.212.232</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">Action</b></p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;ERROR</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">From</b></p> <p alt="" name="" rel="" target="" title="" type="" value=""><a alt="" href="mailto:msprvs1=180721o310aob=bounces-128638@qbmailbounces.quickbase.com" name="" rel="nofollow" target="" title="" type="" value="">msprvs1=180721o310aob=bounces-128638@qbmailbounces.quickbase.com</a></p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">To</b></p> <p alt="" name="" rel="" target="" title="" type="" value="">(myemailaddress)</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">Date</b></p> <p alt="" name="" rel="" target="" title="" type="" value="">2019-06-18 22:41:03</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">Details</b></p> <p alt="" name="" rel="" target="" title="" type="" value="">Sophos Anti Spam Engine has blocked this Email because the sender IP Address is blacklisted.</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">Received by</b></p> <p alt="" name="" rel="" target="" title="" type="" value="">inbound4.eu.mailhop.org</p> <p alt="" name="" rel="" target="" title="" type="" value=""><b alt="" name="" rel="" target="" title="" type="" value="">Server</b></p> 35.167.233.208<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question active 2 2 1 comment http://m.getsatisfaction.com/topics/7897939 7897939 hello I need to divide the values of two filds.They are the same fields but have a different record id's is there a way to do it. 2019-06-19T23:03:13Z 2019-06-19T21:51:45Z Kristy Williford http://m.getsatisfaction.com/people/10014431 https://www.gravatar.com/avatar/38deb64786758d53cd0592bc8dadd62b?d=identicon&s=55&r=PG kristy_williford EXAMPLE:<br /><br />Record 1: Field A&nbsp;&nbsp;<br />Record 2 :Field A<br /><br />divide field A of record 2 and record 1 question active 5 2 1 comment http://m.getsatisfaction.com/topics/7897413 7897413 Time capture - Device time 2019-06-19T22:06:11Z 2019-06-18T15:10:59Z Nick Michailides http://m.getsatisfaction.com/people/10093623 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11426207/headshot_medium.jpg nick_michailides Hi everyone, I am building a form that will be used primarily on QB Mobile. I need to have a field that will be read-only and capture the current time of the device. I have created a few different time fields but they all seem to have the same result of capturing the time the app is set to. For example, My app is set to PST but I am in EST, I conduct an inspection and the time field reflects PST.&nbsp; I have users in multiple time-zones and for regulatory reasons I need the time to be read-only and display the correct time for the device.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /> question active 6 3 2 comment http://m.getsatisfaction.com/topics/7897872 7897872 Lookup from a lookup 2019-06-19T21:33:41Z 2019-06-19T18:32:06Z Montgomery Hepner http://m.getsatisfaction.com/people/10044654 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11418030/CCapture_edited_medium.jpg montgomery_hepner My title is probably not very accurate, but I was not sure how to phrase my situation.<br /><br />I am creating an app that is used for Construction job scheduling. I have created a child table [Equipment] another child [Job information] and a parent [Scheduler]. What I am trying to do is look up the equipment type which was created using a Text-multiple choice field. In that I have a list of equipment that can be selected for the particular job. In the Job info table I am doing a lookup that allows the user to select the right equipment. All fine there.From there I want to pass that value into the Scheduler table. When I attempt that look up (from the Job info table) all I get back is a numeric reference. When I create the lookup from Scheduler to Job info it creates a Create schedule option. When I choose that I get the result described above. How do I pull that info over as it is displayed in my Job info table? question complete 3 2 1 comment http://m.getsatisfaction.com/topics/7751030 7751030 Best way to Frame App and remove all headers 2019-06-19T21:08:28Z 2018-06-16T09:46:14Z Gary Boyd http://m.getsatisfaction.com/people/9623700 https://www.gravatar.com/avatar/ea18e01cb2ae788e58e6c0bf3ddd29a1?d=identicon&s=55&r=PG gary_boyd_1ihbn3ff0q29e Hi,<br />I want to remove all the headers for users of the app, both for viewing benefit and security - I am using roles and permissions, so this is more for viewing and removing dead screen space.&nbsp;<br /><br />&amp;ifv=1 works fine and I can add it to most buttons. However, when using native QB functions, like: save from a form, or click a record to view it, you see all the headers again.&nbsp;<br /><br />Is there a good way to frame the app and keep the native functionality?<br />If no option for this, is there a way at least to hit a save button and then add an &amp;ifv1?<br /><br />Thanks. question complete 18 6 1 comment http://m.getsatisfaction.com/topics/7897788 7897788 Quick Base Annual Customer Survey 2019 2019-06-19T20:02:05Z 2019-06-19T14:46:17Z Evan Martinez http://m.getsatisfaction.com/people/9412562 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11225783/902287_10100911409080709_1910579452_o_medium.jpg evan_martinez_7wn4stlgbnpyr With Empower 2019 behind us it is now time for our annual customer survey here at Quick Base. Tell us more about how you use Quick Base in your organization and get a chance to win a complimentary ticket to Empower 2020 in San Diego. It is a perfect chance to make sure you are all set for Empower next year and to pass on some feedback we can use to make sure we have even more exciting things to show off next year.&nbsp;<br /><br /> <a href="https://team.quickbase.com/db/bmppgsxvd?a=dbpage&amp;pageid=2#/surveys/QBEMPCUST2019" rel="nofollow" target="_blank" title="Link https//tinyurlcom/QBEMPCUST2019 ">Click here</a>&nbsp;for Quick Base’s fifth annual customer survey.<br /><br /> Thanks! article 3 3 1 comment http://m.getsatisfaction.com/topics/7897893 7897893 Need a consultant for building out and cleaning up our App! 2019-06-19T19:48:40Z 2019-06-19T19:19:48Z Molly http://m.getsatisfaction.com/people/8811860 https://www.gravatar.com/avatar/567734458f1bf5e0fca23af0aff31001?d=identicon&s=55&r=PG molly_hx321rxnoy3ny Our small business has been living in an app for the past 3 years.&nbsp; We have been making some improvements, but I am looking to find an expert who can help me with the bigger tasks in cleaning up our application.&nbsp; question active 3 4 1 comment http://m.getsatisfaction.com/topics/7897863 7897863 QB Variable Save and Keep Working Button - Unsupported and Deprecated 2019-06-19T19:11:53Z 2019-06-19T18:14:40Z Adam Keever http://m.getsatisfaction.com/people/9004340 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11252969/FLIR0191_medium.jpg adam_keever Based on the community feedback in this Quick Base Community post:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><a href="https://bit.ly/2ZtUg4A" rel="nofollow">https://bit.ly/2ZtUg4A</a> <br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have been using a technique that involves using a QB variable defined as...<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&lt;a class='Vibrant' style='font-size:12px; color:black; background:#33ff33; white-space:nowrap;' onclick='$("#saveAndKeepWorkingMenuOption").click();'&gt;Next&lt;/a&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />...and referencing it in a formula rich text field to create a save and keep working button that i can place on a form. It works great on desktop, but not at all on mobile. I was advised to open a user support ticket. This is an easy way to create the record<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Here is the feedback from the support ticket:<br alt="" name="" rel="" target="" title="" type="" value="" /><blockquote alt="" name="" rel="" target="" title="" type="" value="">The function being called cannot be used in a formula field. Furthermore, the features that are being taken advantage of are not intended for public use and will eventually be deprecated.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />All said, this is a browser/mobile discrepancy that we do not plan on addressing as the functionality being invoked is generally unsupported.</blockquote>I just wanted to give a heads up for anyone using this technique so you can find a different solution before the functionality ceases.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question active 1 2 1 comment http://m.getsatisfaction.com/topics/7897846 7897846 merge/split forms 2019-06-19T17:47:35Z 2019-06-19T17:36:14Z Adam Keever http://m.getsatisfaction.com/people/9004340 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11252969/FLIR0191_medium.jpg adam_keever Does anyone know of a way to merge/split forms?<br /><br />For instance; I originally constructed 3 separate forms to capture various data of a record and now I would like to easily have all of those fields in one form.<br /><br />I would love to be able to merge the three forms into one; and vice versa have the option to split a very large form into multiple forms. question active 2 2 1 comment