MarkGlevicky
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
10000 Records - List is now a search
We just crossed over 10000 records in our database. Now, instead of a list of our customers, there's only a search function. I can make another report I suppose which shows all customers, but it's two more clicks than what it was. Can I change this back?4Views1like2CommentsRe: Find records that were deleted today
If not, is there a way to specifically find which records are now "not in the table" when you get an error message saying "Some record IDs specified were not found in the table" when trying to import? My file has 400+ records and there's probably ONE that was deleted while this file was saved as a spreadsheet, modified, and then attempted to import it. There must be a way to identify which record is missing....229Views0likes0CommentsRe: 300 Emails (records) accidently deleted. Can't cut/paste from new table created from backup csv
I ended up just including columns C D E in the report that we export, even though they are not needed for our updates. After doing this, the tests I ran showed those columns to be coming back in during import, unchanged as expected...and not blank! I don't have time to run this to the ground, but I have a feeling that if you don't include a column or columns in the -middle- of the report, this happens, either sporatically or every time. Again, not sure, but it happened twice for us. I'll be back if it happens again! Thx for help. Mark0Views0likes0CommentsRe: 300 Emails (records) accidently deleted. Can't cut/paste from new table created from backup csv
Ok, now a follow on to what happened above. The "mass deletion" of certain records happened again! I've found that it's related to import/export work we're doing and it's weird. Here's the story... This issue is kind of hard to explain, but will do my best. We have a report that filters to only certain columns. In simple terms, lets say the columns in the main table are A B C D E F G H. The columns we filter for the record (to display) are A B F G H, leaving out C D E. The record ID is included as a key for re-import later. So.... we modify the fields in the report as needed, then import this data back into the main table. The process shows that all columns are correctly match up and "green", so the import is done. Now however, the main table now shows all blanks or empty values in columns C D E! This, even though these columns were never exported, and therefore were never modified or touched. I also should note that there are other columns the are filtered out or even switched in display order in this report that are further to the right in the main table, but everything in this region seems to be unaffected on the main table after this import. I'm totally baffled. Any ideas? Thx, Mark0Views0likes0CommentsFormula for a report - text triggers number
I have a column in a report that I want to put a report formula column next to. The initial column contains text and I want the formula column to put a numeric value based on the text in the first column. Here's what I've come up with but it doesn't like something here. Hope you can help. If ([WRO] contains "W", .5, null ) If ([WRO] contains "R", 1, null )