# How do I add values in Form to another table not being accessed from UI **URL:** \ **Category:** Ask for Help\ **Created:** [March 11, 2024, 9:49am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583 "2024-03-11T09:49:56Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 11, 2024, 9:49am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/1 "2024-03-11T09:49:56Z")
This might be a new doubt I Have a form (Not Custom) which currently adds values to different columns in Table A. I have one Text Field called “Options” This should write values to a column b in another table with name Table B. how will I be able to do this? As I see it I can only access Table A when I am writing values from UI. **I know Easiest way would be to add these columns to User table as we can access it anywhere.** **Is there a way I can access other table b?** Thank you in Advance for your help. Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 3:11am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/2 "2024-03-12T03:11:42Z")
Can anyone help me on this? Thank you in advance. Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 3:45am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/3 "2024-03-12T03:45:54Z")
> [@Dilip\_Adiga](#): > > I Have a form (Not Custom) Do you use “add form screen”? If yes, then you need to determine the table destination. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 3:59am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/4 "2024-03-12T03:59:34Z")
Thank you for replying. I use the ‘+’ button to add data. Currently all this is written to Table A. but one component needs to write Data into a column in Table b. I need to handle this scenario. Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 4:06am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/5 "2024-03-12T04:06:33Z")
> [@Dilip\_Adiga](#): > > but one component needs to write Data into a column in Table b OK, I misunderstood your request. You can first create a relationship from table A to table B and the column usc that you want to copy to table b. Then, you can add an “on submit” action to your column in table b. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 4:31am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/6 "2024-03-12T04:31:44Z")
I am little confused here. Can you elaborate a little more. Sorry New problem Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 4:43am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/7 "2024-03-12T04:43:58Z")
I hope you understand the example I provided. If you want to ask further, I need you to describe it in your case. ![Screenshot 2024-03-12 at 11.40.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16a602837f9aa0b82c540bcf21f64b21682bdfdd.png) ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 5:06am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/8 "2024-03-12T05:06:53Z")
I got the approach you suggested. I cant create any relationship between table A and Table B. Table B is a table where I am storing choice component values in each columns. There might be 10-15 columns having choice values for different types. I need to write value to a column in Table B. This is my issue. Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 5:14am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/9 "2024-03-12T05:14:21Z")
Then why do you need to add a value to table B? Can you explain what Table A is in your case? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 5:17am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/10 "2024-03-12T05:17:40Z")
Basically Table A has columns taking in different values. In The UI there are different components All these write the value to Table A One of the component is a choice component This Choice component gets value from Table B Now I need the user to be able to also Write Values to Table B column where it stores these values. This is the reason I need to have it reference Table B. Let me know if you got my doubt. Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 5:22am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/11 "2024-03-12T05:22:36Z")
If you cannot establish a relationship between table A and table B, what if you start from table B instead of table A? In other words, table A becomes the destination. Another way is to fill it into the user table first. This method is usually easy to grab the value back to place it anywhere. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 5:30am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/12 "2024-03-12T05:30:50Z")
Yeah, I thought if doing the user table approach as it is accessible anywhere. But was little hesitant as I thought it would not be clean. Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 5:39am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/13 "2024-03-12T05:39:20Z")
I think maybe for the progressive columns in table B can be moved to table A. This might reduce complexity. Your choice component can still fetch its value from table A. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 5:41am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/14 "2024-03-12T05:41:27Z")
You mean I write and fetch values for the choice component in Table A itself, rather than moving it to another table? Regards, Dilip ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [March 12, 2024, 5:43am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/15 "2024-03-12T05:43:30Z")
This is just my idea. I don’t know your exact condition. But I did that in my case. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 12, 2024, 5:50am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/16 "2024-03-12T05:50:16Z")
Got it, Thank you for the idea. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 13, 2024, 12:00am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/17 "2024-03-13T00:00:48Z")
I still don’t understand the problem here. If you only need to add a value to a column in table B everytime a row is added to table A, you can just have an “Add Row” action to table B? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 13, 2024, 3:08am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/18 "2024-03-13T03:08:32Z")
Thank you for the reply ThinhDinh, By requirement is There is a Text Entry in my UI, When user enters some string there only in that case it should write the value to column in Table B. its a only if case when user enters text in that input. Not every time user will choose to input in that field. Also to give you more context, Table B has all my choice values written in each column. I use around 10 Choice fields and each of the values of choice fields are being fetched from Table B. So writing a row I dont think will work in my case. Regards, Dilip ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 13, 2024, 10:40am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/19 "2024-03-13T10:40:34Z")
> [@Dilip\_Adiga](#): > > By requirement is There is a Text Entry in my UI, When user enters some string there only in that case it should write the value to column in Table B. > > its a only if case when user enters text in that input. > > Not every time user will choose to input in that field. So you can just trigger the action when the condition “field X” is not empty is satisfied? > [@Dilip\_Adiga](#): > > Also to give you more context, Table B has all my choice values written in each column. I use around 10 Choice fields and each of the values of choice fields are being fetched from Table B. So writing a row I dont think will work in my case. I’m not sure how this relates to the context. Are you writing a new choice to that table? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [March 13, 2024, 10:51am UTC](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583/20 "2024-03-13T10:51:42Z")
Hi, Yes , when I input a value in that field. It means I am entering new choice to it. Regards, Dilip [Next page](https://community.glideapps.com/t/how-do-i-add-values-in-form-to-another-table-not-being-accessed-from-ui/71583.md?page=2)