Action : Add a new row in Table A by using the values from Table B row

[jaichith]

Dear friends, 

      There are 2 tables - Table A, Table B

I wish to add a new row in Table A by using the values from Table B row.  but that particular action should be in  table A UX not in Table B UX. ( I don't think below type of action would help since actions appears in table B UX . Action Type  : Add a new row to another table using values from this row).

What would be the appropriate method to be applied for my case?

[WillowMobileSys]

The action will show on the Table A views so you should be good.

Sorry, Table A is the target and Table B is the source but you want the action to show in Table A.  By default the action will show on the source table (Table B) rows.

[jaichith]

What type of action to be used here ? 

[WillowMobileSys]

If you were place the action on Table B (even if possible), how would you specify which Table A row to use as the source row?

It might help to explain your use case. 

The typical usage for action type "Add a new row to another table using values from this row" is that the action is reflected on EACH row of the SOURCE table.  This is so when you tap the action, the row from where you tapped it is automatically assigned as the source row.

The method of having an action on your target table requires that a source row would need to be selected.  This is probably possible.  I am not sure if the INPUT() function would be of use here.  If Not, you would need to add a table or possibly a Slice used to launch a Form that allows selection of the Table A row to use as the source row.