0

How to Get Triggers to Work when Importing Records?

So, I have quite a few triggers set up, which is great when you are manually entering data and records.  However, how do I get them to work automatically when importing records?  I've been doing bulk edits for all my triggers in the meantime, and that can be quite burdensome.  Any advice?

4 replies

null
    • Alan_Cooke
    • 10 mths ago
    • Reported - view

    If you are looking to update 'on import' I'm not sure that is possible.  Could yo get away with doing something like this:
     

    In other words, use the Trigger Before View.

    • Fred
    • 10 mths ago
    • Reported - view

    You may want to consider putting your trigger codes wrapped in a for loop in a button. That way you only have to press a button.

      • Dave_Irving
      • 10 mths ago
      • Reported - view

       , so no way to create a server side script to run triggers upon an import?  I like the idea of a button, but don't like the idea of having to add it to my records :)

      • Fred
      • 10 mths ago
      • Reported - view
       said:
      so no way to create a server side script to run triggers upon an import? 

       I guess there isn't, or Ninox would allow triggers to run on import. ;-)

       said:
      I like the idea of a button, but don't like the idea of having to add it to my records

       Alan's suggest is an option, but I'm not sure you want it to run every time you view your main tab. I guess if you created a tab called Import then that would be ok.

      Another option is to create a dashboard to put the button in. You can put buttons here that do DB level work that you do regularly. Once you start with a dashboard you will find other uses for it that you use to do at the table level.

Login to reply

Content aside

  • 10 mths agoLast active
  • 4Replies
  • 77Views
  • 3 Following