Dave Airel's Profile | Ninox community

Latest Posts

Re: database level trigger in ninox.com?
@Fred Aargh. Thanks, Fred. Now I see it.
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
database level trigger in ninox.com?

Hi - I want to create a trigger that executes when I open my online database to go to a specific table ("Dashboard"). I see plenty of info online about doing that in the Mac app,…
- Dave_Airel
- 9 mths ago
- 2replies
- 20
- Get help
- Answered
- Answered
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas done
- Dave_Airel
- 9 mths ago
- 1
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas Ok, that worked. THANK YOU. I'm shutting down for today and will do some more exhaustive testing tomorrow. Is it ok if I post again on this thread afterwards if I come up with…
- Dave_Airel
- 9 mths ago
- 1
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel I was able to open your updated file in my app, and just ran the same 4-record import. Looks like it worked (hallelujah!) Now I just need help getting back into my online account ...
- Dave_Airel
- 9 mths ago
- 1
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas Yeah, I agree. But (sorry) I have no idea how to put it back in place. My Starter plan only allows automatic backups so I assume I'll have to go back through the app.…
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel also just noticed when I'm in edit mode there's an exclamation point on StagingImport. Only in edit mode. And I confirmed I changed Event ID to a text field in StagingImport .
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel No errors showing up in the script editor though. ??
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas Aargh. Run-time errors.
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas So, I just changed the Event ID field in the StagingImports table to a text field, and now the existing script has a bunch of errors. Did you update the script?…
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Progress. Events and contacts appear to be linked correctly. But events are still being created for every line in the .csv.
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas You're correct. A contact should be updated if it's in the .csv file and the contacts table, and created (one time) if it's not. A contact will only be in .…
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas Script ran. Events were created 4x, once per line in .csv Events table shows 4 events, none linked to a contact. Contact table shows event linked to one contact, dave@airel.org.
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Fred @Sotirios Zormpas OK, success. Attached is a copy for the ESI database (exported from my Macbook app) - it has only 2 contacts, 1 event (all imports have been deleted from all tables).…
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Fred Well, I have the online db open in my Mac app, but when I get to step 4, and select Export Data in the Table menu, nothing happens. You didn't mean "Database/Archive", did you?
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
I'm going to have to log off for awhile, will check back later for updates. Thanks for the support so far - fingers crossed we're close.
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel FWIW each of these is 'owned' by different email addresses (same human name) if that makes a difference.
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Fred Really? I do have the Mac app, managing another (totally) unrelated database. Can I download this one (ESI) while keeping my other one (Macum Creek Concerts) active & not screwing either up?…
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel When I remove the y := line and the stray "w" below it the script runs but same problems as before. And the RSVP table contains updated Contact info but the Event isn't linking to it.…
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel Screenshot 2025-06-01 at 11.08.59AM
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Sotirios Zormpas Error on y := array(y,w); w (what's the "W" here?) Screenshot 2025-06-01 at 11.07.58AM
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@RoSoft_Steven Good to know ... thanks
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@RoSoft_Steven no data yet, so no privacy concern. Once resolved, I can just remove him, correct?
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Fred @Sotirios Zormpas it's asking me for an email address
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view
Re: need help on importing a .csv into two related tables (scripting help?)
@Dave Airel I have a second license that isn't active yet. Can i give you those credentials to log into the live account? (there's no real data there yet)
- Dave_Airel
- 9 mths ago
- Get help
- Reported - view

1 2 3 4

Welcome to the Ninox community

Dave Airel

Re: database level trigger in ninox.com?

database level trigger in ninox.com?

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Re: need help on importing a .csv into two related tables (scripting help?)

Overview