saltcorn, update rows in database using a trigger event

CODE:
let tableObject = await Table.findOne({name: 'onOrder'}).getRows(({user_key: user.id}));
console.log(tableObject[0].name);
for (let row of tableObject) {
await Table.findOne({name: 'onOrder'}).tryUpdateRow(({stage: 2}), row.id);
}

[@RedCloudServices]

thank you! Just started with saltcorn for a big project updating postgres records. Problem is we have people across country in regions so they need to view and edit only their data. Would you recommend just creating a role and view for each region? also i wish there was a way to create a card view where each card was a summary count of records per region 🤔

[@johnchristensen3869]

I will see if I can look into that over the next few days. Saltcorn is a great tool and extremely useful. It’s not perfect though. Personally, I have found that if you’re doing something extremely custom saltcorn has its limitations. Something like laravel might be a better option, but unfortunately Laravel is made for people how know how to code. Let me see what I can find out.

[@RedCloudServices]

@@johnchristensen3869 thanks in meantime I am onto Dronahq. Any app builder that works locally w postgres i would take but most are cloud based. Dronahq self-host so far is a fail. Saltcorn refuses to be setup w postgres I am in their Discord others have same issue