troubleshooting Question

Auto Populate a field based on forms already created.

Avatar of cedent
cedentFlag for United States of America asked on
Lotus IBM
7 Comments3 Solutions215 ViewsLast Modified:
I have a form that will be utilized to track issues.  I need to have one of the fields autopopulate based on the last document created.

CAR_Number  (has choice of A-Apple - P-Pig - E-Elephant)   from a drop down box.
CAR_Number_1 (should be a numeric field)
CARNumberComputed (brings together the previously listed field to show a complete document number)

I need to be able to:
1) Autopopulate CAR_Number_1 based on previously created documents...populate with the next number in line.
2) Somehow trim the value that is brought into CARNumberComputed from CAR_Number so that only the first digit of CAR_Number choice is shown.
                 e.g.  Choose A-Apple from drop down menu   autopopulate numeric field and the output shows
                        A1234  or A-1234
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros