Questions tagged [searchkit]
Questions or answers relating to SearchKit
171
questions
1
vote
1
answer
60
views
Using Arithmetic with Dates in SearchKit
I'd like to work out the age of someone on the date of an Activity. In SearchKit, I've used Arithmetic to subtract the Birth Date from the Activity Date and this almost works, but it ignores the day/...
1
vote
0
answers
15
views
'Print/merge documents' action not appearing for searchkit membership searches
I'm running a somewhat complicated subscription management system using memberships for subscriptions. We have multiple membership types and membership organisations. It is likely that subscribers ...
3
votes
1
answer
97
views
What dashlets are my users using?
I want to know which dashlets my back-office users have in use on their civicrm dashboard.
I was looking into SearchKit, to possibly create a table showing which dashlets are used.
But I cannot figure ...
1
vote
0
answers
16
views
SearchKit & Expenses: can't calculate with Expense Lines Amounts after Export because of Currency Symbol
I am wondering, if there is a chance to get rid of the currency sign in the results of an Expense/Expense Line Search.
After an export (Download Spreadsheet > csv/xlsx) the currency symbol ...
0
votes
1
answer
16
views
SearchKit filter for user contacts
I want to filter all user contacts in a SearchKit table to only have real external contacts in that table. I am using the CMS-ID field for this as described here: CMS User Query with SearchKit.
...
1
vote
1
answer
24
views
How can I use SearchKit and FormBuilder to show a table of matching contacts under Contact Summary by comparing custom field values?
I would like to help users to find matching "Mentor" contacts for "Mentees" based on values held in custom data fields and providing a tab on the Contact Summary called "...
2
votes
1
answer
27
views
Is World Region accessible for a search using Searchkit?
I want to add World Region as a filter in a FormBuilder search form, but I cannot locate the relevant field in SearchKit. It is clearly available in Civi as it is available in predefined Advanced ...
0
votes
1
answer
52
views
Date added to Group
I've created this searchkit search of people who have been added to a Campaign Newsletter group. I want to include the date they were added to the group, but I cant seem to work out how to do it. I'm ...
0
votes
0
answers
22
views
Searchkit webpage encountered an unexpected error after CiviCrm upgrade
I've upgraded my environment
from Drupal 10.2.0 & CiviCRM 5.69.4
to Drupal 10.2.6 & CiviCRM 5.73.3 (PHP v8.3.7)
But since that upgrade the searchkit (overview) page is broken, however (most ...
1
vote
1
answer
45
views
Search Kit Match pattern
I am trying to run a search that would return first names that are random string of letters/numbers. We had a lot of spam come through a signup form, where first names look like "sldkfmVUnkdUnnns&...
1
vote
1
answer
34
views
Customize column headings in results of SearchKit
How can I customize the column headings (aliases) in the results of a SearchKit search? The column names are sometimes very long and non-intuitive for my end users, especially when you join with 2-3 ...
0
votes
1
answer
36
views
SearchKit table display link is missing URL parameter
I have SearchKit searches/tables on cases that that use a link on the ID column. Some of them - I presume the ones that I built last - don't have URL parameter cid in it and thus lead to errors when ...
1
vote
1
answer
33
views
How to sort the result of a Search Kit?
I have a multi record date custom field related to contact.
When I view the result of the submission of the custom field in search kit the result shows in random order. How do I sort in Ascending/...
1
vote
0
answers
22
views
SearchKit: GroupBy Rows/Columns?
Would it be possible to create a [pivot?] table in SearchKit, where rows are Membership Type(-s) and columns are Membership Statuses, with sum of results in cells? Used to be possible with the ...
0
votes
0
answers
22
views
Limit Access to Form (Formbuilder)
I am currently familiarizing myself with FormBuilder. I see it is possible to limit access to a Form by ACL Permissions. But is there a way of limiting Access by group or even individual user?
If not, ...