Topics in Quick Base 1970-01-01T00:00:00Z 10444 10437 0 0 0 94 7559644 Fields Not Showing When Viewing A Form 2017-07-22T00:14:12Z 2017-07-21T18:00:04Z Josh Collins josh_collins_4jbpwmkzjcsrw Hello,<br /><br />I have several fields that I can see when I Add or Edit a form, but they do not show up when I View the form. &nbsp;I checked the field's settings on the Customize This Form --&gt; Elements tab and found that all of the fields are set to be visible for Add/Edit/View. &nbsp;But they definitely do not show up in "View" mode.<br /><br />Here are some screen shots to show you what I'm dealing with. &nbsp;This is probably an easy fix that I'm just not aware of, so any advice you can provide will be greatly appreciated.<br /><br />Thanks!<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1624780/RackMultipart20170721-24984-hyitp0-PresPro_Web_App_-_Edit_Project__15_inlinepng1500659932" /><br /><br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1624782/RackMultipart20170721-25548-7jim1g-PresPro_Web_App_-_Project__15_inlinepng1500659980" /><br /><br /><br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1624781/RackMultipart20170721-80524-19pr7xc-PresPro_Web_App_-_Projects_Main_Form_inlinepng1500659954" /> question 1 2 1 comment 7559637 Date Reference Proxy fields 2017-07-22T00:12:14Z 2017-07-21T17:49:29Z Angel as111 What I am trying to achieve?<br /><br />I have 2 tables.<br /><br />Expense Table which has a field for Expense Date (of type Date)<br />We are managing our expenses by the fiscal calendar. I have a separate table (Fiscal date table) that maps the cal date to the fiscal month/quarter/year.<br /><br />On the Expense table form, when I select the expense date I want to be able to see fiscal month/quarter associated with it.<br /><br />I cannot directly use the calendar date(from the Fiscal date table) on the form because that shows up as proxy field and doesn't open up in a calendar format.<br /><br />Any suggestions ??<br /><br />Appreciate the help. &nbsp; question 4 2 1 comment 7558917 Field names and labels on Reports and Forms in QB Library Apps not consistent: 2017-07-21T21:57:12Z 2017-07-20T16:27:14Z Dona Sheehan dona_sheehan I understand that QB does not police or support apps. available in the Library built by customers, but is there Help/Corrections for QB authored apps ? Very frustrating ... seems QB applications should be the best example of what can be done and QB should stand behind apps they make available. This is a recurring problem: here's an example"<br /><br />Downloaded QB 's Project Manager Plus.<br />Between Reports and Forms, fields are not consistent. &nbsp;<br />Examples:<br /><br />"Project Lead" is really a USER but the dropdown is &lt;Add a New Resource&gt; and it doesn't work.<br /><br />The "Contacts" drop down displays a list of "Companies' of "Contacts", not of &nbsp;"Contacts" &nbsp;and again, the &lt;add a new contact&gt; function does not work. &nbsp; question 2 2 1 comment 7559119 Multiple Children from a parent using Formula URL 2017-07-21T20:10:29Z 2017-07-20T21:18:08Z Clayton Rountree clayton_rountree I have 5 tables, and am confused trying to properly connect them. This comes from a modification of:&nbsp;<a href="" rel="nofollow" target="_blank" title="Link http//wwwquickbasecom/quickbase-blog/how-to-quickly-create-multiple-child-records-in-quickbase_ga24993891819211689331500059934-10567127751499364654"></a>&nbsp;<br /><br />I have a Estimates Table from which I want to create 34 children records on Estimate Details Table. I have created a Estimate Details Template table to hold the 34 team names that correspond to each estimate. (For each project, 34 teams need to assess the impact on their team). &nbsp;Finally, there is a Project Table, and the Bridge table (see also Focus Tasks Table from link).&nbsp;<br /><br />So 1 project has many estimates. 1 estimate has many estimate details. There are only 34 templates, and only 1 bridge. I have a formula URL button on the estimates table that does a RunImport of the 34 templates to the Estimate Details table.<br /><br />BOTTOM LINE: The 34 records created on Estimate Details Table by the button do not autofill with the corresponding project/estimate data from the Estimate Table (such as Project ID, Project Description, etc.). I need them connected. &nbsp;Please help! question 7 3 1 comment 7559676 I really need to utilize the new Connection service to MS Exchange 2017-07-21T19:46:34Z 2017-07-21T18:59:14Z Scott Grund scott_grund I really need to utilize the new Connection service to MS Exchange so that we can store emails relating to records within our applications. We do not use 365 and I need to find out where I can discover the name of our Exchange server and how to see what port it is using. I will probably have to go to our 3rd party IT guys but I don't even know what to ask them. question 2 2 1 comment 7559300 Use URL function to do two different things 2017-07-21T19:03:36Z 2017-07-21T04:11:47Z Signature signature_47ea6gcaf26ic I'm trying to create a URL formula to open Skype with a command as well as edit a multi line Text field and then save the record...<br /><br /><br />//Formula 1<br /><br />"skype:" &amp; Mid([Phone 1],2,3) &amp; Mid([Phone 1],7,3) &amp; Mid([Phone 1],11,4)<br /><br /><br /><br /><br />//Formula 2<br /><br />URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord"<br />&amp; "&amp;rid=" &amp; URLEncode([Record ID#])<br />&amp; "&amp;_fid_104=Called Client on home phone"<br />&amp; "&amp;apptoken=XXX" &nbsp; &nbsp;<br />&amp; "&amp;rdr=" &amp;<br />URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid="<br />&amp; URLEncode([Record ID#])) question 4 4 1 comment 7559666 URL formula that initiates a phone call from a mobile device 2017-07-21T18:41:14Z 2017-07-21T18:29:10Z Signature signature_47ea6gcaf26ic Is there a way to have a URL formula initiate a phone call using data in a Phone Number field from a mobile device? question 3 2 1 comment 7559639 Hide Key Record Field from Top of Form 2017-07-21T18:22:22Z 2017-07-21T17:51:02Z Anthony Guillen anthony_guillen When printing a form (not exact), the printout always shows the record number at the top of form. &nbsp;I kept the record ID# as the key field, as everyone advises, but there is a separate unique ID number (an alphanumeric work order #) for each record. Having the record ID# at the top confuses people. &nbsp;How can I keep this from printing? &nbsp;It's not one of the form elements, and I tried unselecting the header/footer box to no effect.<br /><br />I've attached a screen shot. &nbsp;Circled in red is the record ID (key), and the alphanumeric #. &nbsp;It's not just the field label that's confusing - I can change that, it's that having two record numbers at the top of the form confuses people. I also know I can make my alpanumeric field the key field, but as people have advised, it's really best to leave the key field alone, and at this point, there's so many table relationships to the key field that I am loathe to change it.&nbsp;<img src="" title="Image:" /> question 3 3 1 comment 7558321 Get data from multiple tables 2017-07-21T18:16:30Z 2017-07-19T18:25:49Z chetan patil chetan_patil I am creating the report to extract the data from multiple tables. Now i just need the data from a &nbsp;table which i am not able to figure out.<br />I have 4 tables Order, Shipping, transactions and numbers<br />relation is&nbsp;<br />order &lt; shipping &lt; transactions &gt; numbers &nbsp;(1 order has many shipping ,&nbsp;1&nbsp;shipping&nbsp;has many&nbsp;transactions, 1 number has many transactions)<br /><br />i want to get the related data from numbers in order table&nbsp;<br />how can i do it? question 5 3 1 comment 7559558 Creating a table based upon location relationships 2017-07-21T18:06:37Z 2017-07-21T15:43:51Z Patrick Griffin patrick_griffin_7n04tjm1lkm I am having trouble trying to group rows based upon a table relationship. As of right now i have two tables. Table 1 with specific locations, and Table 2 with rows that i want to be assigned to the locations listed in Table 1. I want to know if its possible to assign the table 2 rows to table 1 based upon the location of the rows in table 2.<br /><br />For instance if a row in table 2 is within 10 miles of a location in table 1, it would be assigned to that location. I would also want to allow the rows of table 2 to be assigned to multiple locations in table 1 in case of any overlap. Both tables have complete address fields that have been recognized and found via google maps.<br /><br />Can this be done? and if so how? question 3 3 1 comment 7559650 It is possible to import all fields and notification settings from a table in one app to another? 2017-07-21T18:06:28Z 2017-07-21T18:06:28Z Jessica jessica_hwf08ct8s4vfr We were doing some functionality testing in a copy of our current app and built out a ton of fields, forms, notifications, and reports. Now we want to merge all of that functionality with our up to date app. Is there a good way to import or upload all of that functionality?&nbsp; question 0 1 1 create 7440722 Auto generated numbers 2017-07-21T17:46:15Z 2016-04-15T18:36:27Z Jeff jeff_frhi90fv3jzoa <p>I'm looking to create an auto-generate sequential number....without using the Record ID #. We are almost 3 years into Quickbase using a table that had no record number. Now we want one and I can't start with 4,356, it needs to start with 1. Is there a way to have an auto-generated number without linking it to the Record ID#?<br /></p> question complete 3 3 1 comment record id, table, record id#, record 7434088 Empty left column in embedded report in exact form 2017-07-21T16:41:18Z 2013-02-21T21:04:33Z qbadmirer qbadmirer <span>How to remove first column (edit / view) for embedded report in exact form. I am using this ~=qdb.GetURL("bhjz7apud", "API_GenResultsTable^query={'13'.EX.'"+field["Record ID#"]+"'}^clist=^opts=nos.ned.nvw.");~ for embedding the report. But my problem is one empty column is appearing on left side.<br /><br />Please help</span> question complete 5 3 2 comment report, column, exact form, embedded report, form 7558995 Average of days task was open 2017-07-21T16:32:55Z 2017-07-20T18:12:35Z frumy horowicz frumy_horowicz I have a situation where I have two tables, <br /><br />1- tasks<br />2- vendors<br /><br /><br />There is a one to many relationship where each vendor may have many task. <br />In the tasks form I have a field that calculates&nbsp;days it took to complete that task. (numeric) how do I pull that information into the vendors report, so that an average of how long it took the vendor to complete his assigned tasks will appear. question 1 2 1 comment 7557625 Using image onload field in a report leads to the repeated execution of the javascript and thereby leads to incorrect output 2017-07-21T12:54:36Z 2017-07-18T18:39:30Z Sauda Furkhana sauda_furkhana Using image onload field in a report leads to the repeated execution of the javascript and thereby leads to incorrect output question 7 5 2 comment