26 results found
-
Include Files that have been uploaded to records with new Data Extraction API
I learned recently that files that have been uploaded to records via file upload custom fields can not be extracted using the new Data Extraction API. I can see clients wanting these files included when extracting records into other business insight tools, AI or otherwise.
3 votesBased on client demand, we are interested in exploring support for accessing uploaded documents via the Data Extraction API
-
Strip HTML from Rich Text Fields on List View or Report Export
When exporting a reporting that includes rich text fields, the export includes unrendered HTML. This HTML then needs to be stripped out to make the content of the report readable.
Suggest to add an option on the report and list view export to strip html from the export. Include a tooltip to advise that this will impact formatting.
34 votes -
Improvement to the API services
The current API services offered by SmartSimple are confusing in the response our team receives when calling them. For example:
- If there are missing variables in the call, it will respond a 200 - OK in almost all circumtances.
- If there is an incorrect variable (for example, report instead of reportid), the API will reply a 401 error in the body of the response - which indicates the user does not have authorization to that report, when the error is that the variable was incorrectly parsed in the URL.As our system becomes more connected with other platforms,…
15 votes -
data lake
It would be very useful to have a separate reporting database or the ability to replicate the database for reporting purposes.
For us this could be useful to have a data lake that could be used externally like with Power BI. We currently run many very complex reports using SmartConnect API's against our live instance (because they are too complex for the built-in reports).
This can cause major slowdowns in the live system with some of our more intense reports.There was a suggestion regarding AI insights where John Fulton suggested a data lake. It would be great if we…
12 votes -
Fix the Advanced Search feature
Fix the Advanced Search feature with the following improvements:
- open the search in a modal window so we can see all the criteria in the search
- provide functionality to change the order of criteria
- Include previously used queries dropdown (either customizable or most recent X queries)
- return the closing parenthesis
- add a "power user" option for people to include their own SQL queries18 votesMonitoring Interest ·
AdminJohn Fulton
(Director of Product Management, SmartSimple, Foundant Technologies)
responded
Good usability suggestions, the only item not under consideration is the last one with the ability to leverage a user's SQL
-
Ability to report/extract/import description field in uploaded files
Currently, descriptions for uploaded files can be added. It will be helpful to be able to report on each uploaded files, with their description and upload date/time, and user. It will be helpful for staff/reviewers to be able to have a list of files that were uploaded, with the description at hand, as filenames may not be as descriptive.
Also, since file upload is available thru autoloader, it will nice to be able to add descriptions of files when uploaded thru autoloader.6 votes -
Allow reports to have a direct URL
Enable users to link directly to a report when it has been created. This would be incredibly helpful when working collaboratively. Currently we have to describe which folder the report is in and provide a unique ID so they know which report to access. It would be so much easier to send a direct link to the report.
4 votesGood suggestion, we will monitor this, but also link it to the report enhancements for discussion during the report builder workshops to evaluate priority and impact
-
Add option to display data as percentages on charts.
Currently, we only have the option to display data on charts as counted totals. We would like to be able to display data as percentages on these charts for evaluation purposes.
15 votes -
Centralized Logging and Improved Visibility for Configuration Errors
Problem: Logs related to configuration and system behavior are currently fragmented across multiple locations, making troubleshooting slow and inefficient. There is no clear centralized view or consistent process to identify high-impact issues, and important configuration errors are often buried as generic warnings.
Key Gaps:
No single, centralized location for all relevant logs
Configuration-related errors are hard to discover and correlate
Log severity levels are not granular enough, causing critical issues to appear as low-priority warnings
Lack of guidance on whether customers should rely on platform logging or develop internal processesRequested Improvements
Centralized Log Access
Provide a single, unified location…5 votes -
Data Extraction API - Metadata endpoint that returns the schema definition of each entity type
Provide a schema discovery endpoint that allows clients to programmatically retrieve resource metadata, enabling automated data pipelines without requiring manual field mapping.
At minimum:
- Field id
- Field name
- Display label
- Field type
- Description
- List of possible values when Enum
- Created date
- Last modified date
In the iterated version of this, it would be good to have metadata on the UTA types (L1, L2, L3) and relationships between entities.
1 vote -
Data Extraction API - Inclusion of data from all field types (and particularly data tables)
Currently data captured through fields such as Basic and Advanced Data Tables is not included in the responses returned by the Data Extraction API.
It would be ideal to have them included and formatted as a json or xml.
In general, I think it would make sense that all collected data is made accessible through the Data Extraction API.1 vote -
Scheduled Export to multiple people in the same thread
When using the scheduled export report option I can add multiple users to the export but they all receive separate emails and are not aware of who received it. Support recommended we create a distribution list and use that but unfortunately that is not an option for us.
3 votes -
Add resolved status to annotations dataset
Would be really useful to be able to report on whether or not annotations are resolved, as then you could use the report property to create SmartCheck validations and/or have fields display conditionally based on if there are any unresolved annotations or not.
3 votesMonitoring Interest ·
AdminJohn Fulton
(Director of Product Management, SmartSimple, Foundant Technologies)
responded
We see the bigger opportunity is to easily validate against unresolved annotations and will consider this in the future.
-
Batch update to update legislative districts
We use Legislative Districts on our Organization Profiles to track giving by district. Currently, this requires manually updating each organization by clicking the Legislative Lookup button next to the address and then saving the draft to populate the fields. The ability to batch update this information would be extremely helpful—especially after redistricting, which occurs every few years.
2 votes -
Inherit UTA permissions for report administrators
Certain UTAs contain personal data that should only be visible to the user themselves. Policy field sets allow us to cope with that through the front end but adminsitrators / report authors can still report out that data and we need to stop that happenning. Perhaps the UTA security or policy field set rules can apply to the report module.
1 voteMonitoring Interest ·
AdminJohn Fulton
(Director of Product Management, SmartSimple, Foundant Technologies)
responded
We intentionally separate user views and reports to give customers who more control. Reports are not intended for all users. We will monitor interest as a new report builder would most likely be required.
-
Version is reports
When a UTA is using SmartVersioning, I would like to be able to add the @version@ information in reports (similar to what you can do in list views)
8 votes -
Fix the left hand column in report builder
Fix the left hand column in the report builder which tells you which row is the dataset, field, field ID etc. so if you add multiple columns and have to scroll to the right, you can still see what each row is for
8 votes -
Tracking processing times via status report
(Re ticket #277463 - Tracking processing times)
We have been asked to report on the length of time in review for monitoring the workload and efficacy of our staff.
We have created a status duration report but it will not calculate the length of time in the current grant status. Yet, when we click on the status history for an individual file, it lists the length of time in each grant status including the current status.
We basically want the numbers listed on the graph in the individual status history but in a table with all the other files.
2 votes -
Allow impact maps to run off of grant record owner (Primary Contact)
Currently Impact Maps can only run for organization based grants. Please allow them to run for grants to individuals which would reference the Primary Contact field on a record.
5 votes -
Add 3+ layer parent/child relationships of tags to the tag library, and make them searchable based on parent/child status as well as by tag.
Use case:
Parent tag #Training
Child1 tag #StaffDevelopment
Child2 tag #RequiredCEUs
Child2 tag #TeamBuildingChild1 tag #VolunteerEd
Child2 tag #Orientation
Child2 tag #SkillWorkshop
Child3 tag #SurveyAdmin
Child3 tag #FocusGroupMgmtAnd so on. A search on the tag "Training" would deliver not only everything explicitly tagged "#Training" but all the child tagged-items; a search on #SkillWorkshop would deliver that plus its two child tags, and a search on "RequiredCEUs" would deliver only items with that specific tag.
3 votes
- Don't see your idea?