This topic is locked

Sorry Blackout!? Field should expect specific input

5/1/2023 4:34:20 AM
PHPRunner General questions
A
Andreas G. author

Sorry, but I've blacked out before though.
A fixed code is to be entered in a text field
Example 12345
How do I check the entry for 12345 before submitting/saving?
Version 10.6, unfortunately I haven't worked with it for a long time
Translated with Google

W
wedi 5/3/2023

Hello Andreas,
you can do that with a field event
https://www.youtube.com/watch?v=4WGWbCUHCOc
or in event Before record added / updated
Here an example when you want to check 12345 in database (in OnServer of field event or in Before added/updated):
$sql = "select * from table where field = 12345"; $rs = DB::Query($sql); if ( $rs ) { $data = $rs->fetchAssoc(); if ( $data ) { 12345 exists } else { 12345 missing } } else { problem with select or db-connect }Regards,
wedi

A
Andreas G. author 5/4/2023

Thank you, I'd like to take a look
Translated with Google