Search found 44 matches

by bruceholt
2019-08-03 04:57
Forum: Tips And Tricks
Topic: Allow Google Crawler Access
Replies: 2
Views: 89

Re: Allow Google Crawler Access

Thanks Olaf, I will try that.

Regards, Bruce
by bruceholt
2019-08-01 10:15
Forum: Tips And Tricks
Topic: Allow Google Crawler Access
Replies: 2
Views: 89

Allow Google Crawler Access

I am trying to allow Google login access but cannot get it to work. I have tried to user :username" and also "memberID" as one of the paremeters and "password' as the password paremeter. I have set the "Restricted directory or URL as https://www.mydomain.com/appgini for example and the login URL as ...
by bruceholt
2019-07-14 03:40
Forum: Advanced Customizations > Others
Topic: Date display format in detail view
Replies: 2
Views: 129

Re: Date display format in detail view

I do realise that you can replace <%%COMBO(date)%%> with <input type="date" class="form-control"> but the problem is that UK version is dd/mm/yyyy format while US is mm/dd/yyyy which is why I would like to have it display like the picture below. https://www.kurraglenindustries.com.au/testing/appgini...
by bruceholt
2019-07-14 02:09
Forum: Advanced Customizations > Others
Topic: Date display format in detail view
Replies: 2
Views: 129

Date display format in detail view

Hi, I have searched this forum and on the net but failed to find a simply answer to do problem of getting the date to display in one cell instead of the three. One issue with the three is that on different screen sizes, too much of either the day, month or year is hidden and also takes up too much r...
by bruceholt
2019-07-12 11:18
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Re: Count for only users records

Thanks very much pböttcher.

That worked perfectly.

Regards, Bruce
by bruceholt
2019-07-12 08:06
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Re: Count for only users records

Hi pböttcher,

Is this what you mean?

Image
by bruceholt
2019-07-11 08:24
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Re: Count for only users records

Hi,

Yes, the records are owned by the user. They are not viewed by anyone else other than the user. The tasks are for the user only to be used as reminders to themselves. The table is tasks. I hope that helps. Thanks, Bruce
by bruceholt
2019-07-10 09:57
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Re: Count for only users records

Hi, Oddly, it is showing all of the uncompleted tasks belonging to other members when logged in as admin but 0 when a user is logged in even though the user has tasks which are not completed. What I have is: <?php echo sqlvalue("select count(1) from tasks left join membership_userrecords on recid=ta...
by bruceholt
2019-07-09 08:06
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Re: Count for only users records

Hi pböttcher, I have modified the homepage with and have some text that says "Good evening "user", you have 2 task(s) to complete. You have 1 equipment that the repair or maintenance is not completed and 1 equipment that need attention." The tasks for example has a check box to indicate if the task ...
by bruceholt
2019-07-08 09:26
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Re: Count for only users records

Hi pböttcher ,

Sorry I don't understand. :(
by bruceholt
2019-07-07 02:26
Forum: Advanced Customizations > Others
Topic: Count for only users records
Replies: 12
Views: 308

Count for only users records

Hi all, I have a modified home page which shows a user how many tasks he/she has uncompleted but it is showing all open tasks from all users. The code I am using is: <?php echo sqlValue("select count(1) from tasks WHERE completed IS NULL"); ?> Can I limit it to only the users records? Regards, Bruce
by bruceholt
2019-06-29 09:21
Forum: Advanced Customizations > Hooks
Topic: Calculate and display days between 2 dates
Replies: 4
Views: 276

Re: Calculate and display days between 2 dates

Hi pböttcher,

That worked beautifully. Thank you very much for your help again.

Bruce
by bruceholt
2019-06-29 03:47
Forum: Advanced Customizations > Hooks
Topic: Calculate and display days between 2 dates
Replies: 4
Views: 276

Re: Calculate and display days between 2 dates

Hi pböttcher,

Thanks for your reply but for some reason that confused me. What I am wanting to do is work out the days between two dates and hopefully store it in "days_in"

Sorry to be a pain.

Thanks, Bruce
by bruceholt
2019-06-16 07:39
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 417

Re: User allowed to set desired start page

Thanks very much Olaf, I really appreciate your help. I'll keep playing around and see how I go with it.
by bruceholt
2019-06-16 03:34
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 417

Re: User allowed to set desired start page

Hi Olaf,

I have set up the tables (as per your second suggestion) as shown in the attached image, but I am confused where I go from here. How do I allow each user to select just one page to be redirected to?

Image
by bruceholt
2019-06-16 00:59
Forum: Advanced Customizations > Hooks
Topic: Calculate and display days between 2 dates
Replies: 4
Views: 276

Calculate and display days between 2 dates

Hi, I am trying to calculate numbers of days between 2 dates. In the table named "livestock_movements", "date_in" is the start date and "date_out" is the end date. I have a field named "days_in" which I would like to show the days between the two dates, but can't get it to work. I have in the hooks ...
by bruceholt
2019-06-14 09:40
Forum: AppGini Plugins
Topic: Profile image plugin
Replies: 5
Views: 1839

Re: Profile image plugin

Hi landinialejandro,

I just downloaded and installed your plugin but it returns errors. It appears to be missing the loader.php file.


Image
by bruceholt
2019-06-13 09:19
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 417

Re: User allowed to set desired start page

Hi pbötcher and Olaf,

I will try this out, hopefully on the weekend, and let you both know how I went.
by bruceholt
2019-06-11 08:02
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 417

Re: User allowed to set desired start page

Hi,

I was thinking of creating a table which the user can select from a drop down list of the main table view tables. I might be making things more difficult than they need to be?
by bruceholt
2019-06-09 22:15
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 417

Re: User allowed to set desired start page

Thanks for the reply.

I'm a bit of a hack and not an expert. Any ideas on how to implement this?
by bruceholt
2019-06-09 07:51
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 417

User allowed to set desired start page

I am wanting to allow users select their own start page after signing in. Instead of redirecting to index.php, they can select from a list of pages in a table and save their preference so that when they log in, they are automatically redirected to that page. I am wondering if the _global.php hooks f...
by bruceholt
2019-06-09 00:09
Forum: Getting Started
Topic: Have a trigger to Auto Create a Database Table
Replies: 7
Views: 886

Re: Have a trigger to Auto Create a Database Table

Has anyone managed to work out how to do this as I, and probably many others would like to do it. The problem with only one big table I think, is that if there is an issue with the database, you could potentially loose everything.
by bruceholt
2018-10-29 19:51
Forum: Advanced Customizations > Hooks
Topic: What does "makeSafe($data" do?
Replies: 2
Views: 461

Re: What does "makeSafe($data" do?

Thanks for that, Jan.
by bruceholt
2018-10-29 05:02
Forum: Advanced Customizations > Hooks
Topic: What does "makeSafe($data" do?
Replies: 2
Views: 461

What does "makeSafe($data" do?

Hoping someone can help me understand what "makeSafe($data" is for in the some hooks files.

Example:

Code: Select all

$email = sqlValue("select email from customer where id='" . makeSafe($data['customer_name']) . "'");
by bruceholt
2018-10-29 04:58
Forum: Advanced Customizations > Hooks
Topic: Email multiple people after update hook
Replies: 4
Views: 730

Re: Email multiple people after update hook

Thanks all working now but I'm not sure what I did :?