# Create a new row but use another sheet's data as presets **URL:** https://community.glideapps.com/t/create-a-new-row-but-use-another-sheets-data-as-presets/69368 **Category:** Ask for Help **Created:** [January 8, 2024, 6:28pm UTC](https://community.glideapps.com/t/create-a-new-row-but-use-another-sheets-data-as-presets/69368 "2024-01-08T18:28:50Z") **Posts on this page:** 1 **Showing post:** 14
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [January 9, 2024, 12:17pm UTC](https://community.glideapps.com/t/create-a-new-row-but-use-another-sheets-data-as-presets/69368/14 "2024-01-09T12:17:05Z")
> [@To\_Ko](#): > > How would I manage to use column A of the preset sheet as values for the user to choose from - let’s say they choose row 7 - and then pull all the data from row seven (from all columns of that row) and use them IN ANOTHER sheet to populate a “new entry” form - Start with a Collection that uses your “Preset” table as the source - User Selects an item in the Collection. The default action will take them to the details screen for the selected row - Add a button to this screen with an Open Form Screen action. You should now have direct access to all values in all columns of the selected row to use as column values in your form. I recommend the below video: > [@sparkle Understanding (and hacking) Form Screens](https://community.glideapps.com/t/understanding-and-hacking-form-screens/69309): > > wave Hey fellow Gliders! Form screens (or form containers) in Glide are critical when creating apps that allow users to add new data (projects, tasks, posts, etc.) to your database. Navigating form screens requires some understanding of screen and table relationships and involves some mental juggling when configuring visibility conditions within the form. In this video, I peel back the layers of a form screen to show you how they work and how to work around a couple of the commonly frustratin… --- _[View the full topic](https://community.glideapps.com/t/create-a-new-row-but-use-another-sheets-data-as-presets/69368)._