OnChange not firing

(0) Share

Report

Posted on by EpicTriffid

345

Hi there,

I have an OnChange function on a text input (# Students) that is designed to update all records in a gallery (# Stud.) when the number is changed. While i was using a SharePoint list as my database, it worked great, but now that I've moved over to an SQL DB, it doesn't seem to be firing when changed.

UpdateContext(
 {newStudents:
 'UE - Value - # Students'.Text}
);
ForAll(
 'UE Unit Gal'.AllItems,
 Patch(
 '[dbo].[Units]',
 LookUp(
 '[dbo].[Units]',
 ID = Value('UE Gal ID'.Text)
 ),
 {
 'Number_x0020_of_x0020_Students': Value(newStudents)
 }
 )
)

The offending input is the one with the delegation error. If anyone can help me remove that as well, I'd be very grateful!

Categories:

General Questions

Connecting to Data

All responses (2)

Answers (0)

EpicTriffid 345 on at

Like (0)

Report

Re: OnChange not firing

Hi @yashag2255 ,

Thanks for the help. I adapted it as you said, and no errors that I can see. The notifation does come through, so do you have ideas what might be wrong with the Patch? Is there a problem between ForAll and SQL?
yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report
Re: OnChange not firing

Hey @EpicTriffid

Can you try to update the expression as:

UpdateContext( {newStudents: Value('UE - Value - # Students'.Text)} ); ForAll( 'UE Unit Gal'.AllItems, Patch( '[dbo].[Units]', LookUp( '[dbo].[Units]', ID = Value('UE Gal ID'.Text) ), { 'Number_x0020_of_x0020_Students': newStudents } ) )

Are you getting any errors? To check if the OnChange is getting triggered, add the below expression on the OnChange property as:

Notify("Getting triggered");

If you are able to see the notification, then the issue is with the Patch query and OnChange is getting triggered.

Note: OnChange only gets triggered if the user clicks outside the text input.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!