Fred John Halls Thanks for that pointer, I honestly hadn't thought of that. The pop up forms seem so easy and intuitive ...  I guess it makes sense to put a little security between our users and the basic structure of the database. I've been thinking about this for a couple days and keep coming back to this ... other than removing the chance of deleting an entire table, are there really any other protections provided by building edit capabiities into a separate dashboard table? (serious question)

Fred Yeah. Ok. Tail between my legs pulling open the training videos on dashboards now. Thanks, Fred.

Fred I think I'm ok. I used a Nioxus training video from a couple years ago to get started. I began with a "Control Panel" table, created a form view and am building out tabs for the different stuff users will need to do. So far I have "Add a new contact" working, moving on to the others over the next couple days. Thx for your support -- as always, suggestions welcome.

Fred OK, stuck on a script again. A few weeks ago, you and Sotirios Zormpas helped me build a script to process an imported .csv file into two tables (Contacts and Events). That script has been working fine. In this latest dashboard effort, I want to create a dashboard tab to manage this entire process - eventually launching the import (into the Attendance_Staging table) from the dashboard, and then using the "Process Data" script to move the data.

I started by manually importing a test .csv with 3 records into Attendance_Staging. From my perspective, it seemed like the original script might work so I just copied it over to a button on the dashboard. It does process the Attendance_Staging table, but only the last record is saved. The script is below. I'd be happy to send you a copy of the database, but now that it's populated with real data I don't want to post it here. Can I get it to you some other way?

Here's the script (again, it works when the button on the Attendance_Staging table, but only the last record is saved when I launch it from the Control Panel (Import - Events tab, BTW)

do as server
    let allContacts := (select Contacts);
    let allEvents := (select Events);
    let allRSVP := (select RSVP);
    for i in select Attendance_Staging do
        let contact := if contains(allContacts.lower(Email), i.lower(Email)) then
                first(allContacts[lower(Email) = i.lower(Email)])
            else
                let newContact := (create Contacts);
                newContact.(
                    Email := i.lower(Email);
                    Lastname := i.'Last name';
                    Firstname := i.'First name';
                    'Mobile Phone' := i.'Mobile number';
                    Zip := i.Zip
                );
                allContacts := array(allContacts, [newContact.Id]);
                newContact.Id
            end;
        let event := if contains(allEvents.'Event ID', i.'Event ID') then
                first(allEvents['Event ID' = i.'Event ID'])
            else
                let newEvent := (create Events);
                newEvent.(
                    'Event ID' := i.'Event ID';
                    'Event Name' := i.'Event name';
                    'Event Type' := i.'Event type';
                    'Date / Time' := i.'Timeslot start'
                );
                allEvents := array(allEvents, [newEvent.Id]);
                newEvent.Id
            end;
        if count(allRSVP[Attended_Import = i.Attended and Contacts = number(contact.Id) and
                        Events = number(event.Id)]) = 0 then
            (create RSVP).(
                Contacts := number(contact.Id);
                Events := number(event.Id);
                Attended_Import := i.Attended;
                'RSVP Status' := i.'Attendance Status'
            )
        end
    end;
    delete (select Attendance_Staging)
end

Fred Just went to do that & realized in my testing I had deleted 7 'real' contacts ... no idea how I did that. I need to fix that first so give me a little time. I have to run out this afternoon so I'll work on it over the weekend and send you the latest DB with some fake data. Thanks, Fred.

Mel Charles Got it - thanks, Mel.