nuBuilder Forum

Posted: **Sat Aug 21, 2021 7:07 am**

After logging in, the user sees only his entry in the Browse Form and then has to click on this entry to open the EditForm. These are unnecessary actions.

21.08_1.png

In my case, RecordId = UserLoginName
I try insert #USER_ID# in:

21.08_2.png

But no result - open empty EditForm. If I insert simple number (16 or 122 etc) instead of #USER_ID# then EditForm opens correctly.
I use this SQL-query for browse:

Code: Select all

SELECT
 klk.NPP,
    klk.STATUS,
    klk.SHORTNAME,
    klk.POL,
    klk.DATEBIRTH,
    klk.CURRDOLJN,
    klk.KODPODRAZD,
    klk.ARHIV,
    klk.OTLICH,
    klk.ONDATE

FROM  klk
LEFT JOIN zzzzsys_user ON sus_login_name = NPP
WHERE zzzzsys_user_id  = '#USER_ID#' OR '#GLOBAL_ACCESS#'='1'

ORDER BY
    SHORTNAME ASC

How to quickly open EditForm for a logged-in user instead of the sequence Browse ->Select -> EditForm?

Posted: **Sat Aug 21, 2021 7:40 am**

Use #LOGIN_NAME# instead of #USER_ID#

Posted: **Sat Aug 21, 2021 7:49 am**

kev1n wrote:Use #LOGIN_NAME# instead of #USER_ID#

Thanks! Everything worked perfectly!

nuBuilder Forum

How to quickly open EditForm for a logged-in user instead of

How to quickly open EditForm for a logged-in user instead of

Re: How to quickly open EditForm for a logged-in user instea

Re: How to quickly open EditForm for a logged-in user instea