This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
One of my fields has a copy of a record that should not be there. Is there an operator or formula that will find the two records which are NOT unique?I did a simple search for 'copy' - that did not work. Any other suggestions are welcome.Thx.
Original base primary field was not useful [Newbie design]. It is 312 records. The data will not change and no records will be added or deleted.I copied data from another field (same field type - single line text) which will also not be changed. I di...
I'm thinking I can use a 'formula' field to do this task. Can anyone help with the 'Formula' field... or is there a better suggestion. Thx.IFFirst 4 characters of a record in {Unit & Week} = First 4 characters of a record in {Unit Name} AND {2023 Fee...
I created a new base in preparation for moving some spreadsheet data. Column 'A' of the sheet is dates.I'm thinking I can set the primary field as a 'date' field and include 'time' in order to make each record unique. After import (copy & paste) I ca...
So, now I realize the problem was that there were more total records than 'unique' records (1 more) in the table so I 'assumed' there was a duplicate. Actually, it was an empty record; not a duplicate.
Ok, I'm thinking...So, question about this statement... For that, I would pull in the necessary fields exactly as they are using lookups, then create formula field to reference the lookup(s) in.Do you mean the Maint Fees Table fields need to be pulle...