So, here is the scenario
Our company uses three types of templates and each of it is different and I am creating a glide app to effectively manage them. I have already built an app in which I am using a helper table when the transacitons are uploaded to put data into it and view it and all of that is for template 1 but to manage and automatically detect which type of transaction report it is we need to use some logic which I ddont know how to. Here is an example of the three templates i am talking about
Template 1
| Transaction date | Value date | Transaction reference | Description | Debit Amount | Credit Amount | Balance | Account number(IBAN) | Account number(BBAN) | Account name | Currency |
|---|---|---|---|---|---|---|---|---|---|---|
| 14-Mar-25 | 16-Mar-25 | 000452055733.AC0003. | Service Fee | 000452055733 | 10 | 508.04 | MU07MCBL0944000452055733000USD | 452055733 | Current Account | |
| 14-Mar-25 | 16-Mar-25 | 000452055733.AC0003. | Tax Amount Due | 1.5 | 518.04 | MU07MCBL0944000452055733000USD | 452055733 | Current Account | USD |
Template 2
| MY TRANSACTIONS | |||||||
|---|---|---|---|---|---|---|---|
| Transactions List | LC1202 - CAODA- SHOBHA JEWELS CO LTD (MUR) - 143100000922 | ||||||
| Instrument ID | Transaction Date | Value Date | Description | Amount Type | Amount | Running Balance | |
| 17/03/2025 | 17/03/2025 | Transfers/Bonus SBM TRANSITIO | Cr. | 18,650.93 | 35,936.66 | ||
| 13/03/2025 | 13/03/2025 | Transfers/Bonus SBM TRANSITIO | Cr. | 457.83 | 17,285.73 | ||
| 7447058 | 13/03/2025 | 13/03/2025 | INWARD CLEARING-MORNING | Dr. | 23,000.00 | 16,827.90 |
Template 3
Title : Transactions
Report generated by : SHOBHA JEWELS CO LTD
Report generated on : 17/03/2025 08:39 PM
Account Number : 03020005516
Bank Name : Bank One
Start Date : 02/02/2025
End Date : 16/03/2025
"Transaction ID " "Cheque Number " "Transaction Date " "Value Date " "Description " "Debit " "Credit " Balance
S14960898/3 4/2/2025 4/2/2025 SWIFT PMT/000000446856/BAFLEH JEWELLERY LLC 1410.3 1097286.19
S14960898/4 4/2/2025 4/2/2025 SWIFT PMT/000000446856/BAFLEH JEWELLERY LLC 711900 385386.19
S14974986/3 6/2/2025 6/2/2025 SWIFT PMT/000000447372/BAFLEH JEWELLERY LLC 1399.5 383986.69
S14974986/4 6/2/2025 6/2/2025 SWIFT PMT/000000447372/BAFLEH JEWELLERY LLC 706500 -322513.31