We are using a smartsheet to track fleet vehicles. We have created a form that employees use to reserve a vehicle. Within this form the employee selects the location of the vehicle they want to reserve, which is a drop down of cities with our vehicles in them. When they select the city, we have set up logic to make their next selection a drop down of the only vehicles in the city (License Plate/year/color/model). We then have them retype this selection manually into another text field, which is the primary key. We do this because, as far as we have figured out, the primary key is the only column that will display in the reservation on the calendar. Here is my question:
Is there a way to make this text box (Primary Key) auto populate with the information from the city and vehicle that they chose, rather than having them manually type this in again?
Any help is appreciated; thanks!
