Need to add row to grid but here the challenge is I have multiple languages available for each row so how to achieve it?

Question

I have table by name abc which have columns id(pk),refId(FK),uniqueId,languageId,location

here language Id is : id for languages ex: english =1 , french=2, hindi=3 etc

unique id is: if say for refId(fk) there are 5 location then unique id is 1,2,3,4,5 for language id 1, unique id is 1,2,3,4,5 for language id 2, unique id is 1,2,3,4,5 for language id 3 etc

so here my requirement is based on selection of ref Id I want to add location using grid but here challenge is user can allow to add location in all available languages and need to maintain uniqueid's same.
one thing need to consider is unique Id should be the next number to existing unique id for that particular refId.

Please do help, am struggling to implement it.

vamshik4570 · Accepted Answer

where i wii get this document Appian 20.3 Developer Skills Practice Guide for download

dimitriss5700 · Answer

It looks like you need to build something like a decision table and based on the refId, languageId and the previous uniqueId that you will pass as input parameters into the decision table, you will get back the uniqueID.

You can have a look here of how to build a decision table:

https://docs.appian.com/suite/help/22.3/Appian_Decisions.html

Appian 20.3 Developer Skills Practice Guide for download

Appian 20.3 Developer Skills Practice Guide for download

Sign up

Login with SSO

Login to the community

Login with SSO