Use pre defined value in front end function and in conditions

bonkersdeluxe

Hi,
Ive an stupid question?
How must the condition looks?

to Explain what i mean.

Ive created an relation it calls settings.
I will use this table with predefined dataset to control my application.
This table has only one dataset, and every column is an setting.
The first setting called debug_enables as an boolean.
With this value i will check is debug on or off.
I make this dataset not delete able, but changeable

Ive created an basic form were i can change the setting(s)

And now comes the thing ;-)
How can i read the value, this method not work

true or 1 not work

And how can i access this dataset in frontend function do make use of message boxes or form messages.
I did not found an instance function to use it.
Pseudo code, not an real function:
Exist an function like this for example
if(app.getpredfined_dataset("setting.debug_mode") == true) { app.form_show_message("info: "+app.get_field_value({F9: 0 customer_adresses.customerid}), 20000); }

Make use from Global variables are only valid to the browser window/tab. Not the whole site over all browser windows.
Ive tried the first run, with global variable but without success, because the other tabs dont know that the variable change. So i think with predefined dataset was the better approach
Thank you very much!
Best regards bonkersdeluxe

ACCFreiburg

I'm not a member of the official REI3 support team, but maybe I can help you.

It looks like you're comparing the dataset ID of the predefined dataset to a fixed value instead of the value you stored in the dataset.

I implemented something very similar in my applications by reading the value from the settings table using a backend function. This backend function is called by a frontend action when the form is loaded and returns the value that is used to initialize a variable. The condition can then use the value of the variable for its decision.

gabriel

This use case is what collections are built for. They fetch data for a user during login (and event-driven, if an update is requested) - and provide the values as defaults or filter conditions and so on.

To work with collections in functions, you can use the available instance functions to get the current collection values and/or update them when relevent.

When working with collections, be aware that they return a list of rows, with each row containing values for each attribute.

Of course, you can also call backend functions to query the DB on demand, as @ACCFreiburg mentioned. Is a bit more overhead usually, but you get the live data every time and do not need to care about updating your collection on change. 🙂

bonkersdeluxe

Hi Gabriel and ACCFreiburg,
Thank you for response.
Sorry iam answer so late, but this was not my highest prio.
But i tried it with collection, but the i cant update the collextion in runtime.
The frontend function my paramters dont work

To update the collection, this is wrong i know, but how is right:
this function calls if value changed on gui

app.collection_update({hacker_soft_kundenverwaltung.debug}).then( res => { }, // if success: return value in 'res' err => { } // if error: error message in 'err' ,app.get_field_value({F3: 0 settings.debugmode}) )

and reread at form open

app.form_show_message(app.collection_read({hacker_soft_kundenverwaltung.debug},[{column:0}]), 10000)
Thank you very much!
Best regards Bonkersdeluxe

gabriel

bonkersdeluxe To update the collection, this is wrong i know, but how is right:
this function calls if value changed on gui

Your syntax for updating collections is a bit perplexing. The app.collection_update() call cannot take any additional arguments, so there is no way to use data from field F3. Though I am not certain if you wanted to access F3 in the first place, as the placement is syntaxically wrong. A correct collection update would look like this:

app.collection_update({hacker_soft_kundenverwaltung.debug})).then(
    res => { }, // if success: return value in 'res'
    err => { } // if error: error message in 'err'
);

Though in general, you should do something with the error message, so that you can see that something went wrong - like so:
err => { alert(err); }

Collections do not take in any inputs from the frontend - they are only defined by what you select in the collection itself. You might want to update a collection if some data changes which affects filters in your collection, but nothing in the frontend (like forms & fields) has influence on it.

Though there might be a misunderstanding on what a collection is. A collection cannot change any data, just retrieve it to be displayed or used as filter or default values and such.

If you want to update data, you either need to do this via form or create a backend function that receives arguments to execute changes in the DB. Backend functions that update data can then be called by frontend functions when you click a button or change a value.

bonkersdeluxe

Hi Gabriel
Thank you very much, ive got it:

If i have an collection i dont update fields from collection, this is updated in real time if the databse to collection is changed/altered. I must only refresh the collection in forms to use (read values back)

As Example in GUI Mode

Then the collection is updates in real time.

But the forms were i want use the values get the updated collection value, so i must only use the update command and the collection to use it in the form.
So i use this function i called it debug_refresh

And run this function before form load.

and now i can build an condition.
The field is default hidden.
An only the debug collection is true it will be set to standard

And now if set the settings to true the field is visible and set to false is hidden.
of course you must close the form and open it again, but then it works.
if the form open its not calls the funtion again, only u use an refresh button or so

In gui it looks so as example, i remove the button, i insert it only for demo

its false at the moment so no customerid is shown

now we change from false

to true and save it

Press the refresh button or close and open form

then the collection is updated and the condition works

Thank you very much!
Best regards Bonkersdeluxe

bonkersdeluxe

PS. you can create an global frontend function, so u can use it in all forms without make an function in every form

in aktion there will be two debug_refresh if you have the old function in form.
In aktion there is no Global Tag. Is it an bug?
may be Gabriel you can add the text here too, for difference if the same function name is in the form. it will double listet, what is what?

Thank you very much!

gabriel

bonkersdeluxe may be Gabriel you can add the text here too, for difference if the same function name is in the form. it will double listet, what is what?

Might be an oversight - I´ll have a look. Thank you 🙂