Forum Discussion
QuickBaseCoachD
Qrew Captain
I'm not really understanding the ask here. Do you need to be able to change the search term you are looking for?
Or are you looking for the results to display as an embedded report on a parent record and you want children who match some word in a field on the parent record.
Or are you looking for the results to display as an embedded report on a parent record and you want children who match some word in a field on the parent record.
QuickBaseCoachD
5 years agoQrew Captain
When you set la field is being unique, in fact blank values are allowed in a field marked as unique. In fact the only duplicates that are allowed in a field marked unique is if the field is blank.
So why don�t you just mark unique and Call it a day.
Except that what you would do would be to make a summary report and group the records by this unique field and sort them up on the number of records so that the duplicates float to the top. Then do a one time manual scrub of your data to get rid of the duplicates and you will be clean going forward.
So why don�t you just mark unique and Call it a day.
Except that what you would do would be to make a summary report and group the records by this unique field and sort them up on the number of records so that the duplicates float to the top. Then do a one time manual scrub of your data to get rid of the duplicates and you will be clean going forward.