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.29Views2likes62CommentsURL 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.23Views0likes19CommentsReordering 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!22Views0likes7CommentsIs 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 ------------------------------18Views0likes5CommentsIs there a way to show null values in a Summary Report
I am trying to create a Summary Report that summarizes the number of items as a normal value, and I am grouping the columns by item creation date, combined by month. The table generates as expected. The column headers for the table show January, February, March, April, etc. in correct date sequence, and shows the correct count for the number of items associated to each month. I have one problem. If the item count for a month is zero, I want to show it as zero.For my table, the months of April and November have zero items, but the table does not show those two months as column headers, with a value of zero. Is there a way to do this?17Views1like5CommentsSorting 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 ------------------------------15Views0likes3Comments