Pinto Vasa, Welcome to CiviCRm SE. Yes its possible to include any CiviCRM custom fields on webform which is available under their respective tab of CiviCRM webform config setting. Those fields will be pre-populated on webform based on logged in user details, will be empty if its a anonymous submission or new submission if logged in. The webform can be used ...
As people have pointed out there is a very comprehensive answer to the question of anonymising data, however this questions was about simply clearing data.
The correct answer from Pete and Demerit was that I had missed the sort_name column from the civicrm_contact table. So the full SQL is now:-
delete from civicrm_email;
delete from civicrm_address;
While there's a good answer as indicated by the comments above, in this specific issue might be seeing data from the cache in those autocomplete results?
CiviCRM has a UI to clear the cache at something like Administer > System Settings > Cleanup Caches & Update Paths
Using CiviCRM's public interfaces / ux / tools like civix are recommended over direct ...
If you can access httpd.conf file, add TimeOut value - it dramatically changed the number of records we were able to import - 5x and perhaps more per upload.
The value should be set under Server Root section
we set as a temporary value to:
Lisa, Welcome to CiviCRM SE. Since Civi stores response as a activity, you can create schedule reminders to send sms/email for Activity type 'Inbound SMS' with 0 hrs after activity date time and limit to group of contacts. You can also use tokens like activity details, contact name etc in your message.
Using CiviRules extension you can send email/sms by ...