I know this is a bit of middle ages as you have to press the button RUN everytime you need to modify your tables…
But i got this as a compromise.
Create a new table where you will store your Schema.
I called it ‘Ledger’ just for clarity.
create a block and use this code, it will populate it with the names of your tables, and then you can use it to make api calls.
let ledger = base.getTable('Ledger');
let tableList = []
for (table of base.tables) {tableList.push({fields: {'Name' : table.name}})}
await ledger.createRecordsAsync(tableList)
if you want to avoid async random return order of your records you can store it in a string and then parse it as an array in your app.
let ledger = base.getTable('Ledger');
let tableList = ""
for (table of base.tables) {
if (base.tables.indexOf(table) == base.tables.length - 1) {
tableList += table.name
}
else {
tableList += table.name + ", "
}
}
await ledger.createRecordsAsync([{
fields: {'Name' : tableList }
}])
