How do I add values in Form to another table not being accessed from UI

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

Can anyone help me on this?

Thank you in advance.

Regards,
Dilip

Do you use “add form screen”? If yes, then you need to determine the table destination.

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

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.

I am little confused here. Can you elaborate a little more.

Sorry New problem

Regards,
Dilip

I hope you understand the example I provided. If you want to ask further, I need you to describe it in your case.

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

Then why do you need to add a value to table B? Can you explain what Table A is in your case?

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

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.

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

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.

You mean I write and fetch values for the choice component in Table A itself, rather than moving it to another table?

Regards,
Dilip

This is just my idea. I don’t know your exact condition. But I did that in my case.

Got it, Thank you for the idea.

1 Like

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?

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

So you can just trigger the action when the condition “field X” is not empty is satisfied?

I’m not sure how this relates to the context. Are you writing a new choice to that table?

Hi,

Yes , when I input a value in that field. It means I am entering new choice to it.

Regards,
Dilip