AppGini Community Forums

Sorry,

can you try
there was a missing backtick.

Hi,
can you try:

What type of field is your calculated field? What codepage are you using?

Can you post your "old" code that gives results and the new one you that you put in.

Hi, no worries, AppGini gives you a lot out of the box, and a lot of possbilities, but if you want to do more than what is provided out of the box, you need to get onto coding a little bit. for your question. Try SELECT time_format(TIMEDIFF(timesheet`.`day_1_to`,`timesheet`.`day_1_from`),"%H:%i") FR...

Hi, glad it works. can you show a sample of that data you are using for the calculation. Also the default behaviour for the calculated fields is as you described. Calculation happens after saving the record. If you want to do some calculation at data entry you can do that via Javascript. register on...

Hi, you need to put in a sql query. So try SELECT TIMEDIFF(`timesheet`.`day_1_from`,`timesheet`.`day_1_to`) FROM `timesheet` WHERE `timesheet`.`id`='%ID%' assuming that day_1_from is your start time and day_1_to is you finish time . Also assuming that your primary key of timesheet is called id

Hi,

can you post your complete query, and what are you getting (and expecting) as result?

Hi,

it can be that you need to check if the QueryWhere is empty. If so you can apply the WHERE Clause if not you need to append you filter by adding it as " AND" Clause.

Did not try that but could be.

Hi, the image in AppGini is stored as a file on the filesystem. Hence if you want to store it into the DB, you can use the after_insert/after_update hook, read the file (image) for that record from the filesystem and put it into the blob field. You should not use the same field, as in the image fiel...

Hi,

this is not possible, as the %s is just replaced by the username.

If you want to change that you need to edit the membership_profile.php around line 116.

Hi,

you may have a look at

https://github.com/jeromeetienne/jquery-qrcode

this is very easy to implement.

Hi,

please try

SELECT
DATEDIFF(`appuntamenti`.`data_appuntamento`, NOW())
FROM `partecipazione_evento_pubblico` left join `appuntamenti` on `partecipazione_evento_pubblico`.`data_evento` = `appuntamenti`.`pri_key`
WHERE `partecipazione_evento_pubblico`.`pri_key` = '%ID%'

Ok, clarified the issue with David. The table is called differently, so the correct code to work is

$j(function(){
$j('#eff_link').after($j('#eff_link').clone().prop('id', 'Materials_link' ).attr("href", "materials_view.php").html($j('#eff_link').children().clone()).append(' Materials'));
})

Otherwise try

$j(function(){
$j('[id$=_link]:last').after($j('[id$=_link]:first').clone().prop('id', 'Materials_link' ).attr("href", "materials_view.php").text('new').html($j('[id$=_link]:first').children().clone()).append(' Materials'))
})

Did you try

$j(function(){
$j('#Efficiency_link').after($j('#Efficiency_link').clone().prop('id', 'Materials_link' ).attr("href", "materials_view.php").html($j('#IEfficiency_link').children().clone()).append(' Materials'));
})

Hi,

do you want to store the qr code after saving the record, or only display the qr code on the page?

Hi,

try

SELECT(
DATEDIFF(`appuntamenti`.`data_appuntamento`, NOW())
FROM `partecipazione_evento_pubblico` left join `appuntamenti` on `partecipazione_evento_pubblico`.`data_evento` = `appuntamenti`.`pri_key`
WHERE `partecipazione_evento_pubblico`.`pri_key` = '%ID%'

Hi,

please try to wrap the code in

$j(function(){
<code>
}

Sorry my mistake,
can you put the script in quoting-dv.js

you can add the code through the quoting-tv.js file in the hooks section.

Hi, you can try $j('#Efficiency_link').after($j('#Efficiency_link').clone().prop('id', 'Materials_link' ).attr("href", "materials_view.php").html($j('#IEfficiency_link').children().clone()).append(' Materials')); This shall add a button to the materials TV. Please check all names as I'm not sure whi...

Hi, ok, so there was a missunderstanding. If you want to see the result in the table view with your format, you should change back the type to decimal, or integer (if you do not use decimals). montant total you can create in the hooks folder a file called membres-tv.js. Add the following to the file...

Hi,

thanks for the correction. Indeed, I missed this statement during copy&paste. If you need the variable more often it makes sense to put it as a feature request. So far, I did not need it yet.

Hi,

I think you need to change the type for the field Montant TOTAL to varchar (10) or what suits you best.

Even so I'm not Olaf, hope it works now.