Community
Showing results for 
Search instead for 
Do you mean 
Reply

Create a Number for Each Company

New Member
Posts: 15
Country: United States

Create a Number for Each Company

I want to number all my companies; I have a huge project that requires me to research certain items of each company in my act database. Unfortunaly, each time I do it I sometimes end up spending time on companies I have already completed. I feel if I were to number the companies then I could say, today I'm doing 1-20 tomrrow 20-40, and then it won't over lap. Also Is there a way to auto generate a number each time a new company is created?

Bronze Super Contributor
Posts: 1,679
Country: Australia

Re: Create a Number for Each Company

What I do is either create a dedicated field (Tools | Define fields) called "To be cleaned" or I use one of the user fields (USER 1, USER 2, etc).

 

  1. I do a lookup of all,
  2. List view
  3. Then Edit | Replace field
  4. Replace the contents of "To be cleaned" with the text "Not clean"
  5. Now create a group with a dynamic rule to include all where the "To be cleaned" field equals "Not clean"
  6. Then as I have time I simply open up the group, do a look up and clean away, 
  7. Each time I've cleaned the record, I blank out the field. This removes it from the group. 

This way I don't keep doing records I've already done. I'm equally sure there are a number of other ways to do this. Smiley Happy

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Create a Number for Each Company

DesignR1's Swiss Army Knife might let you auto number.

 

Exponencial has a field calc tool, that could probably do it to - although don;t think it "fires" auto-magically...

 

If you have TopLine Designer, it could be scripted...

 

All that said, previous suggestion would work nicely...