Search found 1435 matches

by jsetzer
2022-08-07 17:19
Forum: Advanced Customizations > Others
Topic: Lookup Field
Replies: 11
Views: 193

Re: Lookup Field

but could not see any lookup arrow button Sorry, I meant the button in DV which opens the select list of the lookup field you are referring to. In other words: open the lookup by clicking it. This should force the client to request available lookup-entries from the server. You will see the network ...
by jsetzer
2022-08-06 18:02
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 117

Re: getting 500 on ajax call, any hints?

Just checked code (of AG 22.14)

sql()-Function

Requires 2nd parameter $o

Code: Select all

function sql($statement, &$o) {
    // ...
}
sqlValue()-function

Optional 2nd parameter, defaults to NULL

Code: Select all

function sqlValue($statement, &$error = NULL) {
    // ...
}

by jsetzer
2022-08-06 17:59
Forum: Tips And Tricks
Topic: getting 500 on ajax call, any hints?
Replies: 9
Views: 117

Re: getting 500 on ajax call, any hints?

Don't know if it helps on that specific problem: sql('SQL COMMAND', $eo); requires $error variable as 2nd parameter. Maybe 500 is being raised due to missing parameter in given PHP version (behaviour could be different depending on PHP version). If I remember right, this is different from sqlValue()...
by jsetzer
2022-08-05 14:27
Forum: Advanced Customizations > Others
Topic: Lookup Field
Replies: 11
Views: 193

Re: Lookup Field

- F12 - Open network tab - Click lookup arrow button and watch out for the ajax_combo.php call, listed in network tab (You can even filter on ajax_combo) - select the entry and check payload and response There may be an error or there may be an empty result. Can you post some relevant screenshots of...
by jsetzer
2022-08-04 20:11
Forum: AppGini Plugins
Topic: AppGiniHelper logOutUser();
Replies: 3
Views: 78

Re: AppGiniHelper logOutUser();

Should be possible. But I guess there is a simpler way to close session at a certain time.
by jsetzer
2022-08-04 20:03
Forum: AppGini Plugins
Topic: AppGiniHelper logOutUser();
Replies: 3
Views: 78

Re: AppGiniHelper logOutUser();

Hi, thanks for your nice feedback. The indicators lib is meant for recurring display of values, calculated on serverside, in browser. I never thought about controlling the current session depending on time. I hope someone else can contribute php code for automatic sign-out. That code should be integ...
by jsetzer
2022-08-04 11:36
Forum: Advanced Customizations > Others
Topic: Lookup Field
Replies: 11
Views: 193

Re: Lookup Field

Next step could be watching the network traffic between browser and server in browser's development tooks when fetching records on opening dropdown. What is the server response?
by jsetzer
2022-08-04 04:27
Forum: Advanced Customizations > Others
Topic: Lookup Field
Replies: 11
Views: 193

Re: Lookup Field

For narrowing down, take that SQL command and run it in your SQL tool (for example adminer or phpMyAdmin). See if it works at all.
by jsetzer
2022-08-03 21:19
Forum: Advanced Customizations > Others
Topic: Lookup Field
Replies: 11
Views: 193

Re: Lookup Field

Maybe I did not understand. I understood lookup does NOT work when you disable default query in advanced lookup settings and enter a custom sql query. The custom query should be a SQL command, not a php array as given in your last post.
by jsetzer
2022-08-03 17:13
Forum: Getting Started
Topic: Cant Delete records
Replies: 3
Views: 91

Re: Cant Delete records

Perhaps check out this old forum article about displaying all permissions through a SQL query: https://forums.appgini.com/phpbb/viewtopic.php?t=2803 TL;DR select `membership_groups`.`name` as 'group_name', `membership_grouppermissions`.`tableName` as 'table_name' , case when `membership_grouppermiss...
by jsetzer
2022-08-03 17:10
Forum: Getting Started
Topic: Cant Delete records
Replies: 3
Views: 91

Re: Cant Delete records

Click your user name at the top-right (navbar). The user profile page will show all available tables and granted permissions for the current user.
by jsetzer
2022-08-03 14:42
Forum: Advanced Customizations > Others
Topic: Lookup Field
Replies: 11
Views: 193

Re: Lookup Field

Maybe an error in your customized SQL command. Can you post it here?
by jsetzer
2022-08-01 14:40
Forum: Feature Suggestions
Topic: Cascading Delete
Replies: 2
Views: 84

Re: Cascading Delete

Hmmm, should work. Can you check the following settings: Grant DELETE-permission on the subtables for the user's group who is deleting the master record Check the correct setup of the lookups (as those connect a subtable's records to a master record) Option [x] Delete records even if they have child...
by jsetzer
2022-07-30 20:56
Forum: AppGini Plugins
Topic: AppginiHelper
Replies: 11
Views: 373

Re: AppginiHelper

Indicators Library can be purchased at our shop here:

