Table “Transactions” has a column ‘Account’ that references to “Bank Account” table.
Transactions:
UID (Unique ID)
Account (Ref to Table “Bank Account”)
Other fields
Bank Account:
UID (Unique ID)
Account (Label)
Other Fields
“Transactions” has an action that allows CSV file upload.
Issue:
The user is able to upload transactions belonging to an account that does not exist in the “Bank Account” table. ie., Validation does not kick in when a account that does not exist is used in the CSV file.
If I use “ValidIf” at the Column ‘Account’ of the table “Transaction”, ( ValidIf: IN([_THIS], Bank Account[Account] ):-
User is still able to upload a CSV to transactions with any Random Account (ie. there are no errors)
When the user fills up the transactions through the user interface App Sheet populates the Account’s Value instead of populating the “Bank Account Key” (desired to populate the Key instead of Value).
Appreciate your inputs/suggestions to resolve this issue.
When the user fills up the transactions through the user interface App Sheet populates the Account’s Value instead of populating the “Bank Account Key” (desired to populate the Key instead of Value).
I’d guess you need to regenerate the columns of the Transaction table. This behavior can occur when the data source is a spreadsheet and the spreadsheet columns have been reordered but Regenerate columns was not subsequently used in the app editor to make it aware of the reordering. See also: Add, reorder, or delete columns
If regenerating the columns doesn’t fix the problem…
Please post a screenshot of the configuration on the CSV import action.
Please post a screenshot of the configuration of the Account column of the Transaction table.
Please post a screenshot of the Valid if expression that isn’t being applied.
