Search found 135 matches

by jsetzer
2019-05-22 20:36
Forum: Advanced Customizations > Hooks
Topic: create a "read more" link in a field in table view
Replies: 4
Views: 76

Re: create a "read more" link in a field in table view

Hi, you can try this in your TABLENAME-dv.js: // paste this in your TABLENAME-tv.js $j(function () { // change tablename, columnname and length of text var tbl = "wirtschaftseinheit_hinweise"; var col = "text"; var limit = 100; // do not change below var ix = 0, i = $j("<i/>").addClass("glyphicon gl...
by jsetzer
2019-05-22 13:31
Forum: Getting Started
Topic: How to use username/id in lookup?
Replies: 2
Views: 38

Re: How to use username/id in lookup?

Create a view "view_members" using your SQL tool. Add a table "view_members" to appGini with identical columnnames and data types. Use the table as lookup source. Generate your app.
by jsetzer
2019-05-17 10:01
Forum: Advanced Customizations > Hooks
Topic: "none" appears in the option list field with "realized" default option
Replies: 2
Views: 89

Re: "none" appears in the option list field with "realized" default option

Please check if you have set "[x] Required" for that field.

Regards,
Jan
by jsetzer
2019-05-15 19:33
Forum: Tips And Tricks
Topic: Hide field depending user group
Replies: 18
Views: 219

Re: Hide field depending user group

Do eoc and EOC match in your code? In your forum post they don't.
by jsetzer
2019-05-08 15:25
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 346

Re: Order by date if lookup field

I am sorry if my assumption was wrong. I did not want to annoy anyone, sorry if I did! :oops: I agree with pböttcher: we all could help better, if we knew the tablenames, column-names and foreign keys. Sometimes a screenshot would be helpful. If it works, pböttcher's "order by" solution is the short...
by jsetzer
2019-05-08 13:12
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 346

Re: Order by date if lookup field

You already got two solutions ;) :D
by jsetzer
2019-05-08 11:05
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 346

Re: Order by date if lookup field

Please check the posts' authors. The 2nd proposal is not mine - and I'm afraid the 2nd will not work on lookup fields.

Regards,
Jan
by jsetzer
2019-05-08 07:48
Forum: Advanced Customizations > Hooks
Topic: How to add Bcc in mail
Replies: 3
Views: 137

Re: How to add Bcc in mail

Hi, AppGini's sendMail -function in incFunction.php does not support CC or BCC, yet (Ver. 5.75), allthough the PHPMailer class being used, does. I have asked Ahmed to support CC and BCC. I think it's on his roadmap. In between I have solved it this way: Copy the sendMail-function from incFunction.ph...
by jsetzer
2019-05-07 13:10
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 346

Re: Order by date if lookup field

I have though about and tried different approaches. No easy solution at the moment. But you can check out the following workaround: Add an additional field with datatype = datetime and the data format according to you local settings Set the additional field to "[X] Hide in detail view" If you like s...
by jsetzer
2019-05-07 12:16
Forum: Bugs/annoyances
Topic: Portnumber in HTTPS-URL on 'Save' in Admin
Replies: 2
Views: 208

Re: Portnumber in HTTPS-URL on 'Save' in Admin

Never seen this in my AppGini environments before. :shock: Can you please tell me which port you are using (if not 80). Does this only happen when you start the app from... https://myURL.nl:80/ or does this even happen when you start from https://myURL.nl/ If second, you will need to find out when a...
by jsetzer
2019-05-05 17:49
Forum: Bugs/annoyances
Topic: start_session error
Replies: 11
Views: 196

Re: start_session error

Great, Mike! :)

Glad that you've found a solution.

Best,
Jan
by jsetzer
2019-05-05 11:24
Forum: Bugs/annoyances
Topic: start_session error
Replies: 11
Views: 196

Re: start_session error

1. Can you please confirm that your file hooks/directorylinks.php starts with... <?php define('PREPEND_PATH', '../'); ... ...now. 2. Your previous error message says "... in line 83". After your recent changes there should be a different line number. Can you please check that. 3. Is it possible to s...
by jsetzer
2019-05-05 10:30
Forum: Advanced Customizations > Others
Topic: Edit rights
Replies: 9
Views: 212

