Remove totals column from summary report
I have a summary report that I use to summarize information by week. I would like to only display the previous 4 weeks, but when I do this the "Totals" column just shows those 4 weeks for totals which is confusing based on what is displaying for other reports on the dashboard. I know that you can remove the totals row. Is there a way to remove the totals column in a summary report?33Views2likes11CommentsHow to display PDF in file attachment fields
File attachment fields can show the attached files in forms and reports, but only a few file types are accepted (jpeg and such). Is there a way around this so that PDF attachments can be shown either directly in the form, or as a pop up window (I believe that is called an Iframe ?) after clicking on some button for that purpose? I now have that sort of working through a Chrome extension, which opens the PDF in another tab, but it's slow and cumbersome and has some unwanted side effects.27Views2likes62CommentsReordering fields (columns) in table
Hi! Is there a way to reorder fields (columns) in a table? I've seen the drag and move feature (dragging a column and moving it to the right spot) but somehow it doesn't work on my end....I tried changing the order of fields in the form but then the new order only shows in the form and not in the table. Right now I've just been deleting fields and re-entering them in the right order, please tell me there is another way!! Thank you!22Views0likes7CommentsURL formula to edit a record and ""refresh the page
I regularly use little API URL formula buttons like this one. var text $CopyStatustoPreviousStatus = blah blah blah ......; $CopyStatustoPreviousStatus & "&rdr=" & URLEncode($ReDisplayReport) That works well when I have a button dedicated to either refreshing the record I am sitting on or refreshing a particular report. I also use this great technique a lot to not refresh the report (so the user does not lose their place in the report or does not lose their Dynamic filter selections. var text URL= blah blah blah ....; "javascript:" & "$.get('" & $URL & "',function(){" & "$.jGrowl('email Triggered to Prospect', {life: 5000});" & "});" & "void(0);" But I would love to know how to make a button which will do some blah blah blah stuff and then refresh the screen - that way I could have the same button be used on any report and any record. Ideally it would reload the screen and preserve the user's Dynamic filter selections if they were on a report. If there a way to modify the code above to incorprate this concept &"javascript:location.reload(true);" and not do the growl pop up. ie I'm looking for a button to be able to execute a URL formula which would say edit a record and then refresh whatever screen the user is on. In that situation with a refresh, typically the user's feedback that the button click "took" will be that the report refreshed or the record refreshed, so we don't need or want that jgrowl pop up.21Views0likes19CommentsIs it possible to populate fields in one table with data from fields of another table?
Before I start trying and make a mess I wanted to ask.... Here is my situation: I have a tasks table and a weekly agenda table. Employees would like to be able to click a button on a task and move it to the Weekly Agenda table and maybe add more data once in the weekly agenda area. (They want it to Rather than having a relationship with reports links, etc... I would like employees to be able to click the button and have the relevant information auto-populate on the new form... I know this can be done within a table, but I dont know if it is possible to do ACROSS tables... Any suggestions?20Views0likes17CommentsColumn width on report automatically expanding
As of this morning: When I open a table report, the column widths are automatically expanding? I need my column widths to stay as I set them (narrow)..we do screen shots and don't want wide columns. On a Mac desktop, using Chrome... Thank you ------------------------------ BuildPro ------------------------------18Views0likes7CommentsReport Formula: Sum total
Hi, I have two columns Erect Hours and Total Pieces Erect. This is what I want to get at using report formula; (Sum of Total Erect Hours * 60) / Sum of Total Pieces Erect. (64102.36*60)/352507.5 = 10.91 I tried using this Sum([Build - Erect Hours])*60/Sum([Build - Total Pieces Erect]).However, it is not calculating the column total but it is calculating row total. Any help will be appreciated. ------------------------------ Bibhav Rimal ------------------------------17Views0likes5CommentsSorting a Summary Report
I have a summary report showing calls made by date. Its summarized by date. I am using the system create date as the grouping date. The report sorts in asending order by default. I am trying to get it to sort by desending order so the latest date is on the top. How can this be done?16Views1like10CommentsTranslate a Summary Report into a table "Summary Table"
I would like to know if there is a way to automatically transfer data from a Summary Report to a table that I would possibly call "Quota (Summary Table)". I know that there is an option to export the Summary Report to a CSV file and then I can import it into my Summary Table but I would like to know if there's a way to automate that or make the transition easier. I need the information to make a table that will help plan for the following day. The Quota (Summary Table) will provide an update of how many tons is left over on each site location (ramp) so that I can adjust the amount of trucks reporting to the site the next day based on total tons at the site location. ------------------------------ Yobani Maldonado ------------------------------15Views0likes3CommentsCount Distinct
I need to create a report that has a distinct count (not just a count.) I have run into this problem many times and I have never found a good way to deal with it. So, I?m hoping there is some easy solution I?m missing. I?ll give my specific example for context. My app records activities by resource specialists who provide assistance to patients. There is a patient table that is joined with an activities table (one patient can be associated with many activities.) The manager wants to assess the workload of her resource specialists. It is easy enough to count the activities by resource specialists or even the patient IDs linked to the activities, but the manager wants to answer the simple question about how many UNIQUE patients were helped. I can group by the patient ID, but we are talking about very large numbers that bog down the report and makes it unusable. It also is not really the correct way to look at this. A calculated column that counts patients is the same as the counting the record. I need something like the SQL function ?COUNT (DISTINCT ... ? In searching through this forum I found some people having similar issues and a reference to an underscore.js function HERE, but I?m looking for the most straightforward way to do this seemingly straightforward request. Thanks!14Views2likes6Comments