7
votes
Accepted
List Parents of Children having certain values
Yes, using Advanced Search (Search menu » Advanced Search). Set up the search the same way you would in order to find the children. Additionally, set the "Display Results As" at the top to "Related ...
- 39.5k
7
votes
Why can't I see different financial types in contribution reports
You're looking for some advanced reporting: install this extension: fuzion extended reports -> and then look for report template: Extended Report - Price Set Line Items.
- 15.2k
7
votes
Unique custom field - contact creation
The "external identifier" field on contact records is available so you don't need a custom field. It won't allow duplicates.
- 24.7k
7
votes
Accepted
Limit contacts in "Assigned to" field of an activity to a specific group
There is, I think, already an extension that will do this. It's here and here and used by one of my (former) clients. It's being actively used and cetainly works at 5.35.2 release level.
- 4,965
6
votes
What are the files and fields in CiviCRM?
Sounds like you're new to CiviCRM - Welcome to the community. Here's a link to the CiviCRM data architecture page on the CiviCRM wiki.
You can create multiple custom fields in CiviCRM so you should ...
- 2,836
6
votes
Spanish custom last name solution
"Lastname" is the field intended to insert both surnames for the contacts they have. The translation of the field in Spanish also indicates it: "Apellidos".
For more than 5 years we have worked with ...
6
votes
Accepted
How to get "Last contribution amount" and "Last contribution date" into report?
The way we have approached this in the past is to install/enable the Summary Fields extension, and set that up so it calculates the Last Date and Last amount, which are then available as custom fields ...
- 28.7k
5
votes
Accepted
How to remove "Extended Demographics"?
The easiest would be if you can find it in the CiviCRM custom groups? Using Administer/Customize Data and Screens/Custom Fields. If that does not work, check the table civicrm_custom_group. You will ...
- 12k
5
votes
Accepted
How to create a custom field for a file upload, and make it private
CiviCRM files are never directly web-accessible. If you are also using Webform integration to submit the file, then a copy of the file is also stored in Drupal. You could either make your Drupal files ...
- 19.5k
5
votes
Accepted
Adding extra information to event registration
You will want to make the Custom fields on the Participant record (not on the Event). Then you'll be able to add them into a Profile and add that Profile to the Online Registration section for your ...
- 15.2k
5
votes
Is it possible to create nested multiselect custom field?
This is not possible via Custom Fields - this is possible via Tags.
- 28.7k
5
votes
Need to enlarge the field box size
I usually change the field type to be 'Note' when I need a longer length - then you specify length and number of lines - and it's expandable - if the user needs to add more they can resize the box.
- 4,965
5
votes
Accepted
Custom date field formatting with smarty
Found the answer. The civi field token must be captured to a Smarty variable first:
{capture assign=arr}{contact.custom_105}{/capture}{$arr|date_format:"%A, %B %e, %Y"}
- 1,367
5
votes
Cannot set sort order of custom fields in profile
The weight of the custom fields only controls the order in which they appear on the back end. The profile sets its own order. You can set the order from Administer menu » Customize Data and Screens »...
- 39.5k
5
votes
Add Custom Field to Core Field Group
You may find this new feature could deliver what you need - the MIH is still open and nearly fully funded iirc
https://civicrm.org/blog/colemanw/want-to-customize-the-contact-summary-screen
- 28.7k
5
votes
Accepted
Custom dropdown for specific relationship type
You can create custom group of fields for a specific relationship with your custom relationship type filter. This custom field will only be visible when you select relationship type from the drop down
...
- 24.7k
5
votes
Accepted
How to use full unicode on custom fields
Incomplete UTF8 support is hard coded into the core code before 5.33 (thanks @michaelmcandrew!).
The solution seems to be to re-run the System.utf8conversion routine
Pre 5.33: do this after any time ...
- 3,952
5
votes
Accepted
Survey Questions vs Contact Info
There are limitations in CiviCRM profiles mixing Contact and Activity fields (survey responses are stored as activities). If your profiles work as you expect during testing, there won't be any hidden ...
- 39.5k
4
votes
Accepted
How do you import (custom) relationship fields?
From what I can tell this functionality is not available in core imports, which allow relationships to be imported as a side function (e.g. when importing contacts, you can specify relationships on ...
- 8,288
4
votes
Editable "Other" option in multiple choice / select field?
Profile conditional ext can be used to provide this - https://civicrm.org/extensions/profile-conditionals
You dont have any UI option to build the conditions. But this can be easily done in civicrm....
- 7,211
4
votes
Accepted
How to reuse Preferred language select?
I had this need today, and wrote a general version of the extension @ñull wrote above. This lets anyone take advantage of this feature without knowing how to code: https://lab.civicrm.org/extensions/...
- 39.5k
4
votes
Use custom field in front end of website
There are instructions on the screen where you create contact reference custom fields:
Do your front-end users have the required permissions?
- 13.7k
4
votes
How can I get custom file fields in an activity to display correctly?
It sounds like you're encountering CRM-17791. This bug was discovered and fixed in CiviCRM 4.7. I would recommend upgrading a test copy of your site to 4.7 to see if that resolves the issue. If so, ...
- 39.5k
4
votes
How can arrange custom fields so they are side by side?
The case custom fields are formatted as a series of one row tables. You could add some jQuery to move them around.
For example:
CRM.$(function($) {
$('#Outcomes table:nth-of-type(3n+1)').each(...
- 13.7k
4
votes
Drupal taxonomy and Civi option groups integration
This is definitely possible. I've done it to have a custom field store a term id, and user selects from a select list of term names...
You need to implement hook_civicrm_customFieldOptions().
http://...
- 2,019
4
votes
Accepted
Contribution custom field not appearing in New Contribution window
Did you make a Custom Field on Contribution of type -any- or did you narrow it down to specific financial type(s)? If that's the case you must select the Type first when entering a new Contribution - ...
- 15.2k
4
votes
Accepted
Views : SQLSTATE[42S02]: Base table or view not found (concerning a Custom Value Table)
This error usually means .... "Drupal doesn't know the table exists" ... which either means
1/ you have your civicrm tables in a different database and need to update the list of tables that you ...
- 28.7k
4
votes
Can a Custom Field be added to a Contribution Page or Financial Type?
Under Administer > Custom Data and Screens, Create your Custom Fields
Under Administer > Profiles, Create a Profile that has your Custom Fields in it.
Under Conrtibutions > Manage Contribution Pages, ...
- 2,388
4
votes
Drupal Views Filtering on Subtype
I think I might have figured out what's going on here... The tables that are trying to be used in the view have been created after the table details were taken from sites/all/modules/civicrm/install/...
- 283
4
votes
Add Custom Field to Core Field Group
You can use JS to move custom field from custom group accordian to demographics accordian.
https://docs.civicrm.org/dev/en/latest/framework/resources/
https://docs.civicrm.org/dev/en/latest/...
- 24.7k
Only top scored, non community-wiki answers of a minimum length are eligible