How can I add the values of my [message] from one table to another table that will add the values in the rows of that new table

[Audit_CKGoC]

[Aurelien · Accepted solution]

Hi @Audit_CKGoC

The question is unclear to me.
Do you think about this action type ?

[Audit_CKGoC]

yes i have tried already. but its not working. do you think this behavior can perform a certain action to a large number of data processing?

[Audit_CKGoC]

can you help me check if this is correct. I want transfer all the values in the [message] from my table mp_l_preownership to the table doc_t_sms_sent column [message].

[Aurelien]

Hi @Audit_CKGoC

This looks correct to me.
I would add the UNIQUEID() expression for the key_column as well, unless you have set it yet with an initial value.

Then, in order to apply this action to a set of rows, you may want to use this action too (here is an example):

For reference:

help.appsheet.com

FILTER()

Select rows of table or slice

[Audit_CKGoC]

i would like to confirm my For a record of this table is the mp_l_preownership (where my data came from) and my referenced table is doc_t_sms_sent (destination table)?

[Aurelien]

This is the idea, indeed.
You may want to give it a try, in order to better understand how this works.

[Audit_CKGoC]

It is working now. but how can i make my key id in order? ive already set it to [_rownumber]-1 as initial value. its working if manually add. but if adding rows using bot it is not working.

[Aurelien]

Hi @Audit_CKGoC

You probably would want to set key_column initial value differently, or set the key_column on another column.

For information:

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …