I'm working on building a database that would serve as a Corpus for my Arabic classes. It would be a relational database for which I create the structure myself in Airtable and then import it into Xano. The main things I need help with is Data manipulation using arrays and loops, since I need to generate new words from existing records using Concatenation formulas.
I'm a long-term user of Airtable and new to Xano mainly because of having exceeded the Airtable record limits. So I'm very well-versed in how to structure tables, create fields and connect them. However, I'm lost on the many more advanced functions Xano has.
I'm looking for someone who can offer me guidance on how to implement Data manipulation functions and general advice on my database structure for speed and efficiency.