I'm using CiviCRM to (in part) manage a large group of translation volunteers for our organisation. I've got everything set up quite nicely, using custom fields and groups to help our staff manage translators able to work in different languages, know whether they have already had a translation requested, etc. I've got the various smart groups set up as menu items, so other staff can quickly see which translators are available in which languages, which are occupied, etc.

We have a custom date field for "date finished last translation", so staff know if a translator has recently finished a translation. One thing I'd like that I can't work out is how to list this date field in the smart group search. At the moment that search displays their name, email, and their language. However, whenever I add the "date finished last translation" field as "is not empty" or "is not null" it returns no contacts, even though I know there are contacts who have that field completed. If we get it working, staff will be able to easily see who has most recently completed a translation, so not ask them again.

  • wow, congrats on finding an interesting usage of CiviCRM. could I ask why you chose to use a datefield vs an activity for tracking when something is completed? a screenshot, some more details on your civicrm version, platform (drupal/wordpress), etc. would also help. – Zachary Jun 6 '19 at 16:14
  • I am also wondering whether Activity would be a better fit. It would be the track i would head down – petednz - fuzion Jun 6 '19 at 20:21
  • Thanks. I went this way because the translations (as an activity) aren't as important as what the translators are doing at any one moment - being able to see if they're occupied or not for example. The date thing is much less important than being able to see whether a translators is/isn't occupied at the moment (we really avoid sending the same person more than one thing at once), this would just make things even nicer. We're on drupal, version 5.5.1 – Andrew Metheven Jun 6 '19 at 21:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.