# Form Choice Not Populating On Google Sheet When Submitted

**URL:** https://community.glideapps.com/t/form-choice-not-populating-on-google-sheet-when-submitted/73901
**Category:** Ask for Help
**Created:** [June 5, 2024, 6:20pm UTC](https://community.glideapps.com/t/form-choice-not-populating-on-google-sheet-when-submitted/73901 "2024-06-05T18:20:16Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)
#### Post date: [June 5, 2024, 6:20pm UTC](https://community.glideapps.com/t/form-choice-not-populating-on-google-sheet-when-submitted/73901/1 "2024-06-05T18:20:17Z")

</div>

I have a form on my app where I want my employees to clock in and out each day. I have a Google Sheet setup with these columns:

- Employee (populated by user email)
- Timestamp (populated by current date/time)
- Action (Supposed to be populated by choice field)
- Row ID (Auto generated on submission)

I set the form up where all the employee sees is the options of Clock In and Clock Out with the Submit button right below. When testing this, the data goes to the Google Sheets and shows the email, timestamp, and row ID, but not which of the choice options (clock in/out) that was selected.

Any ideas? Thanks in advance.

 ![GlideTimeForm-GoogleSheetScreen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd411938a67f252245b430e85ec8783d0393e819.jpeg)  
 ![GlideTimeForm-FormContainerScreen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/067eab4fd4cd39fc0079d3b831fcfdff381b6cbc.jpeg)  
 ![GlideTimeForm-ChoiceScreen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1af469f3252d145b2c4b7d9cf01834048586f991.jpeg)

---

<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: [June 5, 2024, 6:36pm UTC](https://community.glideapps.com/t/form-choice-not-populating-on-google-sheet-when-submitted/73901/2 "2024-06-05T18:36:58Z")

</div>

You are setting Action as an Additional Column value on the form. Do not set that because Action will come from the choice component instead.

The way you have it set now, it is going to overwrite the Action set by the choice component with the action in the parent row that the screen containing the form container is attached to.

---

<div class="post-metadata">

### Author: ![mustangTC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mustangtc/32/91321_2.png) [@mustangTC](https://community.glideapps.com/u/mustangTC)
#### Post date: [June 5, 2024, 7:04pm UTC](https://community.glideapps.com/t/form-choice-not-populating-on-google-sheet-when-submitted/73901/3 "2024-06-05T19:04:00Z")

</div>

That worked perfect, thanks!

---

<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: [June 12, 2024, 7:04pm UTC](https://community.glideapps.com/t/form-choice-not-populating-on-google-sheet-when-submitted/73901/4 "2024-06-12T19:04:14Z")

</div>

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