I have a table called routines in my SQLite database with fields routinesref, routinesname, routinesdesc, and routinesorder. In my FlutterFlow app, I've set up a Reorderable ListView that displays items from this table, sorted by routinesorder. After reordering the list items in the UI, I am uncertain how to automatically update the routinesorder field in the database to reflect the new order of items.
Unfortunately, I have less than none coding experience, I've relied on ChatGPT to get this far, but after hours and hours digging through rabbit holes I've decided to unplug ChatGPT to preserve my sanity, and here I am.