# How to enter multiple values in one field **URL:** \ **Category:** Ask for Help\ **Created:** [January 13, 2020, 7:30pm UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574 "2020-01-13T19:30:16Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [January 13, 2020, 7:30pm UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/1 "2020-01-13T19:30:16Z")
I’m building an app to track costs per customer. It tracks hours spent and expenses incurred per customer. Each customer has a Customer Code. My employees often travel to more than one customer site in a single trip. For this reason, I need to be able to track multiple Company Codes per Trip. I have both a Trip Sheet and Accounts Sheet in my Google Sheets file. Per Trip, I need to be able to capture and display multiple Customer Codes. When a detail view of a trip is opened, I need to be able to display the multiple Customer Codes involved on the Trip. What is the best way to do that? ---
**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:** [January 13, 2020, 7:46pm UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/2 "2020-01-13T19:46:08Z")
The easiest might be just a notes component and the user can type in multiple values. In my opinion, the better way would be to have a form button inside your trip details. The user will open the form, enter the customer code, and submit it to a third sheet that contains a Trip ID and the Customer Code. Then you can set up a relation in the Trip sheet to link the Trip ID to the Trip ID in the new Trip ID/Customer Code form response sheet. That way you can display all of the customer codes as an inline list inside the trip details page. ---
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [January 13, 2020, 7:56pm UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/3 "2020-01-13T19:56:08Z")
Thank you sir. I will try that approach. ---
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [January 16, 2020, 8:03pm UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/4 "2020-01-16T20:03:00Z")
That did it! Thanks for the help. ---
**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\ **Post date:** [June 4, 2023, 5:01am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/5 "2023-06-04T05:01:13Z")
OK. To extend thinking, can you pass the customer code to the form … i.e. not have to key it? e.g. Add a notes table in a CRM record (another tab) that auto adds the customer id as a table column value so notes can be filtered to just show that customer’s notes. ---
**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:** [June 4, 2023, 5:10am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/6 "2023-06-04T05:10:53Z")
Yes, you can do that. Exactly how you do it depends on your starting point. For example if you’re viewing a client detail screen, then you should be able to open a form from there and pass the client ID as a column value with the form submission. If you’re in some other context, you may need to add a choice component to your form and ask the user to select from a list of clients. ---
**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\ **Post date:** [June 4, 2023, 8:10am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/7 "2023-06-04T08:10:45Z")
Darren I tried that. But On Sumit Set Column Value doesn’t solve the issue of passing the Client ID to the Form. Only values available are User Profile, Custom, or current Sheet values. Notes go in the Notes Sheet. The Client ID is in the Clients Sheet and the Notes Form has to open from the Clients Edit Screen How do I get the Client Id from the current Clients record? ---
**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:** [June 4, 2023, 8:50am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/8 "2023-06-04T08:50:47Z")
> [@gbigelowtutordoctor](#): > > I tried that. But On Sumit Set Column Value doesn’t solve the issue of passing the Client ID to the Form. I didn’t say onSubmit, I said a column value that gets passed with the form. > **[Column Values | Glide Docs](https://www.glideapps.com/docs/reference/values/column-values#column-values-in-submission-screens)** > > Column values are the values contained in your data source tables. But as I also said, that will only work if your starting point is the client details screen. What is your starting point? ---
**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\ **Post date:** [June 4, 2023, 9:56am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/9 "2023-06-04T09:56:35Z")
Need to be able to do it from both Client Details and Edit screen. When I add Form button and set as Show form screen there is no option to set column values for the form, Notes columns, only for the Client columns, Where do you set " a column value that gets passed with the form"? ---
**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:** [June 4, 2023, 10:26am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/10 "2023-06-04T10:26:26Z")
When you have the form open, look for the “Values from Screen” group in the components: ![CleanShot 2023-06-04 at 18.24.02@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e33a3d224064406b34eee84aeb07dbff38acee84.jpeg) You should be able to use any column value from the table that’s attached to the screen where you launched the form from. ---
**Author:** ![gbigelowtutordoctor](https://avatars.discourse-cdn.com/v4/letter/g/9e8a1a/32.png) [@gbigelowtutordoctor](https://community.glideapps.com/u/gbigelowtutordoctor)\ **Post date:** [June 4, 2023, 11:03am UTC](https://community.glideapps.com/t/how-to-enter-multiple-values-in-one-field/3574/11 "2023-06-04T11:03:38Z")
OK. Got it. Thanks Darren