Re: Edit rights

My typo, sorry! Cannot edit the original post, so here is the updated SQL code: select membership_grouppermissions.tablename as 'tablename', count(*) as 'num_editors', group_concat(membership_users.memberID ORDER BY membership_users.memberID SEPARATOR ', ') as 'editors' from membership_grouppermissi...
by jsetzer
2019-05-03 19:12
Forum: Feature Suggestions
Topic: Duplicate fields
Replies: 3
Views: 158

Re: Duplicate fields

Would be nice, sure! For now you can use Copy & Paste buttons for fields (and even for whole tables): Select the column (or table) you wish to duplicate Copy the selected item AppGini_2019-05-03_21-01-46.png In case someone did not notice, yet: Have a look at the bottom right. There you will see wha...
by jsetzer
2019-05-03 08:49
Forum: Advanced Customizations > Others
Topic: Edit rights
Replies: 9
Views: 212

Re: Edit rights

Hi Barry, sure, have a look and try the following SQL command as a starting point: select membership_grouppermissions.tablename as 'tablename', count(*) as 'num_editors', group_concat(membership_users.memberID ORDER BY membership_users.memberID SEPARATOR ', ') as 'editors' from membership_grouppermi...
by jsetzer
2019-05-03 04:02
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 346

Re: Order by date if lookup field

Good morning, Fabiano,

can you please check the datatype of the date column. If this is 'date' sorting should be fine. If this is varchar you should change it to 'date'.

Hope this helps!
Regards
Jan
by jsetzer
2019-05-03 03:57
Forum: Bugs/annoyances
Topic: start_session error
Replies: 11
Views: 196

Re: start_session error

Remove <html> and <body>. You dln't need them here. Then move the rest below the lasr bracket }
Best,
Jan
by jsetzer
2019-05-02 15:35
Forum: Bugs/annoyances
Topic: start_session error
Replies: 11
Views: 196

Re: start_session error

I once had such an error when I was debugging some variables using var_dump($xyz) too early in my code. After I have moved my debug output into one of the hook functions everything was fine.

Best,
Jan
by jsetzer
2019-05-01 14:53
Forum: Feature Suggestions
Topic: Change values in the tableview without opening the detailview
Replies: 2
Views: 93

Re: Change values in the tableview without opening the detailview

Have a look at the contenteditable-attribute:

https://www.w3schools.com/tags/att_glob ... itable.asp

In combination with some client side AJAX and server side PHP you should be able to POST data to the server and update your database.

Regards,
Jan
by jsetzer
2019-04-28 13:43
Forum: Advanced Customizations > Hooks
Topic: Update only if in a specific group
Replies: 3
Views: 112

Re: Update only if in a specific group

Try var_dump($complete); exit(); to check return value of sqlValue call
by jsetzer
2019-04-11 14:06
Forum: Advanced Customizations > Others
Topic: Field for electronic signature
Replies: 9
Views: 3215

Re: Field for electronic signature

It's tricky, but finally I have managed to turn AppGini text-fields into Signature Pad areas: ezgif.com-optimize (1).gif Create a field (datatype = Text) in your TABLENAME Publish your app and ensure all fields have been rebuilt Include the JavaScript library from their CDN: https://www.jsdelivr.com...
by jsetzer
2019-04-11 09:08
Forum: Advanced Customizations > Others
Topic: Field for electronic signature
Replies: 9
Views: 3215

Re: Field for electronic signature

Stand by, I will have a look today.

Kind regards,
Jan
by jsetzer
2019-04-10 08:54
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 518

Re: Readonly, but not for a specific group

OK, no problem - there is no stupid question! In your browser open the developer tools. Press F12 -key on your keyboard. This should work in most modern browsers eg. Chrome. After a couple of seconds there will be an additional panel on the right hand side or at the bottom. There will be several tab...
by jsetzer
2019-04-10 06:51
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 298

Re: Changing Color - Has anyone got this to work?

Hmmm, strange. Can you please check the console output in you browser's developer tools to see if there is any javascript error and also check if any bootstrap-related file (css/js) could not be loaded. If there is no error, you should ensure that your script get's executed at all for example by ins...