2

Turns out the solution was one I'd be staring at for a while. Administer > Localisation > Address Settings change the Address Display for state/ province from {contact.state_province} to {contact.state_province_name}


1

This doesn't fix the larger issue (see e.g. https://lab.civicrm.org/dev/core/-/issues/1709) but you can update your database to put the full name in the abbreviation field: alter table civicrm_state_province modify column abbreviation varchar(64) DEFAULT NULL; update civicrm_state_province s inner join civicrm_country c ON s.country_id = c.id SET s....


1

It should be like below // Not returning anything, the tags are not interpreted at all // function mailhooks_civicrm_tokenValues( &$values, &$contactIDs ) { foreach($contactIDs as $id){ $address = \Civi\Api4\Address::get() ->addSelect('street_address', 'supplemental_address_1', 'supplemental_address_2', 'supplemental_address_3', 'city',...


1

The more general issue about state has come up before, e.g. https://lab.civicrm.org/dev/core/-/issues/724 and https://lab.civicrm.org/dev/core/-/issues/1709. It's not a full solution but you can manually update the abbreviations in the database in the civicrm_state_province table, but you'd have to change the column size in the table definition, and someday ...


1

Welcome to CiviCRM SE, Could you please tell why you want to add 'is_active' field to country table? Can't you just disable the countries from appearing in drop down(or include only countries that you need in your system) from CiviCRM >> Administer >> Localization >> Languages, Currency, Locations?


1

You would need to setup your FROM email by going to the menu item Administer > CiviMail > From Email addresses Address format should be like "My organization" myemail@myorganisation.com


1

If you're talking about CiviMail message templates I think this is very similar to this question, maybe even a duplicate. You need to use {capture} and then put the captured variable in your if statement.


1

This can be done via settings at civicrm/admin/setting/preferences/address?reset=1 Look for the field = Address Name in the section Address Editing it can also be removed from display at same screen, look for Address Display and remove {contact.address_name}


1

I think this extension will help you for the future record. https://lab.civicrm.org/extensions/formercommunicationdata


1

Might also want to consider using the "Future address changes" extension, https://github.com/CiviCooP/org.civicoop.futureaddress Future address changes This extensions adds functionality to change an address in the future, the old address is archived as an activity in civicrm.


Only top voted, non community-wiki answers of a minimum length are eligible