0
Create new record in another table and transfer all fields across
Hi,
I have created a table that I am using as a "kiosk" type function where external parties can enter their form details. Once they click on a button called "Sign In" I want that data to transfer across to another table.
let newRecord := (create 'TRANSFER LOG');
newRecord.('SIGN IN OUT' := 1);
this.('TRANSFERRED FROM' = newRecord.'Transferred from:')
The SIGN IN OUT part works
But I can't get the other fields to carry across.
Ideally onclick of a button I would like to:
- create a newRecord in the table 'TRANSFER LOG'
- then carry all the data inputted in the table called: 'SIGN IN' to the table: 'TRANSFER LOG'
- I have set up all the fields so they correspond
Any help would be very much appreciated.
2 replies
-
Hi You are nearly there. I'd save the 'SIGN IN' table to a variable first and then use that in the subsequent transfers
let signIn := this; let newRecord := (create 'TRANSFER LOG'); newRecord.('SIGN IN OUT' := 1); newRecord.('Transferred from:' := signIn.'TRANSFERRED FROM'); newRecord.(nextField := signIn.nextField); And so on...
Regards John
-
Works perfectly. Thank you!
Content aside
- Status Answered
- 1 mth agoLast active
- 2Replies
- 57Views
-
2
Following