http://m.getsatisfaction.com/companies/quickbase/topics?page=1 Topics in Quick Base 1970-01-01T00:00:00Z 12804 12688 0 0 0 354 http://m.getsatisfaction.com/topics/7778196 7778196 Use API to delete entire file attachment history 2018-08-15T11:57:07Z 2018-08-15T08:07:40Z Steffen http://m.getsatisfaction.com/people/9757245 https://www.gravatar.com/avatar/c3fe11069d7c0f511e4f6694d5c2e1ae?d=identicon&s=55&r=PG steffen_skaarup This question is a follow-up to:&nbsp;<a alt="" href="https://community.quickbase.com/quickbase/topics/delete-file-attachment-with-api-editrecord" name="" rel="nofollow" target="" title="Link httpscommunityquickbasecomquickbasetopicsdelete-file-attachment-with-api-editrecord" type="" value="">https://community.quickbase.com/quickbase/topics/delete-file-attachment-with-api-editrecord</a>. It concerns the use of API_EditRecord to delete attached files from <br alt="" name="" rel="" target="" title="" type="" value="" />records. Inspired by the final answer to the aforementioned question, I have been sending out requests with these parameters:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&lt;rid&gt;[rid]&lt;/rid&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&lt;field fid="18" filename="delete"&gt;&lt;/field&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&lt;field fid="24" filename="delete"&gt;&lt;/field&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />This works perfectly well, except for not actually deleting any files. What I get are empty fields whose revision histories now have "(deleted by user)" at the top, with all previous revisions still available and taking up space.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Is there really no way of actually deleting file attachments through the API? While I would prefer a nuke-all option of removing the entire history at once, I'm also open to doing it revision by revision. I looked at the API reference and couldn't find anything, so I'm nervous that this is just not possible, but I thought I'd ask just to be safe.<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 3 2 1 comment http://m.getsatisfaction.com/topics/7777578 7777578 Another Custom Auto-Generated Number Request 2018-08-15T02:34:46Z 2018-08-14T05:23:46Z FLSI-Drew http://m.getsatisfaction.com/people/9755835 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11310958/circle-logo-stamp_REV02-color_medium.png drew_ramos Hello, really liking this platform a lot and we're currently stuck between this an Zoho One, on Zoho it's extremely easy to accomplish what I'm trying to accomplish, but on here it's a bit more extensive I feel. Anyways, we use a format for our quotes(F18109) and jobs (18172-20DR) based on what department creates the quote and/or job. I've read a few other threads and tried to use their formulas but haven't had much luck getting what I', looking for.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />So for Fabrication -<br alt="" name="" rel="" target="" title="" type="" value="" />1. Quotes are: F-YEAR-AUTO GENERATED 3 DIGIT NUMBER or F18109<br alt="" name="" rel="" target="" title="" type="" value="" />2. Jobs are: YEAR-AUTO GENERATED 3 DIGIT NUMBER-DEPARTMENT ID-ESTIMATOR or 18172-20DR<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />And for Construction -&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />1. Quotes are: B-YEAR-AUTO GENERATED 3 DIGIT NUMBER or B18111<br alt="" name="" rel="" target="" title="" type="" value="" />2. Jobs are:&nbsp;<b alt="" name="" rel="" target="" title="" type="" value=""></b>YEAR-AUTO GENERATED 3 DIGIT NUMBER-DEPARTMENT ID-ESTIMATOR or 18172-10PR<br /><br />We're thinking, if this system can auto-gen our numbers, we may just do away with the two separate quote number variations, but keep the dept. ID's for the jobs the same, however that's at another time.&nbsp;<br /><br />Any help would be greatly appreciated, and I do really enjoy this software!<b alt="" name="" rel="" target="" title="" type="" value=""></b> question active 2 2 1 comment http://m.getsatisfaction.com/topics/7750835 7750835 Populating form fields with DoQuery results 2018-08-15T02:00:04Z 2018-06-15T20:09:42Z Patrick Dunn http://m.getsatisfaction.com/people/9696138 https://www.gravatar.com/avatar/ac56c0e92119f1155d6bb4e914203a67?d=identicon&s=55&r=PG patrick_dunn_9u559zaurx0tk Hello. Apologies if I've missed a similar conversation. Within a form, I'd like a user to be able to fill in some fundamental data, then click a button and have a field within that form populated with a value returned from a DoQuery call that would reference those fundamental inputs. Note: the value to be populated would not be attainable via table to table relationships.<br />I've only recently started working with formula URL buttons and the API, and I'm struggling to get the two to work in tandem. <br /><br />Any guidance would be much appreciated.<br />Thanks question active 6 3 1 comment http://m.getsatisfaction.com/topics/7778055 7778055 call native quickbase richtext field iol 2018-08-14T23:31:26Z 2018-08-14T23:31:26Z Nilesh Patel http://m.getsatisfaction.com/people/9003508 https://www.gravatar.com/avatar/dbfc4173acc3a703979ab70877db041b?d=identicon&s=55&r=PG nilesh_patel_85tt5ovxjeld7 How can i load the native quickbase richtext field using iol.&nbsp; I currently have a button which will pop up a html form.&nbsp; In the form i want to use rich text instead of text field. I want the option for our users to be able to use bullet points and such. question 0 1 1 create http://m.getsatisfaction.com/topics/7777957 7777957 Allow Both Record Picker And Manual Entry For Relationship Reference Field 2018-08-14T22:35:40Z 2018-08-14T19:50:25Z Jonathan Klein http://m.getsatisfaction.com/people/9657213 https://www.gravatar.com/avatar/ddc861bd2022b483a22bfdd8ce997299?d=identicon&s=55&r=PG jonathan_klein_bqsd8ij03xofl I have a form with a reference field that opens up a record picker (search/selection) box.&nbsp; However users want to be able to simply manually enter a value without having to go through the process of opening a dialog box, searching for that value, and then selecting it.&nbsp;&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />That search/select feature should still be available for those who are not sure of which value to enter, but those who do know would like to be able to essentially skip those steps and simply enter in the value into the box.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Is there some way to accomplish this?&nbsp; Normal multiple-choice dropdown lists have this capability (where you can just type and it auto-fills a valid value as you type), but I cannot seem to find something similar for a reference field. I've tried using the "Use a record picker instead of a drop down menu" property, but it behaves as a record picker regardless of that setting (probably because there are so many records).<br alt="" name="" rel="" target="" title="" type="" value="" /> question active 5 3 2 comment http://m.getsatisfaction.com/topics/7517103 7517103 CopyMasterDetailDetailButton Redirect to Record Form in Edit mode 2018-08-14T21:11:38Z 2017-05-11T18:53:34Z rocketc http://m.getsatisfaction.com/people/3738005 https://www.gravatar.com/avatar/f5ac5f798039d6243d24741375c3cb78?d=identicon&s=55&r=PG rocketc When I click the "CopyMasterDetailDetailButton" -- the detail records are copied -- then a Pop-Up appears - stating that the records where created and the Pop-up has a Button on it "Go To Record" --- Is it possible to have the "Go To Record" button --- redirect me to the record in Edit mode --- not View mode--&nbsp; question active 6 5 1 comment http://m.getsatisfaction.com/topics/7773237 7773237 How to add a N/A checkbox for a Date field 2018-08-14T20:26:21Z 2018-08-03T17:17:47Z Iris Bonilla http://m.getsatisfaction.com/people/9713810 https://www.gravatar.com/avatar/f7177e8f357fb322e571be04828f2a40?d=identicon&s=55&r=PG iris_bonilla <p alt="" name="" rel="" target="" title="" type="" value="">Hello!</p><p alt="" name="" rel="" target="" title="" type="" value="">I have a table with multiple date fields, but a lot of times my users don't have those dates yet, and I would like them to have the N/A option. Is there a way to add a checkbox next to the date field that says "N/A" and if they click it then the input for the field should be N/A.</p><p alt="" name="" rel="" target="" title="" type="" value="">I don't want this to be a separate field, because I need it to have a N/A input for a monthly report.</p><p alt="" name="" rel="" target="" title="" type="" value="">Any help would be great!</p><p alt="" name="" rel="" target="" title="" type="" value="">Thank you!</p><br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 1 2 1 comment http://m.getsatisfaction.com/topics/7776317 7776317 Need to bulk upload CSV or PDf into multiple fields across multiple tables 2018-08-14T20:13:48Z 2018-08-10T16:20:39Z David Brogdon http://m.getsatisfaction.com/people/9753260 https://www.gravatar.com/avatar/22425dca882b019eb7bc343dc9c503a5?d=identicon&s=55&r=PG david_brogdon I have been hired by a company to improve their data entry process and I am looking for a way to pull data from customers' order sheets directly into Quickbase and have different parts of the form (data) go to different tables. Is this possible? If so, how would I go about implementing a mass upload of data from customer orders? Thanks question active 1 2 1 comment http://m.getsatisfaction.com/topics/7437185 7437185 How do I do a mass download of all files? 2018-08-14T19:57:03Z 2014-06-03T21:15:29Z CAFC http://m.getsatisfaction.com/people/8809780 https://www.gravatar.com/avatar/e9aa51c6c5afb5c74f47de74d294ca9e?d=identicon&s=55&r=PG cafc <p>We allow people to upload documents into QB, how do i download the documents in a mass download?<br /></p> question complete 8 6 1 comment relationships, forms, permissions, download, access, file attachment, table, form http://m.getsatisfaction.com/topics/7777522 7777522 Website interaction and access to Quick Base 2018-08-14T19:54:42Z 2018-08-14T02:15:09Z Erika H http://m.getsatisfaction.com/people/9755746 https://www.gravatar.com/avatar/37abd183ab041bd9cb584c4d1505e60c?d=identicon&s=55&r=PG erika_herrera I am wondering if there is an easy way to go from a website to the QuickBase for people to fill out a form. Also, I would like for the people to just be able to access and save the form with out become users. Is this possible? question active 1 3 1 comment http://m.getsatisfaction.com/topics/7455330 7455330 Can you send text messages via a notification 2018-08-14T19:39:09Z 2017-02-14T22:03:18Z Joey Zint http://m.getsatisfaction.com/people/3644943 https://www.gravatar.com/avatar/444a67ce11b0d8507557474d75064b09?d=identicon&s=55&r=PG joey_zint Is there a way to send text messages to a mobile phone via a system notification question complete 5 6 1 comment http://m.getsatisfaction.com/topics/7777821 7777821 Automate Checkbox Field 2018-08-14T17:24:28Z 2018-08-14T16:12:53Z sheree brown http://m.getsatisfaction.com/people/9682756 https://www.gravatar.com/avatar/ec6853c56a25d4d7237c74cb3ed505d2?d=identicon&s=55&r=PG sheree_brown_9pi313bwzgdio I am trying to place a check in checkbox field [Tests Scheduled] when 3 of 3 date fields have been populated: [MRI date], [CT date] and [Endo date]. I have tried actions and automations. I don't want form rules because these dates are entered in grid edit mode. I think a checkbox formula field will work, but&nbsp;I 'm not sure how to write the formula. Help please!&nbsp; I don't have any training in formulas, I have looked at numerous posts for possible answers without finding an answer.&nbsp; question complete 2 2 1 comment http://m.getsatisfaction.com/topics/7777741 7777741 Formula checkbox needs to uncheck when conditions change 2018-08-14T17:07:28Z 2018-08-14T13:40:10Z Stephanie http://m.getsatisfaction.com/people/8807592 https://www.gravatar.com/avatar/d2d7df009670a7c7268d7142f51e8ad7?d=identicon&s=55&r=PG stephanie_f52ckr5qtisgt I have a formula checkbox that says <br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp;&nbsp;&nbsp;&nbsp; If(([Related Department or Group] = 13) and Contains(ToText([Tools]), "MVR") true,false)<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />This works fine until [Tools] changes from "MVR" to ""<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />What happens is, an anonymous user submits a request. They are in [Related Department or Group]&nbsp; 13, They select "MVR" and "Service Metrics" in [Tools]. They save the request. My formula checkbox checks because "MVR" was selected. That is correct.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />The Admin gets the request and decides the users does not need "MVR" so they remove it. But my formula checkbox does not uncheck. I need it to uncheck. How do I fix this?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 6 4 1 comment http://m.getsatisfaction.com/topics/7776713 7776713 Looking for simplest example to access quickbase using python 2018-08-14T16:34:53Z 2018-08-11T17:02:00Z krishnan chittur http://m.getsatisfaction.com/people/9754251 https://www.gravatar.com/avatar/402b3eb3c7d84af300b616efb3aea398?d=identicon&s=55&r=PG krishnan_chittur Can someone point me to examples that show how a quickbase/db can be accessed from the command line/using python -?&nbsp; We would like to access, add, delete, change records and create reports - and in addition to the GUI provided, do such using CLI tools and python (saw pybase on github, am having some difficulty with it - unless someone can provide a complete example -?) question active 1 2 1 comment http://m.getsatisfaction.com/topics/7617295 7617295 Lat/Long 2018-08-14T16:21:15Z 2017-10-23T14:47:38Z Mike http://m.getsatisfaction.com/people/8968753 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11092708/12743804_10207746789963747_2087499882425493244_n_medium.jpg michael_porche I need to build a Heat Map for our executive team displaying saturation of certain geographically defined areas.&nbsp; Sadly, QB doesn't allow for a heat map organically, and most tools require the use of Lat/Long in order to render correctly.<br />Does anyone know of a formula that would convert the organic "Address" field into a Lat/Long?<br />Thanks,<br /><br />Mike question active 13 6 1 comment