Log In

Log In

Not registered yet?

Reset password Activation link


RE: Duplicate entries in database

Publication date: August 13, 2018

Dear Sir or Madam:

I am finding duplicate entries in my database after entering a search term. To recreate the issue, set your search for “ALL” “like” “drugs” in the three search lines. Hit enter. You should see 657 rulings.

I transcribed all of the rulings into an excel file and have been finding dozens of duplicates. What I’m noticing is that anything above 500 tends to be a duplicate. I have confirmed that I have not accidentally entered the information twice (though I’m sure this is still a possibility, generally speaking). The database itself is reporting duplicates after a search.

For example, ruling #39 (of 657) and ruling #514 (of 657) are the same. I’ve confirmed that this ruling is listed a single time in the database, but it shows up twice in the list when I enter the above search terms.

Can you help me out with this?

Thank you,
S.Matt Read

Bug in Duplicate form field titles

Publication date: August 16, 2018

I have not tested this through but it appears an old bug has returned;

1. Create a master form and database with default fields that will be changed in duplicated forms.
2. Duplicate the form and change the default fields.
3. Set the duplicated form to write data to the master form database in advanced settings.
4. Test the data entry of duplicated form and the master form form defaults are written, not the changed ones for the duplicated form.

Duplicate Form Redirect

Publication date: August 16, 2018

When duplicating a form and setting ‘Submit Data To’ to the original database, the ‘Redirect To Another Website’ option under Redirects in ‘Customize and integrate’ does not work for the duplicated form, only for the original.

Duplicate A Form

Publication date: August 16, 2018

When a form is created to contain default images and blank section headings and then Duplicated both the default images and blank section headings are dropped from the newly created form. This results in the user being forced to re-create all default data for the duplicated form, very time consuming!

Default image in Submit to form

Publication date: August 16, 2018

I confirm that when a duplicated form is set to use Submit To feature that while text field defaults are being read by the data entry form the image fields seem to read in from the original source form – the one that the duplicate was created from – even though the duplicate form has saved the replacing default images.

Field rules in Submit To form

Publication date: April 30, 2019

1. Duplicate the form and test… field rules are OK.

2. Use Advanced Settings to write data of duplicated form to another central database

3. Field rules are then corrupted and resulting form is useless.

The process of writing to the central database is losing certain field rules.

Merge Duplicates

Publication date: August 20, 2018

In the database we uses prior to MTH there was a feature to “merge” duplicate records so that links aren’t broken to other forms. Can we please have the ability to do this in MTH? We have several people adding contacts and sometimes they don’t find the original record and add people again. Thank you!

Duplicate charts

Publication date: August 20, 2018

It would be a great time saver if we could duplicate existing charts then modify duplicates much like the Duplicate Form feature.

Duplicate Form Integration into new projects

Publication date: August 20, 2018

I think we need a feature that will allow duplicate forms to be placed into new projects. Right now the system won’t allow for this and changing the ID numbers does not help. Perhaps a feature that would assign the duplicate form to be assigned new valid ID’s would help.

Don’t forget to vote for this topic to have it added to the developers log!

Remove Duplicates

Publication date: August 20, 2018

In addition to Searching Duplicates we need Remove Duplicates functionality.

This method located at the same place as Find Duplicates, it’s just removed all the duplicated it can found, by 10k records in a time.

Finding Duplicates

Publication date: August 20, 2018

I suggest a function “FIND DUPLICATES”, based upon the user’s choice of column. Example: “FIND DUPLICATE” in column “NAME”, where there are more than one record with identical names.