As above table having many to one relationship we can see as arrow, we are considering Mapping table as master table, All tables we have created Record type.
1. in one UI page used "Mapping table", and in that page we are selecting Country, Region and Category code. Entering textbox values of "Info table" and "Att table"
and clicking "Submit" button. We are getting error.
"function a!dropdownField [line 33]: An error occurred while executing a save: Expression evaluation error: Field with [identifier=9b2cef30-2e3c-4575-9e32-c9897a6dff7a] not found on the Record Type"
2. Here we need to insert same record in "Info table" and "Att table" once done then new both Ids need to insert in "Mapping table" how we can do in one go on click of submit button?
"The input "Records" cannot be created or updated. The relationship configuration between "Mapping table" and "Att table" is set to 'Do not allow updates'. Location of the error: " Mapping[1].Att table"
Please help me here to rectify this problem."
Discussion posts and replies are publicly visible
Hi,
For the first error, could you please share the code snippet of the dropdown field if it hasn't been fixed yet?
For the second error, make sure to enable write and delete related records in the relationship configuration. Refer to the screenshot below:
Thanks for your reply.
Please refer earlier attached snapshot, then you will get proper requirement. Since multiple tables entry values i need to insert in mapping table.
Okay. The first error could be due to a record type mismatch. Could you please check the 'save into' variable's record type to ensure it is referencing the correct record?
It would be helpful to decode the issue if you could share a screenshot of your code.
You are attempting to save all the field values of different types in a single rule input, 'ri!record,' which is not working as expected.
Since you are constructing the mapping details, create a rule input of type 'mapping record' and save the selected and entered inputs into that rule input.
1. PFA, you will more clarity
2. After entering all values, in some seconds values are being disappeared.
3. since Mapping table is master table, how will get newly inserted values ID for Att and Info table, because those 2 IDs need to save in Mapping table
Please guide me, highly appreciate.
What is the data type (record type) of the rule input mappingRI?Please review line 12, where the rule input in the 'value' parameter is referencing a different record ([M Country]), and the rule input in the 'save into' parameter is pointing to another record ([M Mapping]). This discrepancy is causing values to disappear.
Till now i did not got any proper solution for the same
adding to Mathurambika M, check the rule input in the drop down the choice labels and values are coming from country record and you are storing in the same record in the value. In the process model while you try to save if you have the primary key id then it will throw an error due to duplicate rows.
but Country record ID need to save in Mapping table not in country table
Then change the save into to Country record.
As i understand you have Country, region ,Category tables while selecting in the drop downs you need to store in the mapping table.
If this is the case then in the value and saveInto have the ri!mapping[recordType]. I guess it will solve your issue.
In the above screenshot the value and saveInto parameters are pointing to different fields. So once you select the value it will be disappeared