Questions tagged [custom-fields]
Questions about custom fields in CiviCRM.
548
questions
1
vote
1answer
9 views
custom fields in hook_civicrm_pre' $params have an extra “_-1” suffix
On my latest Civi 5.37.2 the params array passed to hook_civicrm_pre looks like:
Array
(
[hidden_custom] => 1
[hidden_custom_group_count] => Array
(
[] => 1
...
2
votes
2answers
8 views
Webform integration - how to I get a webform to create multiple records in a custom field set?
Using Drupal 7.81 and Webform 4.x with CiviCRM Webform integration.
I have an application form that uses a custom field and this field is set to allow multiple records. The form is set to expose 6 ...
0
votes
0answers
9 views
SQL too many joins limitations- what will break and how
From experience I know that once a database reaches a certain size the sql limitation of 61 joins can cause problems
I've seen it raised in stack exchang here:Too many tables - MySQL limitation - ...
1
vote
0answers
9 views
Custom field checkbox option seems non-searchable because of + character in value. How to access my data?
I created a custom field months ago with checkbox options for age categories, including an option with the value '65 and +'. I can search for the other values of the same field without any problem (ex....
1
vote
0answers
11 views
Custom Field data missing in export
For an event we wanted to aks for more information so i set up a set of custom fields.
I added this to a profile and added some more fields
I added the profile to an event registration. If a user ...
1
vote
1answer
33 views
Add a custom field as a column in relationship tab
I added a column in relationship tab, to do that I edited the civicrm/CRM/Contact/BAO/Relationship.php
I already added columns with fields existing in the base of civicrm but now I'm trying to add a ...
0
votes
0answers
18 views
Is it really not possible to have two multi-record custom fieldsets in one profile?
I'm trying to set up a form for contacts to update their own data via our Joomla frontend. However, I ran into an unexpected problem when I tried to add a second multi-record custom fieldset to a ...
1
vote
0answers
16 views
Illegal text in MySQL queries
I have a CiviCRM install on Windows shared server operated by a client. The installation was originally set up on a dedicated Ubuntu Linux virtual server, but was transferred to the Windows server at ...
0
votes
1answer
24 views
Searchable Profile fields do not work
I have an issue on creating profiles.
When I create a profile with several fields such as "First Name" "Past Name" "E-Mail" and some Custom Fields and I set these fields ...
1
vote
1answer
8 views
Search custom field by name
if I want to get a value of a custom field, now I have to use custom_xx, like this:
$result = civicrm_api3('Contact', 'getvalue', [
'return' => "custom_11",
'id' => 123,
]);
As ...
2
votes
3answers
36 views
is there a possibility to add custom fields to “notes”
We want to structure the content in our "notes" by adding custom fields. We want to do this in notes because it is the only place where you can shield datafields form other users.
0
votes
1answer
24 views
How to send Participant-Specific information via CiviMail
We are running a hybrid event where some participants are virtual via Zoom and some participants attend in person. We need to send out reminders and the zoom link to virtual attendees, and also want ...
0
votes
1answer
15 views
Custom field saves, for all entries, instead of wanted data a number that is not in original data
I'm having an odd problem with a custom field within a custom data set.
The field is made for personal identification number, data type is integer and it's a single line input field.
Every time I ...
1
vote
1answer
27 views
Voting Election
I am reviewing the Civic CRM Election component for Joomla. I have created some basic election information and nominees. I need to add Amendments for this election. I don't where I would add this. ...
0
votes
1answer
18 views
Editing custom group settings
I'm trying to edit the settings for an existing custom fields group. When I make the changes and save it, I get this:
Please correct the following errors in the form fields below:
Custom group '...
2
votes
1answer
16 views
Option Group vs Custom field
New install (civicrm 5.35.1) and I can't find this answer.
We have 22,000 alumni that I've imported. One of the fields is cast year there are about 120 of these so I want to make an option group (it ...
1
vote
1answer
21 views
Export of custom multiple choice options to CSV files limited to 32 characters
A user is trying to export data from an advanced query on custom fields to a CSV file using the "Export contacts" action. This fails with a backtrace which is attached below. The error ...
1
vote
1answer
56 views
How can I delete a custom field (other than GUI)?
I had a custom field group with a disabled field.
When I tried to delete the field (ID=59), the Warning window froze with CRM logo rotating.
When I tried to enable the field, it gave Error about DB ...
0
votes
0answers
12 views
How to recreate civicrm_value table(s)?
I just had to restore a site and some of the civicrm_value (a.k.a. custom fields) tables were not part of the backup
The groups / fields are still in the groups tables - how can I easily recreate the ...
1
vote
1answer
28 views
File type custom field to only allow images
I have created a file type custom field and discovered that you can upload any type of file on the field so I want to restrict the custom field to only upload image files. Is it possible?
0
votes
0answers
19 views
How can I create a checkbox for filtering contacts in report?
I'd like to filter out specific contacts from a (contribution) report, based on a manually enabled or disabled custom field. By default everyone should be included in the report, but if the checkbox ...
0
votes
1answer
31 views
Joomla 2 CiviCRM User Sync: synching Community Builder multi-value custom fields?
looking for some suggestions on best practice implementation for synching external data to CiviCRM custom data.
I'm using the Joomla 2 CiviCRM User Sync plugin to sync my Joomla 3.9.24 user ...
0
votes
1answer
23 views
Add custom field with multiple values to Contact Form 7 and Form Processor
I can't seem to make a custom field that allows multiple values work if more than one value is selected in Contact Form 7 via Form Processor. If one value is selected, everything works fine. If more ...
1
vote
0answers
32 views
Does Civi rename picture files?
I have a situation where authorized users can upload a scan of their passports. While this doesn't happen often, there are times where various users will upload "Passport.jpg" as necessary. ...
2
votes
2answers
33 views
Custom field set - how to move Delete button (or prevent deletes)?
Users are 'accidentally' deleting custom field sets because (so they claim) the 'Edit' button and the 'Delete' button are too close together after clicking the custom field set tab. So is it possible ...
1
vote
1answer
16 views
Change count in Custom Tab with table according to filtered data
I have filtered the data being shown in a custom group tab on contact page but I'm struggling on how to change the count being shown next to the tab name. Could anyone help me how? thanks
1
vote
1answer
16 views
CiviContribute/CiviCRM overrides content entered into a custom field each time a donation is made
Hopefully I can explain this so it makes sense. :)
We have customers that have donation pages (and events) that they use custom fields with, but when someone completes the custom field once, it does ...
0
votes
1answer
18 views
Why does my 'Delete Case' action in the case search report not work?
When I use the 'Find Cases' report (from the Case menu), and I select [Delete Cases] it does nothing. And it looks de different. Like this:
CiviCRM version 5.34.alpha1 on Drupal:
And besides that, ...
1
vote
1answer
29 views
Unable to Create New Contact Field
I'm currently setting up the CIVICRM platform, now at the stage of importing data I am unable to create new contact fields, I followed the instructions available to create custom fields however none ...
1
vote
1answer
32 views
Automatically filling custom fields with data
Is there a way to automatically populate a custom field with data from other parts of Civi?
My use case is simple. We have an arts organization that uses relationships to link "partners" ...
1
vote
1answer
32 views
custom fields become unavailable after a period of time
I have created some custom fields to collect size data as part of an event registration form. When I first create the fields I am able to include them in a profile and use them on the form. At some ...
3
votes
1answer
42 views
Survey Questions vs Contact Info
CiviSurvey has two types of information we could collect - 'Contact Info' and 'Questions'. Is there any difference between these two from an implementation perspective? Would it make any difference if ...
0
votes
2answers
26 views
Alter custom field view
I have created a set of custom fields and I want to hide some data which have specific value, I have tried using
$smarty = CRM_Core_Smarty::singleton();
$smarty->assign('records', []);
to try and ...
0
votes
0answers
14 views
How can I enable multiple entries for an existing Custom Data Set
I have an existing Custom Data Set that I want to enable multiple entries for, but when I open the settings and try to enable it, I'm unable to- when I click on the option, nothing happens.
0
votes
0answers
8 views
Dedupe error when merging records with custom values
I have a set of records where participants have registered for some events, with additional booking info, using different email addresses so have created duplicate records. When merging these I ...
4
votes
1answer
66 views
Extension for hierarchical custom fields?
Does anyone have a generic extension for hierarchical custom fields?
For example, we have 'Country', 'State' and 'County' - the value of Country determines what States are valid, and the value of ...
1
vote
1answer
20 views
How to add a profile with a fieldset that accepts one or more entries for event registrations
I'm not sure that this is possible but here goes:
I have a requirement to collect data from Event Registrants of University Programs that they have undertaken and the years of study they have ...
1
vote
2answers
28 views
exporting custom data structure
I'm looking for some recommendations. I've inherited a CiviCRM instance with a quite complicated custom data structure, and I want to review and update it. I was wondering if there were any tools or ...
0
votes
1answer
20 views
Multi-Select Field No Longer Working
I have a site I manage that uses a "Multi-Select" HTML field type. I do not use the field so I cannot say exactly how recently but no more than the last month our field stopped being able ...
1
vote
1answer
36 views
How to chain api calls i.e. GETFIELD contact for fieldID after doing GET profile on profileID?
I want to join the below api calls-
API 1
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Profile&action=get&api_key=userkey&...
2
votes
3answers
42 views
How to get a CiviRule to fill in a custom field upon a webform submission?
We have a Drupal 7 website that we are having users submit a webform on. When a webform is submitted it is assigned a unique ID. This ID used to generate a PDF to view the webform results and is ...
3
votes
1answer
28 views
Record audio/video fields for contacts?
I'm using CiviCRM + Drupal 8.
I'd like to be able to add fields to contacts that can record audio &/or video, so that we can collect interviews with our contacts.
Is it possible to add "...
1
vote
0answers
11 views
Is is possible to hide GiftAid details if someone selects 'no'?
We're using the GiftAid plugin which is great.
However, if someone declines to use GiftAid the fields are still present and compulsory to fill in.
Is there any way to make them conditional on ...
0
votes
1answer
30 views
How to have one custom field open one or more other fields in a frontend form?
I need to have a checkbox or yes/no radio field that opens 'Preferred Language field when value=1 or affirmative choice. How is this done?
A more exact use-case: To choose Language Interpretation:
...
1
vote
1answer
20 views
Is it possible, using ACLs, for a group to have only 'create' access to contact custom data and another group to have 'edit'?
My user would like one group of users to be able to have only 'create' only access to a custom field set that will be in a contact's tab, and for another group to be able to have 'edit' access. I ...
1
vote
0answers
18 views
How to turn off multiple-record custom field set
I created a custom field set and initially checked the box "Does this Custom Field Set allow multiple records?". I would prefer to convert this field set back to a single record. I checked ...
1
vote
1answer
53 views
How to use full unicode on custom fields
There's an API call System.utf8conversion which will change all your tables to MySQL/MariaDB's utf8mb4 format, i.e. full unicode with emoji support, rather than the incomplete utf8 implementation of ...
-1
votes
3answers
43 views
Can't i create study result for student
i doing customization CiviCRM,
My Charity working for Education(Donor, student, volunteer). One student have 1 study result/year.
example: student study 12 year then student have 12 study result.
Can'...
4
votes
2answers
48 views
Preparing for move to utfbmb4 should I limit character length?
I'm looking into moving our database to utf8mb4 - as indicated will be required in the future. I've been trying to find information about the possible impact in doing so and I found this post: https://...
2
votes
3answers
91 views
Custom fields sometimes missing from profile, until flushing caches
On civicrm 5.20.1 under WordPress, we have added two custom fields to the Registration Info profile (gid=12). We've added that profile to the Online Registration config for one event.
Now and then, ...
