i have a problem when add the new record using the record action , when i want to add the new record the record does not added to data base and the grid please help
{ a!sectionLayout( label: "", contents: { a!billboardLayout( backgroundMedia: a!webImage( source: "https://static.pointcheckout.com/16cd7c7425e54498/original" ), backgroundColor: "#f0f0f0", height: "MEDIUM_PLUS", marginBelow: "NONE" ), a!gridField( label: "", labelPosition: "ABOVE", data: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit', columns: { a!gridColumn( label: "Deposit Id", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c27cd643-e617-46e3-a4dd-c16df94bbed2}idDeposit', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c27cd643-e617-46e3-a4dd-c16df94bbed2}idDeposit'], align: "CENTER", ), a!gridColumn( label: "Account Id", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{fd8c420d-ca89-4ef3-8269-f871e713b3e4}idAccount', value: a!linkField( links: { a!recordLink( label: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{fd8c420d-ca89-4ef3-8269-f871e713b3e4}idAccount'], recordType: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit', identifier: fv!identifier ) } ), align: "CENTER" ), a!gridColumn( label: "Customer Id", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{f701f00d-ee33-4307-8aac-0d6d16c31657}idCustomer', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{f701f00d-ee33-4307-8aac-0d6d16c31657}idCustomer'], align: "CENTER" ), a!gridColumn( label: "Branch Id", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{cca2a98a-8d37-47cf-96ce-32e076077459}idBranch', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{cca2a98a-8d37-47cf-96ce-32e076077459}idBranch'], align: "CENTER" ), a!gridColumn( label: "Deposit Amount", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{bd691a2f-841a-4876-9779-78490577481d}depositAmount', value: if( isnull(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{bd691a2f-841a-4876-9779-78490577481d}depositAmount']), fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{bd691a2f-841a-4876-9779-78490577481d}depositAmount'], fixed(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{bd691a2f-841a-4876-9779-78490577481d}depositAmount'], 2) ), align: "CENTER" ), a!gridColumn( label: "Currency Code", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6da19d7c-f1cb-4608-94e7-d0118b8b131f}currencyCode', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6da19d7c-f1cb-4608-94e7-d0118b8b131f}currencyCode'], align: "CENTER" ), a!gridColumn( label: "Multi Balance", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{d396a4c7-7424-4f11-ac5d-565aa6d8ddaf}multiBalance', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{d396a4c7-7424-4f11-ac5d-565aa6d8ddaf}multiBalance'], align: "CENTER" ), a!gridColumn( label: "Interest Acc Type", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{3ad6f1e5-8d62-43dd-bbfc-da1b44d11052}interestAccType', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{3ad6f1e5-8d62-43dd-bbfc-da1b44d11052}interestAccType'], align: "CENTER" ), a!gridColumn( label: "Interest Rate", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{e59bb56b-a1c8-4ba0-8aeb-1b482036308a}interestRate', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{e59bb56b-a1c8-4ba0-8aeb-1b482036308a}interestRate'], align: "CENTER" ), a!gridColumn( label: "Renewal States", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{a29cc8cf-975c-4177-b8c5-2802cfcf72ae}renewalStates', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{a29cc8cf-975c-4177-b8c5-2802cfcf72ae}renewalStates'], align: "CENTER" ), a!gridColumn( label: "Renewal End Date", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{46941675-d8bb-4e8f-9ccd-df20ddd039f3}renewalEndDate', value: if( isnull(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{46941675-d8bb-4e8f-9ccd-df20ddd039f3}renewalEndDate']), fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{46941675-d8bb-4e8f-9ccd-df20ddd039f3}renewalEndDate'], datetext(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{46941675-d8bb-4e8f-9ccd-df20ddd039f3}renewalEndDate'], "default") ), align: "CENTER" ), a!gridColumn( label: "Deposit Period Type", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{4110249f-7152-46d0-af6d-3c30792b7e1c}depositPeriodType', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{4110249f-7152-46d0-af6d-3c30792b7e1c}depositPeriodType'], align: "CENTER" ), a!gridColumn( label: "Deposit Days", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{a106702b-1902-4da8-a5ed-03d4a523b557}depositDays', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{a106702b-1902-4da8-a5ed-03d4a523b557}depositDays'], align: "CENTER" ), a!gridColumn( label: "Number Of Weeks", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{443f765e-2883-47ec-8277-415b799fb8d4}numberOfWeeks', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{443f765e-2883-47ec-8277-415b799fb8d4}numberOfWeeks'], align: "CENTER" ), a!gridColumn( label: "Number Of Months", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{363cbe3c-508b-4f3d-8835-df5ba4c6d436}numberOfMonths', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{363cbe3c-508b-4f3d-8835-df5ba4c6d436}numberOfMonths'], align: "CENTER" ), a!gridColumn( label: "Number Of Years", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{7eac283d-3cd3-4611-9edf-87582eecd374}numberOfYears', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{7eac283d-3cd3-4611-9edf-87582eecd374}numberOfYears'], align: "CENTER" ), a!gridColumn( label: "To Date", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6a9bbfa5-e819-4364-b8d5-36b6b59b9fc0}toDate', value: if( isnull(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6a9bbfa5-e819-4364-b8d5-36b6b59b9fc0}toDate']), fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6a9bbfa5-e819-4364-b8d5-36b6b59b9fc0}toDate'], datetext(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6a9bbfa5-e819-4364-b8d5-36b6b59b9fc0}toDate'], "default") ), align: "CENTER" ), a!gridColumn( label: "New Deposit Period Type", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{4bafd1e3-373c-443a-8d43-f1b35d47bc70}newDepositPeriodType', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{4bafd1e3-373c-443a-8d43-f1b35d47bc70}newDepositPeriodType'], align: "CENTER" ), a!gridColumn( label: "New Deposit Days", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{fdbdd365-d1f2-4c94-88dc-26b1899c92a6}newDepositDays', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{fdbdd365-d1f2-4c94-88dc-26b1899c92a6}newDepositDays'], align: "CENTER" ), a!gridColumn( label: "New Number Of Weeks", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c227c224-4e2b-42f4-a8c9-768f18aa20e5}newNumberOfWeeks', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c227c224-4e2b-42f4-a8c9-768f18aa20e5}newNumberOfWeeks'], align: "CENTER" ), a!gridColumn( label: "New Number Of Months", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{9f170f63-d9f3-49ca-bb1d-5e6af7adf4cd}newNumberOfMonths', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{9f170f63-d9f3-49ca-bb1d-5e6af7adf4cd}newNumberOfMonths'], align: "CENTER" ), a!gridColumn( label: "New Number Of Years", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{90f31a32-f366-4cc9-be81-c7c453d66061}newNumberOfYears', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{90f31a32-f366-4cc9-be81-c7c453d66061}newNumberOfYears'], align: "CENTER" ), a!gridColumn( label: "New To Date", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{0713d031-d022-49c5-95c5-684c2427b50f}newToDate', value: if( isnull(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{0713d031-d022-49c5-95c5-684c2427b50f}newToDate']), fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{0713d031-d022-49c5-95c5-684c2427b50f}newToDate'], datetext(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{0713d031-d022-49c5-95c5-684c2427b50f}newToDate'], "default") ), align: "CENTER" ), a!gridColumn( label: "Added On", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{2f88040c-5df2-453d-b1c9-5bd8e84802c9}addedOn', value: if( isnull(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{2f88040c-5df2-453d-b1c9-5bd8e84802c9}addedOn']), fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{2f88040c-5df2-453d-b1c9-5bd8e84802c9}addedOn'], datetext(fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{2f88040c-5df2-453d-b1c9-5bd8e84802c9}addedOn'], "default") ), align: "CENTER" ), a!gridColumn( label: "Added By", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{1a869463-2038-463b-aa29-c39fa0cd6a52}addedBy', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{1a869463-2038-463b-aa29-c39fa0cd6a52}addedBy'], align: "CENTER" ), a!gridColumn( label: "Updated By", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{b551bf70-3d12-492c-88c8-a58537c57dfe}updatedBy', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{b551bf70-3d12-492c-88c8-a58537c57dfe}updatedBy'], align: "CENTER" ), a!gridColumn( label: "Updated On", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{d9c34d44-e287-4060-8e8b-cb993f7975dc}updatedOn', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{d9c34d44-e287-4060-8e8b-cb993f7975dc}updatedOn'], align: "CENTER" ) }, selectable: false, validations: {}, borderStyle: "STANDARD", refreshAfter: "RECORD_ACTION", showSearchBox: false, showRefreshButton: true, recordActions: { a!recordActionItem( action: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.actions.{5c7a858f-8b64-4c5c-b2d3-0afc0c4cc59e}newDeposit' ) } ) } ) }
Discussion posts and replies are publicly visible
and this is the code for the new record
a!localVariables( local!branchValue, local!customerAccount, local!customerid, /*define the local variable that i want to put in the drop down*/ local!branchesName:rule!RDA_GetAllBranchName(), local!customerdata: rule!RDA_SearchBranchAccount(), /*to get the type of period */ local!depositperiodtype:rule!RDA_GetPeriodAccountType(), local!depositperiodtypeNew, local!multibalance, local!ledgercode, local!inseraccount, local!renwalstatus, local!newdepositperiod, local!DebitValueDate, /*make the local variable for all the field on the deposit Detalis*/ local!depositday, local!numberofweek, local!numberofmonth, local!numberofyear, /*create the local for the deposit amount*/ local!depositAmount, local!ledger:rule!RDA_ToGetLedger(), /*to get the value from the query and put it in drop down*/ local!multiBalancenew:rule!RDA_ToGetMultiBalance(), /*to get the rule for the account type*/ local!accountType:rule!RDA_ToGetAccountType(), local!accountTypeNew, /*to get the renwal status*/ local!renwal:rule!RDA_ToGetRenwalStatus(), local!renwalNew, /* To get the Balncing Period*/ local!BalancingPeriod:rule!RDA_ToGetBalancingPeriod(), local!BalancingPeriodNew, /*to get the new deposit period type*/ local!depositperiodtypeanother:rule!RDA_ToGetNewPeriodType(), local!depositperiodtypeanothernew, local!fortraicreate:false(), /*Query to get the customer from the branch and accout*/ /*if statment to check the query*/ local!customerdatanew:rule!RDA_getCustomerDetailsFromAccountAndBranch( branchid:local!branchValue, accountnum: local!customerAccount), /*call another query to call for the account*/ local!customerAccountDetalis:rule!RDA_toGetAllAccountForCustomer( branchid:local!branchValue, accountnum: local!customerAccount), local!showboxinfo:true, local!noFiltersApplied: all(fn!isnull, {local!branchValue, local!customerAccount}), a!formLayout( label: "", contents: { a!sectionLayout( label: "New Deposit Request", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Branches", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!branchesName['recordType!{c5841245-4826-4ef2-a3d8-a5407a445edb}RDA Branch.fields.{5fa864a0-4174-4956-875e-dbffadf0e323}nameInArabic'], choiceValues: local!branchesName['recordType!{c5841245-4826-4ef2-a3d8-a5407a445edb}RDA Branch.fields.{bea07028-4c3d-4879-9f5d-7f425aaef187}idBranch'], /*To save the value to value*/ value: local!branchValue, saveInto: { local!branchValue, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{cca2a98a-8d37-47cf-96ce-32e076077459}idBranch'],local!branchValue), a!save(ri!Branche,local!branchValue) }, searchDisplay: "AUTO", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Customer Account", labelPosition: "ABOVE", /*to save the value in the customer account*/ value:local!customerAccount, saveInto:{ local!customerAccount, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{fd8c420d-ca89-4ef3-8269-f871e713b3e4}idAccount'],local!customerAccount), a!save(ri!customer,local!customerAccount) }, refreshAfter: "UNFOCUS", required: true, validations: { if ( len(tostring(local!customerAccount))=7, null, "The account number must to be 7 numbers" ) } ) } ) }, marginAbove: "STANDARD", marginBelow: "STANDARD", stackWhen: { "NEVER" }, showDividers: false ) }, isCollapsible: false, isInitiallyCollapsed: false, divider: "ABOVE", dividerWeight: "MEDIUM", marginAbove: "NONE" ), a!boxLayout( label: "Customer Info", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Name", labelPosition: "ABOVE", value: local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{e25eb830-c2fd-44fb-9114-4d2ee04f92cb}customerName'], saveInto: {local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{e25eb830-c2fd-44fb-9114-4d2ee04f92cb}customerName']}, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Customer Type", labelPosition: "ABOVE", value: local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{9c3e790e-02c5-4ded-8186-2d6e91ab3421}customerType'], saveInto: {local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{9c3e790e-02c5-4ded-8186-2d6e91ab3421}customerType']}, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Customer Class", labelPosition: "ABOVE", value: local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{43ed8c48-c895-4af8-b85c-69eebfefb9b8}customerClass'], saveInto: {local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{43ed8c48-c895-4af8-b85c-69eebfefb9b8}customerClass']}, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "National Id", labelPosition: "ABOVE", value: local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{1d9fd47b-7bcd-4238-8b3f-c015a9ce29d0}nationalId'], saveInto: {local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{1d9fd47b-7bcd-4238-8b3f-c015a9ce29d0}nationalId']}, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Address", labelPosition: "ABOVE", value: local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{13a9f6f9-192f-4cc1-ae4a-68f48607e76c}customerAddress'], saveInto: {local!customerdatanew['recordType!{d6de57e4-91fc-44f8-8209-13222b53b9b4}RDA Customer.fields.{13a9f6f9-192f-4cc1-ae4a-68f48607e76c}customerAddress']}, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) } ) } ) }, showWhen: (a!isNotNullOrEmpty(local!customerAccountDetalis)), style: "#0000ff", marginBelow: "STANDARD" ), a!localVariables( local!selection, local!selectedAccount, { /*this section is for the choose debit account*/ a!sectionLayout( label: "Choose Debit Account", contents: { a!gridField( label: "", labelPosition: "ABOVE", data: rule!RDA_toGetAllAccountForCustomer( accountnum: local!customerAccount, branchid: local!branchValue ), columns: { /*Currency Code*/ a!gridColumn( label: "Currency Code", sortField: "currencycode", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.relationships.{5482bf40-6062-4e1c-9d2b-b11ad67a998e}rdaCurrency.fields.{0fe8e240-cc22-4a24-bccc-cec96bf11886}desAr'] ), /*Ledger*/ a!gridColumn( label: "Ledger", sortField: "ledger", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.relationships.{4f41b3e5-338c-4cc6-9720-a16664f67f1f}rdaLedger.fields.{58cfbfd2-89a5-4a80-9f46-1e72ace876b9}desAr'] ), /*ledger Code*/ a!gridColumn( label: "Ledger Code", sortField: "ledgercode", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.fields.{cf750e5c-be43-45fa-b4ca-21d193db4b14}ledgerCode'] ), /*Sub Account*/ a!gridColumn( label: "Sub Account", sortField: "subaccount", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.fields.{8877ae39-1845-458f-bb77-f68b9117f843}subAccount'] ), /*Risk Limit*/ a!gridColumn( label: "Risk Limit", sortField: "risklimit", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.fields.{161271a2-7e64-4dbe-8458-38217e80106b}riskLimit'] ), /* Available Balance*/ a!gridColumn( label: "Available Balance", sortField: "availablebalance", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.fields.{758e56a3-8f73-4f61-bcac-83b70307b98f}avaiableBalance'] ), /*Dollar Equivalent*/ a!gridColumn( label: "Dollar Equivalent", sortField: "dollarequivalent", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.fields.{8f921c0b-188f-4502-b5d8-2040ecbbda5b}dollarEquivalent'] ), /*Account Restriction*/ a!gridColumn( label: "Account Restriction", sortField: "accountrestriction", value: fv!row['recordType!{47912efb-2bcc-46aa-8bb4-19ed6593ac5b}RDA Account.fields.{8b8b8c85-c7bf-4032-84a2-25fe8a65bccb}amountRestrication'] ) }, selectable: true, selectionValue: local!selection, selectionSaveInto: { local!selection, /* This save adds the full rows of data for items selected in the most recent user interaction to local!selectedEmployees. */ a!save(local!selectedAccount, append(local!selectedAccount, fv!selectedRows)), /* This save removes the full rows of data for items deselected in the most recent user interaction to local!selectedEmployees. */ a!save(local!selectedAccount, difference(local!selectedAccount, fv!deselectedRows)) }, validations: {} ) }, showWhen:and( a!isNotNullOrEmpty(local!customerAccountDetalis), or(isnull(local!selectedAccount), length(local!selectedAccount) = 0)) ), /*this section is for the create new deposit*/ a!sectionLayout( label: "", contents: { a!sectionLayout( label: "Create Deposit", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Debit Account", labelPosition: "ABOVE", /*to get the id for the account*/ value: index(local!selectedAccount,1,"null").idAccount, saveInto: {index(local!selectedAccount,1,"null").idAccount}, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) } ), a!columnLayout( contents: {} ), a!columnLayout( contents: {} ) } ) } ), a!localVariables( local!indexArray:index(local!selectedAccount,1,"null"), a!boxLayout( label: "Deposit Details", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Deposit Amount", labelPosition: "ABOVE", value:local!depositAmount, saveInto: {local!depositAmount, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{bd691a2f-841a-4876-9779-78490577481d}depositAmount'],local!depositAmount)}, refreshAfter: "UNFOCUS", required: true, validations: {if ( and(a!isNotNullOrEmpty(local!depositAmount),local!depositAmount<=local!indexArray.avaiableBalance), null(),"Deposit Amount can't be larger than avaiable Balance")} ) } ), /*put the local variable*/ a!localVariables( local!currencyname:rule!RDA_toGetCurrenyToGrid( idcurrency: local!indexArray.currencyCode ), a!columnLayout( contents: { a!textField( label: "Currency Code", labelPosition: "ABOVE", value: {local!currencyname['recordType!{5e9af92e-b260-4c13-96d7-220c915dbdf0}RDA Currency.fields.{0fe8e240-cc22-4a24-bccc-cec96bf11886}desAr']}, saveInto: {local!currencyname['recordType!{5e9af92e-b260-4c13-96d7-220c915dbdf0}RDA Currency.fields.{0fe8e240-cc22-4a24-bccc-cec96bf11886}desAr'], a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{6da19d7c-f1cb-4608-94e7-d0118b8b131f}currencyCode'],local!currencyname['recordType!{5e9af92e-b260-4c13-96d7-220c915dbdf0}RDA Currency.fields.{0efd6fec-d5be-4b2c-b3b6-5f98997494a3}idCurrency'])}, refreshAfter: "UNFOCUS", required: true, readOnly: false, disabled: true, validations: {} ) } )), a!columnLayout( contents: { a!dropdownField( label: "Ledger Code", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!ledger['recordType!{5929b5c3-a8c4-484b-8696-e9faf41672c2}RDA Ledger.fields.{58cfbfd2-89a5-4a80-9f46-1e72ace876b9}desAr'], choiceValues: local!ledger['recordType!{5929b5c3-a8c4-484b-8696-e9faf41672c2}RDA Ledger.fields.{fdfe8b26-5460-411d-8ae4-d424d2b35394}idLedger'], value: local!ledgercode, saveInto: {local!ledgercode, /*Note i must add the record to deposit field*/ /*a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit'.],local!ledger['recordType!{5929b5c3-a8c4-484b-8696-e9faf41672c2}RDA Ledger.fields.{fdfe8b26-5460-411d-8ae4-d424d2b35394}idLedger']*/ }, searchDisplay: "AUTO", required: true, validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Multi Balance", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels:local!multiBalancenew['recordType!{35a006ad-f483-48bd-80b6-c1b13b2c47ba}RDA MultiBalance.fields.{82fd9ea7-64aa-48de-ba1a-851a614a1225}desAr'], choiceValues:local!multiBalancenew['recordType!{35a006ad-f483-48bd-80b6-c1b13b2c47ba}RDA MultiBalance.fields.{0d72a1bb-566f-4d09-95da-532bd8fb0508}idMulti'], value:local!multibalance, saveInto: {local!multibalance, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{d396a4c7-7424-4f11-ac5d-565aa6d8ddaf}multiBalance'],local!multibalance)}, searchDisplay: "AUTO", required: true, validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Balancing Period", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!BalancingPeriod['recordType!{938dd1e7-6927-40e5-b533-4e0bc681d0d8}RDA BalancingPeriod.fields.{d5125e1d-123a-40c4-ac71-69aac9b14171}desAr'], choiceValues: local!BalancingPeriod['recordType!{938dd1e7-6927-40e5-b533-4e0bc681d0d8}RDA BalancingPeriod.fields.{d50a0cd9-e01e-4b71-a73d-ad1080b4fb24}idBalance'], value: local!BalancingPeriodNew, /*saveInto: {local!BalancingPeriodNew,a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit'.])},*/ searchDisplay: "AUTO", showWhen: if (and(a!isNotNullOrEmpty(local!multiBalance),local!multibalance=1),true(),false()), required: true, validations: {} ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Interest Acc. Type", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!accountType['recordType!{3d0d8567-be8e-4c60-b4da-442d4f41a9e5}RDA AccountType.fields.{2a8b50f1-47ad-4fff-b8ee-48490a19d1b3}desAr'], choiceValues:local!accountType['recordType!{3d0d8567-be8e-4c60-b4da-442d4f41a9e5}RDA AccountType.fields.{2d55516f-64ff-44b0-951c-a1af993429bf}idType'], value:local!accountTypeNew, saveInto: {local!accountTypeNew, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{3ad6f1e5-8d62-43dd-bbfc-da1b44d11052}interestAccType'],local!accountTypeNew)}, searchDisplay: "AUTO", required: true, validations: {} ) } ), a!columnLayout( contents: { a!dateField( label: "Debit Value Date", labelPosition: "ABOVE", value: local!DebitValueDate, saveInto: {local!DebitValueDate }, required: true, validations: {} ) } ), a!columnLayout( contents: { a!dateField( label: "Credit Value Date", labelPosition: "ABOVE", saveInto: {}, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Interest Rate", labelPosition: "ABOVE", value:ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{e59bb56b-a1c8-4ba0-8aeb-1b482036308a}interestRate'], saveInto: {ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{e59bb56b-a1c8-4ba0-8aeb-1b482036308a}interestRate']}, refreshAfter: "UNFOCUS", required: true, disabled: false, masked: true, validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Renewal States", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels:local!renwal['recordType!{c0d08a29-b611-4b18-ac15-87ab629405b1}RDA RenwalStatus.fields.{b56ad68c-ba47-4501-813e-ac7f71fb58b2}desAr'], choiceValues:local!renwal['recordType!{c0d08a29-b611-4b18-ac15-87ab629405b1}RDA RenwalStatus.fields.{d721a2a7-64b8-4272-89e7-a9b3bd2acaca}idRenwal'], value:local!renwalNew, saveInto: {local!renwalNew, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{a29cc8cf-975c-4177-b8c5-2802cfcf72ae}renewalStates'],local!renwalNew)}, searchDisplay: "AUTO", required: true, validations: {} ) } ), a!columnLayout( contents: { a!dateField( label: "Renewal End Date", labelPosition: "ABOVE", value: ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{46941675-d8bb-4e8f-9ccd-df20ddd039f3}renewalEndDate'], saveInto: {ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{46941675-d8bb-4e8f-9ccd-df20ddd039f3}renewalEndDate']}, disabled: a!match( value: local!renwalNew, equals: 1, then: {true()}, equals:2 , then: {false()}, equals:3, then: {false()}, equals: null, then: {false()}, default: {false()} ), validations: {} ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Deposit Period Type", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!depositperiodtype['recordType!{7d2e1940-011b-44e9-a362-e365c9aaa76b}RDA DepositPeriodType.fields.{d507b859-5ec9-4aa8-a710-f40cdccd3217}desAr'], choiceValues: local!depositperiodtype['recordType!{7d2e1940-011b-44e9-a362-e365c9aaa76b}RDA DepositPeriodType.fields.{b5d1dcf1-6c37-436e-b15a-dd4a56aa117b}idPeriod'], value:local!depositperiodtypeNew, saveInto: {local!depositperiodtypeNew,a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{4110249f-7152-46d0-af6d-3c30792b7e1c}depositPeriodType'],local!depositperiodtype['recordType!{7d2e1940-011b-44e9-a362-e365c9aaa76b}RDA DepositPeriodType.fields.{b5d1dcf1-6c37-436e-b15a-dd4a56aa117b}idPeriod'])}, searchDisplay: "AUTO", required: true, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Deposit Days", labelPosition: "ABOVE", value: a!match( value:local!depositperiodtypeNew, equals: 1, then: {local!depositday}, /*we must take the local varaible of the weeks and calculate*/ equals: 2, then: {if(a!isNotNullOrEmpty(local!numberofweek),local!numberofweek*7,{})}, equals: 3, then: {if (a!isNotNullOrEmpty(local!numberofmonth),local!numberofmonth*30,{})}, equals: 4, then: {if (a!isNotNullOrEmpty(local!numberofyear),local!numberofyear*356,{})}, equals: null, then: {null()}, default: {null()} ), saveInto: {local!depositday, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{a106702b-1902-4da8-a5ed-03d4a523b557}depositDays'],local!depositday) }, refreshAfter: "UNFOCUS", required: a!match( value:local!depositperiodtypeNew, equals: 1, then: {true()}, equals: 2, then: {false()}, equals: 3, then: {false()}, equals: 4, then: {false()}, equals: null, then: {false()}, default: {false()} ), readOnly: false, disabled: a!match( value:local!depositperiodtypeNew, equals: 1, then: {false()}, equals: 2, then: {true()}, equals: 3, then: {true()}, equals: 4, then: {true()}, equals: null, then: {false()}, default: {false()} ), validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Number of Weeks", labelPosition: "ABOVE", value:a!match( value:local!depositperiodtypeNew, equals: 1, then: {if (a!isNotNullOrEmpty(local!depositday),local!depositday/7,{})}, /*we must take the local varaible of the weeks and calculate*/ equals: 2, then: {local!numberofweek}, equals: 3, then: {if(a!isNotNullOrEmpty(local!numberofmonth),local!numberofmonth/4,{})}, equals: 4, then: {if(a!isNotNullOrEmpty(local!numberofyear),local!numberofyear/52,{})}, equals: null, then: {null()}, default: {null()} ), /*there is an error if not handel that */ saveInto: {local!numberofweek, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{443f765e-2883-47ec-8277-415b799fb8d4}numberOfWeeks'],local!numberofweek)}, refreshAfter: "UNFOCUS", required: a!match( value:local!depositperiodtypeNew, equals: 1, then: {false()}, equals: 2, then: {true()}, equals: 3, then: {false()}, equals: 4, then: {false()}, equals: null, then: {false()}, default: {false()} ), disabled: /**/ a!match( value:local!depositperiodtypeNew, equals: 1, then: {true()}, equals: 2, then: {false()}, equals: 3, then: {true()}, equals: 4, then: {true()}, equals: null, then: {false()}, default: {false()} ), masked: false, /**/ validations: { null } ) } ), a!columnLayout( contents: { a!textField( label: "Number of Months", labelPosition: "ABOVE", value: /**/ a!match( value:local!depositperiodtypeNew, equals: 1, then: {if (a!isNotNullOrEmpty(local!depositday),local!depositday/30,{})}, /*we must take the local varaible of the weeks and calculate*/ equals: 2, then: {if (a!isNotNullOrEmpty(local!numberofweek),local!numberofweek/4,{})}, equals: 3, then: {local!numberofmonth}, equals: 4, then: {if(a!isNotNullOrEmpty(local!numberofyear),local!numberofyear*12,{})}, equals: null, then: {null()}, default: {null()} ), /**/ saveInto: {local!numberofmonth, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{363cbe3c-508b-4f3d-8835-df5ba4c6d436}numberOfMonths'],local!numberofmonth)}, refreshAfter: "UNFOCUS", required: a!match( value:local!depositperiodtypeNew, equals: 1, then: {false()}, equals: 2, then: {false()}, equals: 3, then: {true()}, equals: 4, then: {false()}, equals: null, then: {false()}, default: {false()} ), /**/ disabled: a!match( value:local!depositperiodtypeNew, equals: 1, then: {true()}, equals: 2, then: {true()}, equals: 3, then: {false()}, equals: 4, then: {true()}, equals: null, then: {false()}, default: {false()} ), /**/ validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Number of Years", labelPosition: "ABOVE", /*the value is*/ value: a!match( value:local!depositperiodtypeNew, equals: 1, then: {if(a!isNotNullOrEmpty(local!depositday),local!depositday/356,{})}, /*we must take the local varaible of the weeks and calculate*/ equals: 2, then: {if (a!isNotNullOrEmpty(local!numberofweek),local!numberofweek/52,{})}, equals: 3, then: {if (a!isNotNullOrEmpty(local!numberofmonth),local!numberofmonth/12,{})}, equals: 4, then: {local!numberofyear}, equals: null, then: {null()}, default: {null()} ), saveInto: {local!numberofyear, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{7eac283d-3cd3-4611-9edf-87582eecd374}numberOfYears'],local!numberofyear)}, refreshAfter: "UNFOCUS", required: a!match( value:local!depositperiodtypeNew, equals: 1, then: {false()}, equals: 2, then: {false()}, equals: 3, then: {false()}, equals: 4, then: {true()}, equals: null, then: {false()}, default: {false()} ), /**/ disabled: a!match( value:local!depositperiodtypeNew, equals: 1, then: {true()}, equals: 2, then: {true()}, equals: 3, then: {true()}, equals: 4, then: {false()}, equals: null, then: {false()}, default: {false()} ), /**/ validations: {} ) } ), a!columnLayout( contents: { a!dateField( label: "To Date", labelPosition: "ABOVE", saveInto: {}, validations: {} ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "New Deposit Period Type", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!depositperiodtypeanother['recordType!{9a877083-7599-4e2b-88c7-819dcf14ff35}RDA NewPeriodTypeAccount.fields.{de07381f-b7e4-4a33-a3d3-1fd53b8f4e36}desAr'], choiceValues: local!depositperiodtypeanother['recordType!{9a877083-7599-4e2b-88c7-819dcf14ff35}RDA NewPeriodTypeAccount.fields.{e7378ab6-b3c5-4594-9c44-d25fac7c4d1e}idNewperiod'], value:local!depositperiodtypeanothernew, saveInto: {local!depositperiodtypeanothernew, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{4bafd1e3-373c-443a-8d43-f1b35d47bc70}newDepositPeriodType'],local!depositperiodtypeanothernew)}, searchDisplay: "AUTO", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "New Deposit Days", labelPosition: "ABOVE", saveInto: {}, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "New Number of Weeks", labelPosition: "ABOVE", saveInto: {}, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "New Number of Months", labelPosition: "ABOVE", saveInto: {}, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "New Number of Years", labelPosition: "ABOVE", saveInto: {}, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!dateField( label: "To Date", labelPosition: "ABOVE", saveInto: {}, validations: {} ) } ) } ) }, style: "#0000ff", isCollapsible: false, marginBelow: "STANDARD" )), a!localVariables( local!dataGridEdit, a!boxLayout( label: "Document Details", contents: { a!localVariables( /* * local!employees is provided in this recipe as a way to start with hard-coded * data. However, this data is identical to the data created from the entity-backed * tutorial. Replace the hard-coded data with a query to the employee data store * entity and all of the employee records from the tutorial will appear. * * To replace this data with your own, replace (ctrl+H or cmd+H) all references to * local!employees with your data source, either via rule input or local variable. */ local!originalString: tostring(loggedInUser()), local!dotCharacter: ".", local!spaceCharacter: " ", /* sojood barham@experts ps */ local!addedBy2: substitute(local!originalString, local!dotCharacter, local!spaceCharacter), local!dotCharacter2: " barham@experts ps", local!spaceCharacter2: "", local!addedBy: substitute(local!addedBy2, local!dotCharacter2, local!spaceCharacter2), local!employees, local!document, local!classification, a!formLayout( contents: { a!gridLayout( totalCount: count(local!employees), headerCells: { a!gridLayoutHeaderCell(label: "Upload Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Clasification" ), a!gridLayoutHeaderCell(label: "Updated By" ), a!gridLayoutHeaderCell(label: "Updated On" ), /* For the "Remove" column */ a!gridLayoutHeaderCell(label: "" ) }, /* Only needed when some columns need to be narrow */ columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "ICON") }, /* * a!forEach() will take local!employee data and used that data to loop through an * expression that creates each row. * * When modifying the recipe to work with your data, you only need to change: * 1.) the number of fields in each row * 2.) the types of fields for each column (i.e. a!textField() for text data elements) * 3.) the fv!item elements. For example fv!item.firstName would change to fv!item.yourdata */ rows: a!forEach( items: local!employees, expression: a!gridRowLayout( id: fv!index, contents: { /* For the First Name Column*/ a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", target: cons!RDA_DOCUMENT, maxSelections: 1, value: local!document, saveInto: {local!document, a!save(ri!record['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.relationships.{bffc709b-0c45-42a1-a708-dd4abeef7278}rdaAttachment.fields.{cd4332dd-d46d-4fe7-b08a-3b117d5fc038}idAppianAttachment'],local!document) }, validations: {} ), /* For the Last Name Column*/ a!textField( label: "last name " & fv!index, value:{index(local!document,1,"null")}, saveInto: fv!item.lastName, required:true ), /* For the Department Column*/ a!dropdownField( label: "department " & fv!index, placeholder: "-- Select -- ", choiceLabels: { "Corporate", "Engineering", "Finance", "Human Resources", "Professional Services", "Sales" }, choiceValues: { "Corporate", "Engineering", "Finance", "Human Resources", "Professional Services", "Sales" }, value: local!classification, saveInto: local!classification, required:true ), /* For the Updated By Column*/ a!textField( label: "title " & fv!index, value: local!addedBy, saveInto: fv!item.title, required:true ), /* For the Updated on Column*/ a!textField( label: "phone number " & fv!index, placeholder:"555-456-7890", value: fv!item.phoneNumber, saveInto: fv!item.phoneNumber, validations: if( len(fv!item.phoneNumber) > 12, "Contains more than 12 characters. Please reenter phone number, and include only numbers and dashes", null ) ), /* For the Removal Column*/ a!richTextDisplayField( value: a!richTextIcon( icon: "close", altText: "delete " & fv!index, caption: "Remove " & fv!item.firstName & " " & fv!item.lastName, link: a!dynamicLink( value: fv!index, saveInto: { a!save(local!employees, remove(local!employees, save!value)) } ), linkStyle: "STANDALONE", color: "NEGATIVE" ) ) } ) ), addRowlink: a!dynamicLink( label: "Add Document", /* * For your use case, set the value to a blank instance of your CDT using * the type constructor, e.g. type!Employee(). Only specify the field * if you want to give it a default value e.g. startDate: today()+1. */ value: {startDate: today() + 1}, saveInto: { a!save(local!employees, append(local!employees, save!value)) } ), /* This validation prevents existing employee start date from changing to a date in the future*/ validations: if( a!forEach( items: local!employees, expression: and( not( isnull( fv!item.id)), todate(fv!item.startDate) > today() ) ), "Existing Employees cannot have an effective start date beyond today", null ), rowHeader: 1 ) } /*buttons: a!buttonLayout(*/ /*primaryButtons: a!buttonWidget(*/ /*label: "Submit",*/ /*submit: true*/ /*)*/ /*)*/ ) ) }, style: "#0000ff", marginBelow: "STANDARD" ) ) }, showWhen: or(a!isNotNullOrEmpty(local!selectedAccount)) ) /* this section is for the selestion grid so i want to do it */ /* i want tp put the local variable to view between grid then the depoit request */ } ), a!sectionLayout( label: "", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Cancel", style: "NORMAL" ) }, align: "START" ) } ), a!columnLayout( contents: {} ), a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label:if (ri!isUpdate,"Save","Create"), submit: true, style: "PRIMARY", ) }, align: "END" ) } ) } ) } ) } /*for all the form*/ ) /*for the local varaible */ )
I'm assuming the 2nd post is your start form. Hard to say without seeing your process. I would bet on some rule input that isn't mapped correctly somewhere.