nuBuilder Forum

Hi,

I have a browse-edit form with customers that are all users. That means that they have all an user_id.
Each customer is supposed to login , then select his own record and fill in adress, date of birth etc, etc...
I created a field in the customer table: cus_user_id and added this as column (width 0 px) on the customer form.

What I want to realise is that a customer after logging in goes right away to his own edit form.
I suppose this has to be done with the JS function
nuForm('form_id', ?, '', '', 1)
where ? is the cus_user_id]

My question is how to get the string of the customer_id (wich can be queried) in this function?
Or, put it like this, how to pick-up a php variable in JS

A hint or an en example code would be helpful

thanks,
Ko

Ko,

This is my idea (but not quite working because of a little issue...)

1. Clone the form nuuserhome. Name it like customersuserhome (Code) and give it a description (like Customers Home)
2. Add this PHP code to the BE event: nuRunPHPHidden('openFormForCustomer', 1);
3. Assign the customersuserhome to your customers (Home ► Access Levels)

4. Create a procedure: Home ► Build Procedure ► Add
5. Now when a customer logs in, the nuRunPHPHidden() is executed and runs the code 'openFormForCustomer'

The only problem..

console.log() doesn't output anything and consequently, the form is not opened.. It looks like nuJavascriptCallback() is not executed.

I'm a little clueless right now. Maybe Steven or someone else can help out ?

toms,

thanks.

I made a simple test.php file with the query outside nubuilder and got the correct output This is the same as what nuRunQuery() in your script does I suppose?
And if so, how can I get the output on the console in element inspector?

I know this is not quite nuBuilder stuff but if you can give me a hint then I am one step further.

thanks a lot,
Ko

Ko,

Yes, this is what my function returns too: The record id. You can use nuDebug() to output e.g. a string.
It can be viewed by clicking nuDebug Results in the Options menu.

.

Ko,

You can try this - (Your customers will need to log in and click a Button on whatever their Home Page is, to open the Form).

Create the Form

Filter Browse by User ID Add User ID when adding a new record.
Obviously, you would hide the cus_user_id field.

Hope this helps.

Steven

Steven,

It helps me to update the cus_user_id from the customer table.
I used an update script in php.
This is much easier.
Thanks.

What I actually wanted is this:
So, after clicking on the login button the custumer would be on the edit page of his own record without having to click on his own row.
And that's where I thought I would use nuForm('form_id', 'customer_id', '', '', 1).
Is this assumption correct?

Of course, it's not a big deal, but I am curious to find out how to realise this with Javascript.

Ko

Ko,

Here is another idea...
This should work as long as the Primary Key of the Form is the user_id.


Steven

Steven,


A. Logging in with button and row on browse form shows 'Evelien'
B. Logging in with iFrame gives in my case an empty record. The element inspector gives And yes, user_id Evelien == customer_id Evelien : 5a99060cb2aa0c4

Unless you know immediately whats going wrong, let's close the topic.
It's not that important
I appreciate your hints.

Ko

OK.