https://bizzworxx.onfastspring.com/
by jsetzer
2022-07-30 19:11
Forum: AppGini Plugins
Topic: AppginiHelper
Replies: 11
Views: 373

Re: AppginiHelper

Hi,

which one exactly are you referring to?

They are available at bigprof's Shop
Or at my shop here:

https://bizzworxx.onfastspring.com/
by jsetzer
2022-07-28 10:46
Forum: Bugs/annoyances
Topic: Appgini 5.71 and Mysql8
Replies: 6
Views: 126

Re: Appgini 5.71 and Mysql8

(1) What is the type and length of column InvDiasPdtem? (2) what is the value of colum FechaPago of saved record? (3) what is the value of column FFactura of saved record? Calculating the date difference between those two values gives a result, too large for the target field. In _before_insert you s...
by jsetzer
2022-07-26 16:56
Forum: Advanced Customizations > Hooks
Topic: Display popup after insert a new record in a table
Replies: 6
Views: 154

Re: Display popup after insert a new record in a table

Thanks for your feedback.
Did you try with the Browser-Notifications? Does it work for you?
by jsetzer
2022-07-26 16:54
Forum: Advanced Customizations > Others
Topic: Lock a row to prevent simultaneous access or editing
Replies: 15
Views: 6803

Re: Lock a row to prevent simultaneous access or editing

Hi everyone, based on the new Record Lock Library, there is an extension for configuring collaboration workflows. If you are interested, please check out the 2nd video (links below): Record Lock Library - Introduction https://youtu.be/EPK1TRPKUXM Record Lock Library - Collaboration Extension https:/...
by jsetzer
2022-07-25 12:18
Forum: Advanced Customizations > Hooks
Topic: Display popup after insert a new record in a table
Replies: 6
Views: 154

Re: Display popup after insert a new record in a table

Tipp

If your browser supports Notification API, check out this following Notification instead of the blocking browser Alert:

Code: Select all

$html .= '<script>new window.Notification("Inserted", {body: "'.htmlentities($_SESSION["DISPLAY_MESSAGE"]).'"});</script>';
by jsetzer
2022-07-25 12:03
Forum: Advanced Customizations > Hooks
Topic: Display popup after insert a new record in a table
Replies: 6
Views: 154

Re: Display popup after insert a new record in a table

Starting point for your own implementation, this is working for me: function TABLENAME_after_insert($data, $memberInfo, &$args) { $message = "I will be displayed once after insert"; $_SESSION["DISPLAY_MESSAGE"] = $message; return TRUE; } function TABLENAME_dv($selectedID, $memberInfo, &$html, &$args...
by jsetzer
2022-07-25 11:55
Forum: Advanced Customizations > Hooks
Topic: Display popup after insert a new record in a table
Replies: 6
Views: 154

Re: Display popup after insert a new record in a table

Possible Reason Well, just see the sequence of function calls when inserting a record: UI: You click #insert button Browser POSTs data to server AppGini code executes before_insert() -hook AppGini code inserts the record into the database AppGini code calls after_insert() -hook (here you echo "<scr...
by jsetzer
2022-07-25 11:39
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 13
Views: 316

Re: Save As Copy Not Working (child records)

if the $host variable is left as "localhost" This totally makes sense from technical point of view, as the internal function TABLENAME_copy_children() (in TABLENAME_dml.php ) uses cURL -commands, asynchronously executing multiple copy calls, which obviously need a valid and matching, correct URL. T...
by jsetzer
2022-07-22 11:07
Forum: Tips And Tricks
Topic: Single Edit ("Row Lock") - just hook and js nothing else!
Replies: 5
Views: 206

Re: Single Edit ("Row Lock") - just hook and js nothing else!

Thanks for you contribution!

Instead of adding such a feature and specific implementation to standard AppGini generated code and tables, personally I'd prefer having a plugin for such. If it was a plugin, we all could decide by ourselves if we want that feature or not. Just my 5 cents.
by jsetzer
2022-07-22 05:48
Forum: Advanced Customizations > Others
Topic: Button color based on query value
Replies: 1
Views: 50

Re: Button color based on query value

Assuming you have created a button using jQuery and already set the Bootstrap classes btn btn-default (and perhaps btn-md | btn-lg ), stored in variable YOURBUTTON : YOURBUTTON.removeClass('.btn-default').addClass('btn-success'); Or YOURBUTTON.removeClass('.btn-default').addClass('btn-danger'); Depe...
by jsetzer
2022-07-21 17:22
Forum: Advanced Customizations > Hooks
Topic: Conditionally show as read only to certain group
Replies: 6
Views: 149

Re: Conditionally show as read only to certain group

There are no field-level permissions in latest AG 22.14. You can use pure Javascript OR AppGini Helper Javascript Library for hiding or locking single fields. You will need some additional PHP code for finding out the current user/group and then, depending on user/group, dynamically write Javascript...