AppGini Community Forums

The SQL command for calculated field should update exactly one row. You have to append one more condition to your WHERE part: AND TABLENAME.PKCOLUMNNAME = '%ID%' Replace tablename and pkcolumnname . %ID% will be replaced by AppGini automatically at runtime. Additionally, if your SELECT returns more ...

Hmmm, I think this is exactly the way it works (and should work for many use cases). I'm afraid there is no standard way nor hook for importing (=updating) ONLY existing and skipping new records unless you code your own CSV-reader which eliminates "unknown" records before importing. Or you can delet...

Can you please check for syntax errors in your hooks code, first. Very often there are parameters missing like $error parameter in functions sqlValue($command, $error) or sql($command, $error). Your IDE should mark those as errors, already. Those parameters are mandatory now. Just an idea.

Just to be sure:
Is it inside 'plugins' directory?

OK, you can try with the following javascript-hack. It is intended for landscape orientation videos but can be adjusted to you needs. Note: This is just a quick fix. I do not guarantee that it will work in all circumstances. Before chrome_KIH8YQm0Mx.png Code You can put it for example in hooks/TABLE...

I am not using YouTube links in my projects. But as there hasn't been any help from others for a while, I have taken the time and added a YouTube-video-link field to one of my tables. Configuration AppGini_x13FE1CsAZ.png First of all, there are different meanings of "video size". So just for clarifi...

I. Javascript I.1 In Browser In new versions there is a version -property which you can evaluate in javascript, for example in console prompt of your browser's developer tools: AppGini.version chrome_aXkEc9BGZv.png I.2 In Code Open common.js . In new versions there should be a version-initializatio...

Good morning everyone! Here is just a very short tip on styling lookup buttons for matching with your default user interface design Default Style Here is what lookup-buttons, modified by built-in select2 -library, do look like by default in standard theme: chrome_1bjVVT50Pj.png As you can see, in co...

W3schools has some nice tutorials:
https://www.w3schools.com/js/js_ajax_intro.asp

There is also help on Bootstrap, for example.

Well done and thank you!

Thanks, Tony!

There is a "buy me a coffee" link in my profile page:

Buy me a coffee:
https://www.paypal.me/cash4code

Just curious: Did you rename the options or did you add a lookup table?

The list is perfectly sorted alphabetically : "1" < "10" < "100" < "2" < ... < "9" You may replace Blind 1 by Blind 01 etc. in your options-list: "01" < "09" < "10". If you want numeric sorting of alphanumeric items you could replace options list by a lookup table, add a numeric/integer position col...

There are a few things to say here: (1) Email Configuration (Skip this if sending emails already works) Before sending from code, I recommend testing email-sending first. Therefore, go to Admin Area / Members, click on admin's email address, then send a test mail and see if this works. If testing fa...

Just a very short UI-tip: I have noticed that buttons of the so called "TV-Tools" take up more space than necessary. They are wider than for example the buttons of QuickSearch. See orange-underlined button vs. green underlined button chrome_6Xyt5qhQNp.png The following CSS setting reduces the width:...

:idea: TL;DR If you have >5 seconds loading-delay when using AppGiniHelper.DV.getField("FIELDNAME").toStatic() on a lookup -field, try passing null as 1st and true as 2nd parameter: AppGiniHelper.DV.getField("FIELDNAME").toStatic(null, true); --- Problem Recently I was wondering about loading delay...

I have the AppGiniHelper.min.js Here is an example for adding... a custom menu (dropdown) with menu-items and dividers (lines) a simple link a simple link with icon ...to NavBar using AppGini Helper Javascript Library (* commercial, I am the author) <!-- file: hooks/header-extras.php --> <!-- requi...

Just a short tip on making your code more future-proof: Nowadays, anonymous users (AKA "guests") may be named differently in configuration. So, instead of string-comparing to 'guest' it will be safer and more future-proof to use built-in function isGuest like this: if (Authentication::isGuest()) { /...

I have the AppGiniHelper.min.js

If you send your order number by email to ticket@bizzworxx.de I can help you on custom navbar items within your support option.

Adding links and complete dropdown menus works just fine. If you have any red errors in console please fix them first.

I cannot see your code, so I cannot help debugging. It works here if put into the correct file in hooks directory with correct fieldname after reload without cache. Are there any red errors in console? Did you check that? And are you using an up-to-date version? Is it really a date field or somethin...

const fieldname = "date_till";

Are you sure your specific field has the same name date_till as my sample field?

Are there any red errors in console?

You are right, default date picker (combination of three <select/> -boxes) shows date-clear-button, even if the field is required. In many situations this makes sense to me, because it is faster to click that button instead of selecting empty option three times. Anyway, you can use the following Jav...

Thank you! Glad you like it!

You may check out the insertXYZ() -functions documented here: https://www.appgini.de/docs/Javascript-Library/detail-view/custom-content.html?h=insert Example var dv = AppGiniHelper.dv; // insert h4 above "created_by" field dv.getField("created_by").insertAbove().h4("Metadata"); // insert red alert b...

PS: I strongly recommend using a modern code editor with syntax highlighting such as (free) Visual Studio Code. Those tools automatically tell you there is something wrong: chrome_LHVHvqo4gF.png In your case there are two problems: You need to escape the single quote There is a comma missing at the ...