http://m.getsatisfaction.com/products/232818/topics?page=1 Topics for Tips & tricks 1970-01-01T00:00:00Z 285 270 0 0 0 23 http://m.getsatisfaction.com/topics/7818789 7818789 Why is quickbase highlighting the text in the first text field... 2018-11-17T02:49:33Z 2018-11-16T23:36:22Z Surya Avantsa, Certified Builder and Expert http://m.getsatisfaction.com/people/9774163 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11341494/linkedin_medium.jpg surya_avantsa_bnmk1bo22huu9 ...and how can I avoid it through out the application?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question 10 3 1 comment http://m.getsatisfaction.com/topics/7768972 7768972 Geo Location Button Desktop vs Mobile (Creating a button that captures the current Geo Location and updating a date field on Mobile.) 2018-11-16T12:12:50Z 2018-07-25T13:08:40Z Paul Vorster http://m.getsatisfaction.com/people/8959120 https://www.gravatar.com/avatar/79e7ecbec5eebce59abda07f0372092e?d=identicon&s=55&r=PG paul_vorster Goodday Everyone, I hope someone can assist out there...we have created a GEO Locate button, whcih captures the Current User Location and also update a date field.&nbsp; When we test the button on desktop, it works perfectly, but it doesnt want to work on mobile.&nbsp; Can anyone assist in having a look at our code?<br /><br />Current Button Code:<br />If([Start_Latitude] = null and [Start_Longitude] = null,&nbsp;<br />"javascript:" &amp;<br />"var QBU_recid="&amp; [Record ID#] &amp; ";" &amp;<br />"void(jQuery.getScript('" &amp; URLRoot() &amp; "db/bniyztgvg?act=dbpage&amp;pagename=insertGeoLocationStart.js'));",&nbsp;<br />"javascript: alert('A location for this drop has already been captured.');")<br />&amp;<br />If([Start_Latitude] &lt;&gt; null and [Start_Longitude] &lt;&gt; null, "javascript:DoSaveAdd()")<br /><br /><br />Current Javascript Page:<br />jQuery(document).ready(function getLocation()<br />&nbsp; {<br />&nbsp; if (navigator.geolocation)<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; navigator.geolocation.getCurrentPosition(showPosition);<br />&nbsp; &nbsp; }<br />&nbsp;&nbsp;<br />var test = $.ajax({url: url,async:false,success: pushResult}).responseText;<br />&nbsp; &nbsp;return false;<br />});<br /><br /><br />function showPosition(position){<br /> <br />&nbsp; &nbsp; &nbsp; //alert("insertGeo Running!");<br />&nbsp; &nbsp; &nbsp; var dateNow = new Date();<br />&nbsp; &nbsp; &nbsp; var cdate = ('0' + dateNow.getDate()).slice(-2) + '-' +&nbsp; ('0' + (dateNow.getMonth()+1)).slice(-2) + '-' + dateNow.getFullYear() + ' ' + dateNow.getHours() + ':' +(dateNow.getMinutes() &lt; 10 ? "0" : "" ) + dateNow.getMinutes();<br /> <br />&nbsp; &nbsp; &nbsp; //edit record<br />&nbsp; &nbsp; &nbsp; var editURL = "";<br />&nbsp; &nbsp; &nbsp; editURL = "bniyztgvg";<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;editURL += "?act=API_EditRecord&amp;key=" + QBU_recid;<br /> _fid_180.value = position.coords.latitude;<br />&nbsp; &nbsp; &nbsp; _fid_181.value = position.coords.longitude;<br /> _fid_77.value = cdate; <br /> addURL += "&amp;apptoken=n8wdqec5bzncectj7v7edp8ad9x";<br />&nbsp;&nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br /> <br />&nbsp; &nbsp; &nbsp; $.ajax({url: editURL,async:false});<br />&nbsp; &nbsp; &nbsp; location.reload(true);<br />&nbsp;}<br /><br /><br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1742563/RackMultipart20180725-106981-13hzf6y-Screen_Shot_2018-07-25_at_14.59.17_inline.png?1532524012" /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1742564/RackMultipart20180725-52578-1sultkr-Screen_Shot_2018-07-25_at_14.58.53_inline.png?1532524038" /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1742565/RackMultipart20180725-12433-5icb56-Screen_Shot_2018-07-25_at_14.58.53_inline.jpg?1532524094" /> question active 4 6 1 comment http://m.getsatisfaction.com/topics/7818303 7818303 Matching Text in one Table to Text in related Table to get related table ID# (Without Hard Coding Text) 2018-11-16T04:14:01Z 2018-11-15T20:05:42Z QuickBase Girl http://m.getsatisfaction.com/people/9748909 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11314987/13495275_10207687667563664_1201175693413897479_n_medium.jpg quickbasegirl Ok, So I have a text import debacle on my hands.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have an import coming in from an outside system, where they have Jobs that are already in QB, BUT the only way to match up these jobs, with the ones already in QB, is by matching the text of the Job [Title], [Level], and [Sub-Level]. All text. (not what I like doing, and if there were another way, I would do it. But there isn't.)<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have tables in the QB for all all these fields (Title], [Level], and [Sub-Level]), but as I import the new information, I need it to automatically match &amp; populate the Record ID from each of these tables into the import table. This needs to happen by the only means I have, matching the text coming in.<br /><br />I don't want to hard code this in because there may be text changes to the import records or additions to the tables.&nbsp;<br /><br />Also, I cannot just make a dropdown related because I need the records to automatically match, and the users, for the most part, will not have access to editing this table.<br /><br />I know there is something for this.&nbsp;<br /><br /><i>(P.S. - I understand if you may need further clarity. It is 4am in Japan and I have been up for a while. I am here on my honeymoon, and just trying not to go crazy with this import problem. All help is appreciated.)</i> question active 4 2 1 comment http://m.getsatisfaction.com/topics/7818318 7818318 Use API_EditRecord without refreshing page or navigating away 2018-11-15T21:12:30Z 2018-11-15T20:53:23Z Alex Gale http://m.getsatisfaction.com/people/9662520 https://www.gravatar.com/avatar/1e0a6e7af1eb5fe5a4ec5bbfec25a649?d=identicon&s=55&r=PG alex_gale_ch3tgjix8rnc1 I'm using a formula URL field button to edit records. The way I want to use that field is on an embedded report on another table. I've been making use of the following formula for ease of use:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />var text url = API_EditRecord call of some sort<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />javascript:$.get('" &amp; $url &amp; "',function(){location.reload();});" &amp; "void(0);<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />This refreshes the page on click, which is nice as it even displays the change immediately. <br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />However, I recently put the embedded report in a different tab on the form. Now, refreshing the page brings the user back to the leftmost tab, which is annoying. <br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Is there a way to set it up so that users can click the button and have the API call go through while staying on the current page and tab?<br /><br />Ideally, we would also be able to see the change on the embedded report as if the page was refreshed, but that's not required.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Thank you question complete 2 3 1 comment http://m.getsatisfaction.com/topics/7816578 7816578 Encoding combined text fields to Numeric Sequences 2018-11-14T05:35:25Z 2018-11-11T23:04:31Z QuickBase Girl http://m.getsatisfaction.com/people/9748909 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11314987/13495275_10207687667563664_1201175693413897479_n_medium.jpg quickbasegirl I need all of the smartest QB cats on the block for this one. I have been banging my head against the limits of my Java Script and have come up with nothing that works.<br /><br />Here is what I need to accomplish:<br /><br />I need to take 3 text fields ([text1]&amp;t[text2]&amp;[text3]) and turn them into a string of numbers based on their alpha make up. Example: [a cat]&amp;[the dog]&amp;[a rat] = 10312222850417118122 (space can be 0)<br /><br />Does anyone have a working formula for this? question active 7 3 1 comment http://m.getsatisfaction.com/topics/7794486 7794486 Sneak Peek: Type-Ahead Search Picker 2018-11-12T23:01:57Z 2018-09-19T20:17:44Z Sam Jones http://m.getsatisfaction.com/people/9284282 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11192206/54aae9990e8ab9822f7ae50b23035bec_medium.jpg sam_jones_ilwbq7xdtexk6 <img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752553/RackMultipart20180919-24556-j1adac-2018-09-18_16-54-58_inline.png?1537387883" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1752553RackMultipart20180919-24556-j1adac-2018-09-18_16-54-58_inlinepng1537387883" /><br /><br />While we at Quick Base love to work on great new features, like Kanban reports or Automations, we also take time to focus on the fundamentals. And what could be more fundamental to Quick Base than quickly and accurately entering data?&nbsp;<br /><br />So many of our customers tell us they come to Quick Base apps because they’ve outgrown spreadsheets and need to move to a relational database to handle the complexity of the work they need to track. Recently, we’ve been taking a hard look at how we can improve this fundamental activity of Quick Base apps: relating data.<br /><br />What did we find? After talking to customers with big data sets and small, we realized our record picker needed to be better at finding records quickly and making sure users knew exactly what record they were picking!&nbsp;<br /><br />If you’re not familiar with our record picker, here’s a crash course. (You can find out more about configuring it in Quick Base University.)<br /><br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752554/RackMultipart20180919-81617-4700pe-2018-08-31_16-44-22_inline.png?1537387927" title="Image httpsd2r1vs3d9006apcloudfrontnets3_images1752554RackMultipart20180919-81617-4700pe-2018-08-31_16-44-22_inlinepng1537387927" /><br /><br />When you’re working with a relatively small data set, we show a simple HTML drop down. It works well if you’ve got some easily discernible records and you know what you’re looking for, but if you’ve got a larger set of data, it can be much harder to find what you’re looking for.<br /><br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752555/RackMultipart20180919-101308-72c3y7-2018-08-31_16-47-06_inline.png?1537387966" /><br />Now, one of the things we all love about Quick Base is how deeply customizable it is. So what if I want to only pick from records which meet a certain criteria? Or if I want to make sure the most likely to be picked options are at the top? Quick Base has a solve for that! In the form properties, you can choose a report on which to base the record picker, which allows you filter and sort the field.&nbsp;<br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752557/RackMultipart20180919-596-19x3i0z-2018-08-31_16-49-32_inline.png?1537388002" /><br /><br />It’s great that you can apply sorts and filters, but unless you really trim down the columns, it can be really hard to read for end users. Beyond that, they may not understand what data is displayed in the list and given that each record displays all its data on one line, it can be hard to match up values to compare them.<br /><br />In addition, our users told us they expected to search through these records to find what they were looking for, but our simple record dropdown doesn’t support that. For search, we need to go into the record picker pop-up.&nbsp;<br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752558/RackMultipart20180919-73062-1fy6cbe-2018-08-31_16-53-12_inline.png?1537388050" /><br />In field properties, you can configure this relationship to always use our record picker pop-up but getting to it requires more clicks and takes the user out of the context of the record they’re editing.<br /><br />What we found in talking to customers was that their teams needed a faster way to search their data.<br /><br />After seeing all this, we got to work. Presenting the new Quick Base Type-Ahead Search Picker:<br /><br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752559/RackMultipart20180919-114625-r2mg3c-2018-09-18_16-31-29_inline.png?1537388102" /><br /><br />If your app builder has chosen to display only one field to pick records on, we’re now going to present a fast, searchable picker, very much like the new field picker we rolled out back in spring or the user picker we've have.&nbsp;<br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752560/RackMultipart20180919-117720-tikwr2-2018-09-18_16-38-04_inline.png?1537388141" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1752560/RackMultipart20180919-117720-tikwr2-2018-09-18_16-38-04_inlinepng1537388141" /><br /><br />If your app builder has chosen a report or the standard record picker to select from, you’ll see a multicolumn picker, able to display up to nine fields of relevant data, with each column labeled so users clearly can see what they’re picking from.<br /><br />We load the first 50 results automatically, so users can browse. As you search, the list updates in real time, pulling in more records and highlighting the matching terms, very much like our user field type.&nbsp;<br /><br />This new picker will be rolling out to all users in the coming months. If you’d like a sneak preview, we have it available in early access starting the week of September 24th. Just have your realm administrator open a support ticket and request it at <a href="https://login.quickbase.com/qb/support/redirecttorealm?subject=New+Case%20&amp;rdr=https://login.quickbase.com/qb/support/redirecttorealm?subject=New+Case" rel="nofollow" target="_blank" title="Link httpsloginquickbasecomqbsupportlistcases">https://login.quickbase.com/qb/support/listcases</a><br /><br />Thanks for reading and be on the look out for more posts and previews about our new&nbsp;type-ahead search picker!<br /><br /><br />Sam Jones<br />Quick Base Product Manager article 56 13 3 comment http://m.getsatisfaction.com/topics/7816025 7816025 Importing info from two separate CSV files into one Table and matching up the right info to eachother? 2018-11-12T21:47:36Z 2018-11-09T22:26:19Z cs5469 http://m.getsatisfaction.com/people/8805771 https://www.gravatar.com/avatar/8540bcc3f4a2d4b2750f3efe961e576f?d=identicon&s=55&r=PG cs5469 I have information on 2 separate CSV files that I want to end up on one table in QuickBase. The common link between the information in the 2 CSV files is the "PO Number" field. What is the best way to upload both files so that the right info from one CSV file ends up with the corresponding info on the other CSV file? question active 2 2 1 comment http://m.getsatisfaction.com/topics/7815464 7815464 How to display the table name from dbid 2018-11-12T21:04:30Z 2018-11-08T17:47:46Z Jim Harrison http://m.getsatisfaction.com/people/9162215 https://www.gravatar.com/avatar/82f5dd78617ace4ff5c966e2dc888920?d=identicon&s=55&r=PG jim_harrison_c6t3ro02iz6mt This may be obvious but I am not finding a solution anywhere.<br />I have a field where the dbid is input as text. I want to use a formula field to convert the dbid to the table name. Is this possible? question active 2 3 2 comment http://m.getsatisfaction.com/topics/7814258 7814258 Quick Base Certification should be made portable from one job to another. 2018-11-12T16:52:32Z 2018-11-05T22:24:09Z Surya Avantsa, Certified Builder and Expert http://m.getsatisfaction.com/people/9774163 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11341494/linkedin_medium.jpg surya_avantsa_bnmk1bo22huu9 When I obtained my Quick Base "Builder and Expert" certification, I was working at one organization. After I changed jobs I am no longer able to access this certification. Without redoing the entire exams, how can I continue my certification? I am now at a different organization. question complete 2 2 1 comment http://m.getsatisfaction.com/topics/7715983 7715983 how do I create a button that allows the user to continue to the next tab 2018-11-09T21:33:21Z 2018-04-06T01:19:46Z Lorraine Chung http://m.getsatisfaction.com/people/9613479 https://www.gravatar.com/avatar/09ac8824ebb5c3736559b053b1154ebe?d=identicon&s=55&r=PG lorraine_chung We are creating a public form with multiple sections. Using the new tab section makes the form looks a lot neater, which is great, but there doesn't seem to be a way for us to indicate to the user where they are in the form and direct them to the next tab.&nbsp;<br />Does anyone know how to create a button where the user can be redirected to the next tab? Or save and redirect to the next tab, or a field that is in the next tab?&nbsp;<br /><br />Also, this is a very noob question, but where can I find the url&nbsp;for my form which removes the Quickbase header and tabs?&nbsp;<br />And how do I embedd the form into an iframe?&nbsp;<br /><br />If it's embedded in an iframe, when I look at it on a mobile, does it default to the QB mobile view?&nbsp;<br /><br />Thanks in advance question complete 19 7 2 comment http://m.getsatisfaction.com/topics/7815596 7815596 Include link to record id in multiple record version email. 2018-11-08T22:48:57Z 2018-11-08T22:48:57Z Nilesh Patel http://m.getsatisfaction.com/people/9003508 https://www.gravatar.com/avatar/dbfc4173acc3a703979ab70877db041b?d=identicon&s=55&r=PG nilesh_patel_85tt5ovxjeld7 I need to be able to create a muItiple record version email where the link to record will show on the email.&nbsp; I know quickbase does not support this for multiple record version, but i was wondering if anyone has found a work around. Currently i have created a checkbox that can be used in grid edit, which will fire a quickbase action to create a record in another table.&nbsp; In the new table i have created a notification that will be sent to users from a relatonship.&nbsp; When trying to user markers i just get the field id or %reclink% in text.&nbsp;&nbsp; question 0 1 1 create http://m.getsatisfaction.com/topics/7815402 7815402 Will Crystal Reports 2008 fail upon TLS 1.0 disable? 2018-11-08T15:49:40Z 2018-11-08T15:44:59Z David Brogdon http://m.getsatisfaction.com/people/9753260 https://www.gravatar.com/avatar/22425dca882b019eb7bc343dc9c503a5?d=identicon&s=55&r=PG david_brogdon We are running Crystal Reports 2008, not sure which SP&nbsp;<br />Will this fail to connect after TLS 1.0 &amp; 1.1 are disabled?<br /><br />Does anyone know of a fix/patch? Any insight is appreciated!! question pending 1 2 1 comment http://m.getsatisfaction.com/topics/7814437 7814437 Automatic import and Export Excel/CSV from Local pc to quickbase without using third-party apps of quickbase 2018-11-08T09:02:49Z 2018-11-06T10:25:55Z Murali Krishna Gangineni http://m.getsatisfaction.com/people/9820546 https://www.gravatar.com/avatar/a45d30efee0005a8920cee098a8d309b?d=identicon&s=55&r=PG murali_krishna_gangineni How to import &amp; export data from local pc to quickbase and quickbase to local pc simultaneously without using third-party connected data apps of quickbase. Can I achieve the same by using webhook?<br alt="" name="" rel="" target="" title="" type="" value="" /> question active 5 5 1 comment http://m.getsatisfaction.com/topics/7780620 7780620 Custom buttons for tabbed forms: Save & Next Tab, Save & Same Tab 2018-11-03T23:11:07Z 2018-08-20T16:02:33Z Alex Wilkinson http://m.getsatisfaction.com/people/9082687 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11146849/Alex-atNYPL_medium.jpg alex_wilkinson_bw0xhnlu3eevi Here's a method to do variants of "Save &amp; keep working" within a tabbed form. First, I'll explain how to create a "Save &amp; next tab" button. Then, with slight modification, I'll show "Save &amp; same tab".<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[1] On the form properties, do <b alt="" name="" rel="" target="" title="" type="" value="">not&nbsp;</b>check "Show Save &amp; close and Cancel buttons at the end of this form" and&nbsp;<b alt="" name="" rel="" target="" title="" type="" value="">do</b> check "Show save &amp; keep working choice"<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[2] Create a rich-text-formula field called, say, "Custom Save and Next Tab". Temporarily, you can fill it the text "Save &amp; next tab". Eventually, after completing the steps below, it will contain a custom Page and several custom Variables, like this:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[customButtonScript1]<br alt="" name="" rel="" target="" title="" type="" value="" />&amp; "saveAndNextTab.js"<br alt="" name="" rel="" target="" title="" type="" value="" />&amp; [customButtonScript2]<br alt="" name="" rel="" target="" title="" type="" value="" />&amp; [customButtonStyleSKW]<br alt="" name="" rel="" target="" title="" type="" value="" />&amp; "Save &amp; next tab"<br alt="" name="" rel="" target="" title="" type="" value="" />&amp; [customButtonEnd]<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[3] In the settings for you app, click on Variables and add one called "customButtonScript1". You can use a different name, if you wish, but be sure to use that name in the first like of the rich-text-formula in step [2]. Whatever you call it, the variable should contains the following. The quotes are important. However, remove the spaces in h t t p s, use your company's setting for "yourdomain" and your app's id instead of "yyy999zzz"<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&lt;a href='javascript:($.getScript("h t t p s://yourdomain.quickbase.com/db/yyy999zzz?a=dbpage&amp;pagename=<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[4] Next, in the settings for you app, add a Page called "saveAndNextTab.js" (or another name you prefer, provided you use it in the second line of the rich-text-formula field"). The page should contains exactly this:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />var nextTabLink=$("li.ui-tabs-selected").next("[style!='display:none']").children("a");<br alt="" name="" rel="" target="" title="" type="" value="" />$("#saveAndKeepWorkingMenuOption").click();<br alt="" name="" rel="" target="" title="" type="" value="" />var noErrorDialog=$('#qbDialog').length==0;<br alt="" name="" rel="" target="" title="" type="" value="" />if( noErrorDialog ){<br alt="" name="" rel="" target="" title="" type="" value="" /> $(nextTabLink).click();<br alt="" name="" rel="" target="" title="" type="" value="" /> location.assign('#navTop');<br alt="" name="" rel="" target="" title="" type="" value="" /> };<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />In words, this script is (a) finding the currently selected tab, then the next that is not hidden, and it's name; then (b) clicking the standard "Save &amp; keep working" button, emulating a user; and (c) checking for a pop-up error message, e.g., about failing to supply a required field; and finally (d) clicking the next non-hidden tab-name and scrolling up to where the tab-row will be visible.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[5] Back on your app's settings, add another Variable to close the script. Call it "customButtonScript2" if you are sticking to the naming in step [2]. It must contain exactly this:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />"));void(0);<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[6] Next you need to style the custom button. I prefer doing so as follow, to make it resemble the standard save buttons. Add another Variable in you app's settings called "customButtonStyleSKW" which contains this:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />' class='Vibrant Tall' style='font-size:14px; color:white; background:#6BBD57; white-space:nowrap;'&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[7] Finally, in add one more Variable in your app's settings, called "customButtonEnd", containing simply:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&lt;/a&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Of course, you could just use "&lt;/a&gt;" as the final line of your rich-text-formula field, but I prefer the additional Variable for readability ... and just in case I ever want to make some sort of global change for all my custom button's endings.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />[8] Oh, and to get this button on your forms, add it at the end of every tab. (On the last tab, it will stay there, after not finding any next tab.) Naturally, you will want to use an empty "alternate label" for that row of the form, and set it for add and edit modes only.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />To modify this method for "Save &amp; same tab", the main change is in the first line of the script in step [4]. Use this:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />var sameTabLink=$("li.ui-tabs-selected").children("a");<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Also, later in the script, use:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />$(sameTabLink).click();<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="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question rejected 1 4 2 comment http://m.getsatisfaction.com/topics/7809048 7809048 Batch Update "Display As" Property 2018-11-03T13:17:39Z 2018-10-24T19:21:46Z Nick Wade http://m.getsatisfaction.com/people/9830489 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11338485/NWade_Headshot_medium.jpg nick_wade_ibqvh91vs050b It is my understanding that you cannot use the QuickBase API to change a field's type. However, API_SetFieldProperties has been quite the time saver when working with large groups of similar fields.&nbsp;<br /><br />One thing I haven't been able to do, is find a way to update the "Display As" field property via the QuickBase API. Is there a reason this field is not updatable via the API?<br /><br />Or is the API parameter named as such that it would not be readily apparent?<br /><br />Thanks! question active 5 3 1 comment