Summary report w/multi-select field
Hello, First, thank you in advance for any thoughts and suggestions you might offer here. I would like a report for the average hours worked per technician per week. They record the total time on site in each dated work order record. Thus far, I have created a summary report that summarizes the work time order time by average and it is grouped by week and by the assigned technician in the record. However, this field is a multi-select and there are some records with multiple values as some work orders have multiple assigned technicians. The resulting summary report displays each assignment as a value, meaning the assigned technician(s) rather than searching and filtering for each individual technician, and then averaging each of their hours. I am not sure how best to resolve. I really appreciate your input.5Views0likes1CommentTrying to create a report with an ask users filter, but with a multiselect
There are two relevant tables for this report, 'Parts' and 'Part Requests'. The Parts table is just a list of all available parts with their available stock, and the Part Requests fields include 'Related Part', 'Quantity' and 'Project Number'. I have a request for a report where users can enter the project numbers for the projects they are focused on, and they want to see the quantity on hand from the parts table compared to the sum of the quantity requested in the Part Requests. My problem is I cannot figure out a way to give them a dynamic filter for which project numbers to use. I was hoping if I just did a table report then they could just use the column filters, but they aren't giving the drop down with the option to select multiple project numbers but instead are just giving the single the option to enter a single text string.Solved24Views0likes3CommentsShowing dynamic fields on a report?
My app has a number of dynamic fields that show based on a location field. Everything is working properly. Except, when I just click the eyeball to view the record, I only see the fields that are mandatory on the default report. I know I can open it to see it all, but is there a way to get these additional fields to show? Ideally only fields that are either populated OR the dynamic fields from the actual form that show based on that location. I do see the location as being set on the default report. Can this be done with a report at all? If not the default can I create a new report that will allow me to show these fields and link to it from another report? I have a report on the front page for all new entries and another for new entries that week.52Views0likes5CommentsTable Home Page report
I need to have a report on my home page that has filters but I want to protect it from having users make changes to it. I have the report on the table home page and users utilize the filters available and oftentimes, because they are given the option, will save their changes and in doing so not make it usable for others (because they have filtered out other users/offices data). How can I have the report available to everyone, but not editable?23Views0likes2CommentsReport to Show or Not Show Record
I am trying to create a report that will display records with the following rules. Each record has a date field (30DayReview). The record also has an "Approved" Checkbox and a formula checkbox that is checked only if a document is uploaded to a File attachement field. Currently the record shows in the report When the Approved checkbox is checked. When a document is uploaded to the attachment field, the formula checkbox field becomes checked and is dropped from the report. This is working. I would like to add the option to over ride the current rules with one rule saying that if the "30DayReview" field is older than 70 days in the past simply drop the record from the report regardless if the other rules are true. Here is where I am at: On my Test record the "30DayReview" Date field is set to 06-01-2024 12:00AM well outside of the 70 days in the past. The Approved checkbox is checked. The Formula checkbox field is unchecked. Wondering why my record is still showing in the report.11Views0likes1CommentLimit the number of displayed rows in reports when editable on the form
I'd like to limit the number of rows displayed on a report to only rows where data already exists. I have several forms where a report is editable whenever displayed on a form in edit mode. The risk is that users can type in those rows. I've done scenario testing and I can see how a user could create some problems that will actually get them locked into a no win scenario where they are in conflict with form rules and unable to remove the extra rows created while unable to proceed. It's particularly true if one of the fields is a required field. Obviously orphans can occur if they have to close the browser. Below is a screenshot of an example where the report renders 3 rows but shows 4 additional rows. Is there a way to limit editable rows to only those already containing data when rendered?66Views0likes2CommentsReport to Search for text in a Text Field?
I am wondering if it is possible to create a report that asks the user for a value to be found in a multiline text field. For instance, when I click to generate the report a field will display asking what you would like to search for. If I entered the value "Jason", it would search all records that have the word "Jason" in a particular text field. Is this possible? Brian39Views0likes2CommentsHide "Full Report" and other report options
I have a read only report displayed in several places where IForms is used to supports user access to just what they need. Unfortunately, at the top of all reports there's a remaining set of links I can't seem to hide. Full report is at the left and you see in the screenshot there are others. I looked for any content on the subject but it seems to be years old and I don't believe the question has been posed recently. Is there yet a way to display a report suppress these features?11Views0likes0CommentsCan subscription reports be sent to multiple recipients in same message
I'm finding that when I select a group of users to receive a report subscription, the email is sent separately to each recipient. This is not terribly useful for management reports. I would like the group of recipients to be included on the message together, so that users can "reply-all" and discuss, ask questions of the data in the report. Is there a way to accomplish this in subscription settings? Thanks, Mike30Views0likes2Comments