Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Questions related to using nuBuilder Forte.
johan
Posts: 399 Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times
Unread post
by johan » Wed Mar 07, 2018 1:06 pm
Hi
I want to add user_id and user_group_id in every record in my table clients.
I'm trying to do this with after save and I only want the update for new or cloned forms. But this doesn't work with this code. I think the problem is in the if part.
Code: Select all
if('#clone#' == '1' or '#RECORD_ID#' == '-1'){
$s = "UPDATE clienten SET cl_usergroup_id = '#USER_GROUP_ID#' ";
nuRunQuery($s);
}
Johan
admin
Site Admin
Posts: 2814 Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times
Unread post
by admin » Thu Mar 08, 2018 12:35 am
Johan,
I have updated Github with a change that should allow you to do this...
Code: Select all
if('#NEW_RECORD#' == '1'){
$s = "UPDATE clienten SET cl_usergroup_id = '#USER_GROUP_ID#' ";
nuRunQuery($s);
}
Let me know if it works for you.
Steven
johan
Posts: 399 Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times
Unread post
by johan » Thu Mar 08, 2018 1:06 pm
Steven
Works perfect, thanks for your help.
Johan