I have 4 registry tables: North (approx 940 rows) South (approx 920 rows) Hospitals (about 80 rows) and Pending (varies depending on how many applications we receive)
These tables contain basic demographic info, as well as certain health data collected to determine if they meet eligibility criteria for medical needs shelters.
Then I have a table specific to our shelter operations.
This table contains limited fields from the registry tables (name, dob, address) and then the rest of the columns are incident specific.
So we track: call out info transportation status shelter check in/out room assignment, etc
I originally added extra columns to my registry table because that was the only way I could create filtered slices in order to assign the 1800+ records to the callers, but I would really prefer not to have the table number, caller name, etc in registry.
So now i’m trying to figure out a way to basically copy all 1800+ rows of data (just a name - the other info can be populated by dereference) in order to do bulk actions to quickly assign the records to tables.
I’m just hoping the answer isn’t copy and paste
I have watched all the youtube videos on select, list, etc and that’s not really want I need.
The link to form from registry to my activation log worked but that would mean someone would have to click action button, assign table to 1800 individual records - no time for that.
I need a magic button where I can divide the 2 big tables of data by 5 (I have 5 physical tables of callers) and say rows 1-180 assign to table 1, etc.
Hurricane Irma nearly killed me - all paper based - so if I have to live with extra tables in my main registry I will but it’s just not as clean as I’d like.
Whatever solution I come to has to be fluid.
The second a tropical system forms out there we get flooded with apps.
So all the records in pending will eventually be moved to north, south, hospital after review.