I am building an app that has to do with some operation of payments. I have added a button in details view where i can do payments related to that row values. Also i have given a button that goes to form view for editing that row. There i need to place related payments for entering new payments from form itself.
Create a slice named New payments on the existing payments table. The slice should allow adds only and not updates or deletes. The row filter expression should be FALSE (which means the slice will have no rows).
In the table associated with the form the user is filling out, modify the existing Related … virtual column that refers to payment records to: (1) rename it to Related New payments; (2) change the first argument of REF_ROWS() in its App formula to “New payments”; and (3) delete the column’s Description value entirely.
Save the config changes. AppSheet should recreate the Related … virtual column you repurposed while retaining the changes you made. If so, good!
In the form view, remove the original Related … column but add the new Related New payments column.
