# Copy-paste value from database to another by submitting a form

**URL:** https://community.glideapps.com/t/copy-paste-value-from-database-to-another-by-submitting-a-form/72702
**Category:** Ask for Help
**Tags:** data-sync
**Created:** [April 18, 2024, 3:59pm UTC](https://community.glideapps.com/t/copy-paste-value-from-database-to-another-by-submitting-a-form/72702 "2024-04-18T15:59:02Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)
#### Post date: [April 18, 2024, 3:59pm UTC](https://community.glideapps.com/t/copy-paste-value-from-database-to-another-by-submitting-a-form/72702/1 "2024-04-18T15:59:02Z")

</div>

Hello gliders, my users select a product in a form from a product list database called “references” :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d32ec4ffb902eca5d46bef878403b6a196dc39b.png)

Then, by submitting, their selection is saved in another database called “Product items” :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4ce5530468819daa7544b272e508c0056fc76f48.png)

I want the submittion save product ID (column “Référence”) in the meantime, while this data is not in the form screen :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/eda1227e2960c3532980b66c5cbb3dafc49334ed.png)

Do you have any idea of how to do it?

I thought about solutions but without knowing how to do, like :

- A hidden field in the form screen that autocomplete Product ID while select it
- Using Set column values after submission
- Using something quite like Relation column type  
In any way, I need then to display this Product ID in the app

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 18, 2024, 5:02pm UTC](https://community.glideapps.com/t/copy-paste-value-from-database-to-another-by-submitting-a-form/72702/2 "2024-04-18T17:02:00Z")

</div>

I recommend changing your choice component to display the Product Name, but write the Product ID Value to the Reference column. Then add a Relation and Lookup column to retrieve the Product Name from the reference table using the Reference value to build the relation.

---

<div class="post-metadata">

### Author: ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)
#### Post date: [April 19, 2024, 7:36am UTC](https://community.glideapps.com/t/copy-paste-value-from-database-to-another-by-submitting-a-form/72702/3 "2024-04-19T07:36:41Z")

</div>

Hello @Jeff_Hager , it works perfectly. Thank you 👍

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [April 26, 2024, 7:37am UTC](https://community.glideapps.com/t/copy-paste-value-from-database-to-another-by-submitting-a-form/72702/4 "2024-04-26T07:37:17Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.