How to auto-fill a select list

I'm creating a form that once submitted will start a new form, this new form will have certain fields auto-filled with the respective information from the previous form. The context is that this is a sign-in/sign-out form, and the user will select their name and information from a select list when they sign out. Does anyone know how I can make this happen? What I tried to do at first was create a select list that automatically created new entries based on the "Forename" and "Surname" fields in the File Cabinet, but when I tried that, the select list wouldn't let me publish because it was "empty", and I just added a "User" as a placebo and the dropdown only shows that value.

Hi Rhys,<br> <br> Unfortunately you can't setup a form with certain fields auto-filled in any way except by setting their default values, which won't make them dynamic in the way you want. That's a feature that has been requested in the uservoice forum (I encourage you to find it and give it a vote).<br> <br> You should certainly be able to setup the select list you want though.&nbsp; When you were setting up the select list did you select 'Database Connection - Content' as the source?&nbsp; Once you've done that you should be able to find the file cabinet in the Table drop-down and select the Forename and Surname fields, which will give you a multi-column select list that you can use on your form.&nbsp; If you're working with an on-premise system and you've set it up to allow SQL statements then you could put together a SQL command that would concatenate both those fields into one single field on the form that they could select their name from so they could select their fulname in one field (eg. they could pick "Rhys Wolley" in one field instead of picking "Rhys" in one field and then "Woolley" in the next).

Thanks Jon, I've got the select list configured now, thanks. What I want now is to be able to delete those entries after the user has signed out. Assuming there isn't a less complicated, automated way of doing this, would it work if I had the workflow email me once the Sign In/Sign Out field says "Sign out", then deleted the select list entry manually?

How about configuring a deletion policy that will delete any record with "Sign out" in the Sign In/Sign Out field?&nbsp; It won't be instantaneous because deletion policies aren't reactive in that way, but it'll be fully-automated and certainly faster than if you get an email and have to go in and delete it yourself.

Well I don't want to delete the documents themselves, and it won't remove the entry from the select list for the next person to use the form. I deleted the documents manually for a test and select list entries are still appearing when I try to repeat the form. Do you know if select list entries CAN be automatically deleted?

Oh, I see, I thought you had the list of names in a separate file cabinet, but they're actually in the file cabinet that the documents are going into.&nbsp; I think you'll have to wait until DW 7.6 comes out because that will include the ability to use multi-column select lists in forms, and once you have that you'll be able to filter the select list to only show names that have "Signed in" in the file cabinet.&nbsp; Does that make sense?

Ah, ok. So the functionality isn't currently in DocuWare, but will be in a future update? Thanks