I have two records. I prepared the data attached. The records are: one is LTM GROUP and the other is LTM USER. Both are related records.
I have heard that we can store data in the base and related child record in one shot.
As GroupId is the primary key in LTM Group (autogenerated), plus LTM User has a foreign key named userGroupId, and obviously, this table also has a primary key userId which is autogenerated.
Can you please help me with storing data in tables with the help of writing records in a single shot?
/*Group*/ { recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 25, LTM Group.name : "Admin", LTM Group.updatedby : "rt343", LTM Group.addedby : "rt343", LTM Group.dateadded : fn!date(2025, 2, 25), LTM Group.disabled : false ), recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 26, LTM Group.name : "RTR User", LTM Group.updatedby : "rt567", LTM Group.addedby : "rt567", LTM Group.dateadded : fn!date(2025, 2, 25), LTM Group.disabled : false )}, /* User */ { recordType!LTM USER( LTM User Detail.applicationkey : 1, LTM User Detail.appianGroupKey : 25, LTM User Detail.module : "rt567", LTM User Detail.username : "Abhi", LTM User Detail.disabled : false, LTM User Detail.updatedby : "hdfgd", LTM User Detail.addedby : "hdfdf", LTM User Detail.status : "true", LTM User Detail.dateadded : fn!date(2025, 2, 25) ), recordType!LTM USER( LTM User Detail.applicationkey : 1, LTM User Detail.appianGroupKey : 25, LTM User Detail.module : "ak94718", LTM User Detail.username : "Arman", LTM User Detail.disabled : false, LTM User Detail.updatedby : "rt567", LTM User Detail.addedby : "rt567", LTM User Detail.status : "true", LTM User Detail.dateadded : fn!date(2025, 2, 25)) }
Discussion posts and replies are publicly visible
This might be helpful
https://docs.appian.com/suite/help/24.4/manage-record-data.html#create-records-and-related-records