10
votes
How can I change the date format in a Search Kit result?
You must be on CiviCRM 5.47+ to have the "Use Smarty in Search Kit rewrites" feature.
Create a Search Display based on your search - e.g. Add » Table using the Add button in the left pane.
...
- 39.4k
8
votes
Accepted
Is there a way to freeze column headers in SearchKit?
You can add CSS in your theme file
div.crm-search-display-table table thead tr {
position: sticky;
top: 42px;
box-shadow: 0 2px 2px -1px rgb(0 0 0 / 40%);
}
- 34.5k
7
votes
How to count individuals by age bracket?
I was able to create the search, thanks to the input of petednz.
First, create a data segmentation for the age brackets, like so:
Next, you can use the data segment in the group by clause of the ...
- 153
6
votes
Accepted
Make a SearchKit viewable with minimal permissions
Yes. You can do this by embedding your Search Display in an Afform, and controlling the permissions from there. To do so you want to disable permission checks on the Search Display:
And on the Afform ...
- 19k
6
votes
Can filter values be passed in via the URL to Form Builder Search Forms?
Yes, in the table display add a filter for the argument you want to allow to be passed in. Set the value to be read from the URL and specify the field tag you want to use. Then append #/?field=value ...
- 13.6k
6
votes
Accepted
How to download SearchDisplay results as a PDF via API4
you need to specify --user parameter in the cv API call otherwise the fetch will be treated as anonymous user and will return blank results if the results don't have access to an anonymous user. ...
- 34.5k
6
votes
Accepted
SearchKit configuration management
Your analysis is correct about where the data is stored:
SearchKit stores searches and displays in the database
Afform stores form layout and form config in .aff.html and .aff.json files, ...
- 19k
6
votes
Accepted
Searchkit - Can you search for any email that matches criteria?
When you search on Contacts, you get primary and billing email fields available as a convenience.
If you join to Contact Emails you get all the email fields:
- 13.6k
5
votes
Does CiviReport have a concept of "Group By"?
Reports for Contributions have grouping and quite a few in the 'Extended Reports' extension (which I guess most would use) as well. The 'Report Plus' extension has grouping also. So CiviCRM certainly ...
- 4,915
5
votes
How can I place an "Add Record" button on a contact tab built with Search Kit?
There is no UI to do this, but you can use the Form Code Editor extension, which ships with CiviCRM.
Go to Administer menu » System Settings » Extensions and enable the Form Code Editor extension.
Go ...
- 39.4k
5
votes
Accepted
How can I search contacts removed from a specific group?
I authored Subscription History Report and it's a good choice, but these days I would use Search Kit (an extension which ships with CiviCRM - Administer menu » System Settings » Extensions.
From there,...
- 39.4k
5
votes
Is there an "Deliver report by email" equivalent for SearchKit?
There doesn't seem to be an extension, but see this recent discussion on chat for an option from Demerit, which I'm pasting here:
"I don't recommend this as a real solution, but for something ...
- 4,083
4
votes
Multiple financial types from contributions - how does one search donors to find those that have contributed to only one financial type?
You can do that with SearchKit:
See this link on dmaster.
If you don't see all the options, check you are on the latest release. This works on current master which is 5.48.alpha1 (and maybe earlier)....
- 13.6k
4
votes
SearchKit vs CiviReport vs Jasper: Best reporting tool to integrate into Civi?
Reporting needs vary widely, and Jasper is a heavy-duty solution compared to pretty much anything else.
SearchKit is the future of advanced report building within Civi. CiviReports is clunky and ...
- 39.4k
4
votes
Accepted
How can I create a group containing all contacts with more than one email address?
This is an old question but has a new solution using Search Kit:
See here
From the search, you could create a smart group.
The original solution looks for multiple addresses even if they are the same....
- 13.6k
4
votes
Accepted
Sharing access to a search kit display table with non-admin user
Alright, in case this is useful for anyone else -- it looks like the answer was that I needed to be embedding my Search Kit search into Form Builder rather than just the using the Search Kit displays.
...
- 113
4
votes
Is there a way to modify/customize the fields shown in the Group Contacts Window?
Alternatively, you can build your own using the rapidly-evolving Search Kit.
For example, try this on dmaster.demo.civicrm.org
(screenshot added for posterity)
Results:
- 13.6k
4
votes
Accepted
Search Kit - List of Events with their real total amounts
I think what you want can be accomplished by filtering out transactions with an incomplete status, like this:
- 19k
4
votes
Accepted
Is it 'Search Kit', 'SearchKit', 'Search-Kit', 'search kit'? 'Form Builder', 'FormBuilder', 'Form-Builder', 'afform'?
We are standardising on camelcase format, so the preferred names are:
SearchKit
and
FormBuilder
References to these in the CiviCRM interface and documentation are being updated where necessary.
('...
- 13.6k
4
votes
Can front end forms display recent entries?
SearchKit is your friend! (... assuming your front-end is on the same site as Civi. I don't think we have a good way to send SearchKit results to a remote site yet.)
In SearchKit, create a search:
...
- 13.6k
4
votes
SearchKit - can I return the first four characters of a string?
I've put up a PR to make LEFT(), RIGHT() and SUBSTRING() available. If you don't want to wait for the release with these, just put a copy of those files into the right place.
That will let you show ...
- 13.6k
4
votes
Best way to go from an Excel list of Contact IDs to a Civi group
Can you do import with update flag and on preview screen you can add contacts to group.
or using URL you can do /civicrm/task/add-to-group?reset=1&cids=119,122,137
- 34.5k
4
votes
Accepted
How to get a feedback statistic using civicrm custom field?
You can use SUM function in fields to get the total number per record, but you will need to group by record id
- 34.5k
3
votes
Does CiviReport have a concept of "Group By"?
You can build that with Search Kit
Try this on dmaster.demo.civicrm.org
- 13.6k
3
votes
How can I create a group containing all contacts with more than one email address?
Here's a hack that only works if you're not using the "Do not SMS" field for contacts, if you do, find a different one.
Use that field as a temporary flag to identify contacts in the group, using sql ...
- 6,921
3
votes
How can I search contacts removed from a specific group?
How about using Subscription History Report
- 34.5k
3
votes
Search Kit with an auto toggle
I think you're looking for the Auto-run setting that appears on the search display edit page (not the compose search page).
Add a display to that search (using the Add dropdown at the left) and then ...
- 24k
3
votes
Accepted
How can I include two types of contribution in a single report
SearchKit is your friend! It can do 'or' in the search.
See this :
- 13.6k
3
votes
Controlling Available Search Kit Actions at a Granular Level
The hook will work to do what you want, but you should inspect the $tasks variable to see what it looks like. The array is keyed by entity type so your code needs to be updated accordingly.
But as ...
- 19k
3
votes
Controlling Available Search Kit Actions at a Granular Level
As of CiviCRM v5.60 this is now doable in the UI!
Selecting only certain tasks:
Results in limited choices:
See https://github.com/civicrm/civicrm-core/pull/25521
- 19k
Only top scored, non community-wiki answers of a minimum length are eligible