Automatic propose logged in user as contributor (writer)

Questions related to using nuBuilder Forte.

Automatic propose logged in user as contributor (writer)

Postby ingar » Sat Jun 01, 2019 6:20 am

Hello,

I can't figure out how to do this - my webcoding knowledge is too limited :-(

I have a customer support phonelog, to record phonecalls and cases from customers. We are several co-workers who's doing this support task and each has their own login.
In the subform (logging of customer calls) I was hoping to find a way for the column co-worker (labeled 'Medarb') to be automatically chosen (filled in) based on the logged in users ID.

I have a table for co-workers ('medarbeider') which has a connection to phonelog table ('telefonlogg') with a foreign key in phonelog table ('tel_medID') pointing at the primary key in table 'medarbeider'.
In the table 'medarbeider' (co-workers) I also have a column containing a copy of each users nuuserID (for instance '5ce170db2ae06e3').

Is it possible to have the subform phonelog ('telefonlogg') to fill in the column labeled 'Medarb' automatically when saving - if (!) the column is empty?


Image
ingar
 
Posts: 10
Joined: Mon May 06, 2019 5:01 pm

Re: Automatic propose logged in user as contributor (writer)

Postby Janusz » Sat Jun 01, 2019 6:35 am

Hi,
Not sure for the question - are you looking for the automatic name insertion (based on login) like in the following case?
https://drive.google.com/file/d/1mnd2wH ... 1PCIh/view

field "Kto" is automatically updated before save based on login name (in this case login name is Janusz)
Janusz
 
Posts: 245
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Automatic propose logged in user as contributor (writer)

Postby ingar » Sun Jun 02, 2019 12:45 am

Hi,

Yes, something very similar to what you showed in your video.

The thing is: I have a separate table for co-workers ('medarbeider'), since I need that for other things too. Entries into the phonelog/subform (table 'telefonlogg') are based on the co-worker ID from table 'medarbeider' (co-worker).

I was hoping to achieve that it fills in users ID automatically WHEN SAVING the subform data. I'm having a correlation between the tables as shown in this image:

Image
ingar
 
Posts: 10
Joined: Mon May 06, 2019 5:01 pm

Re: Automatic propose logged in user as contributor (writer)

Postby Janusz » Sun Jun 02, 2019 1:39 am

Hi,
Please find enclosed the very good and clear description which I received from Kev1n some time ago:
viewtopic.php?f=20&t=9716
(have a look at the end of the first page).

the above you can use to set initial value for the select field for example (the name must be present in the list - otherwise field will stay blank).

in my case for the select field I am using data from the table for example:
Code: Select all
SELECT
    Pracownicy.pra_imie, Pracownicy.pra_imie

FROM
    Pracownicy
WHERE
   Pracownicy.pra_status=1
ORDER BY
    Pracownicy.pra_aux


to set initial value of the form with new record you can use as well in java script nuIsNewRecord - just any example belowe - if to be used on the subform pay attention to use proper addressing:

Code: Select all
if(nuIsNewRecord()){
$('#ofe_status').val('1*-do zrobienia').change();
$('#button_save').show();
var nuUser = getUser();
$('#ofe_created_by').val(nuUser).change();
$('#ofe_zrobione').val(nuUser).change();
}
Janusz
 
Posts: 245
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Automatic propose logged in user as contributor (writer)

Postby Janusz » Sun Jun 02, 2019 1:58 am

and just one example with new forms with some fields prefilled which you can change easilly afterwards:
https://drive.google.com/open?id=1hsE30 ... REW_nq0D48
Janusz
 
Posts: 245
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland


Return to General