0

Auto-fill field not triggering when record is created via popup — is this expected?

Hi everyone,

 

I’m running into an issue with my database setup and I’m not sure if this approach is valid.

 

In Table 1, I created a text input field called “BB”. This table is configured so that when a new record is created, the BB field is automatically filled with text.

 

However, in Table 2, I have a text field “AA” with a trigger set to run on change:

popupRecord(create 'Table 1')

The problem is:

When a new record is created in Table 1 via this popup, the BB field does NOT get auto-filled as expected.

 

So my question is:

Is this method supposed to work? Or does creating a record via popupRecord(create ...) bypass the auto-fill behavior?

 

Any suggestions or alternative approaches would be greatly appreciated!

 

Thanks in advance 🙏

5 replies

null
    • John_Halls
    • 4 days ago
    • Reported - view

    Hi

    I just uploaded your example, and it works fine. I used the Public Cloud 3.18.6

    Regards John

      • gold_cat
      • yesterday
      • Reported - view

       

      Looks like I’ll have to try a different approach for this.

      Thanks again for your help!

    • Fred
    • 4 days ago
    • Reported - view

    I can duplicate the issue when I use the public cloud. There is some limitation with triggers that are not specified and only discovered through trial and error. I guess the thinking is Ninox doesn't want a  cascading number of script running that could lock up the server.

      • gold_cat
      • yesterday
      • Reported - view

       Really appreciate your explanation — it helped clarify the issue a lot 

      • Peter_Albrecht
      • 8 hrs ago
      • Reported - view

        That's correct. No chains are allowed. If your button changes a value, then the trigger on change are not executed. You have to put the stuff of the trigger in the executing button.

Content aside

  • Status Answered
  • 8 hrs agoLast active
  • 5Replies
  • 44Views
  • 4 Following