Search found 64 matches

by rpierce
2021-03-12 16:20
Forum: Tips And Tricks
Topic: Modify Date Time Picker
Replies: 0
Views: 162

Modify Date Time Picker

Is it possible to move the buttons in the Date picker from the right hand side to the left hand side? Since virtually all of the input clicking is on the left hand side of AppGini forms why not also have this item on the left?
date-picker.JPG
date-picker.JPG (14.12 KiB) Viewed 162 times
by rpierce
2021-03-10 18:28
Forum: Tips And Tricks
Topic: scrollable table in table view
Replies: 20
Views: 6359

Re: scrollable table in table view

Where exactly in the hooks/tablename table view do you insert the code?

switch($contentType){
case 'tableview':
$header='';
break;
by rpierce
2021-03-10 18:25
Forum: Tips And Tricks
Topic: scrollable table in table view
Replies: 20
Views: 6359

Re: scrollable table in table view

How can I increase the number of records displayed. The most I can show now is 500 rows
by rpierce
2021-03-08 15:55
Forum: Advanced Customizations > Hooks
Topic: Color Record Row in Table View Based on Field Value
Replies: 42
Views: 15422

Re: Color Record Row in Table View Based on Field Value

That seems to be doing the trick!!! Thank you for taking the time to look into this. You're awesome....
by rpierce
2021-03-07 19:39
Forum: Advanced Customizations > Hooks
Topic: Color Record Row in Table View Based on Field Value
Replies: 42
Views: 15422

Re: Color Record Row in Table View Based on Field Value

federico, Yes, the table name is 'audit' and the field name is 'saf_un'. As mentioned earlier, the code works great at changing the row color while I'm in audit table view. So the tablename and field must be correct there. the issue when I have a project detail displayed and click on the tab below (...
by rpierce
2021-03-07 04:59
Forum: Advanced Customizations > Hooks
Topic: Color Record Row in Table View Based on Field Value
Replies: 42
Views: 15422

Re: Color Record Row in Table View Based on Field Value

zibrahim, I use the following code in footer-extras for table view to allow scrolling through many records and keeping the header row visible. I also have the code being discussed in this thread for changing row background colors based on criteria in teh footer-extras. When I scroll through 500 reco...
by rpierce
2021-03-06 20:48
Forum: Advanced Customizations > Hooks
Topic: Color Record Row in Table View Based on Field Value
Replies: 42
Views: 15422

Re: Color Record Row in Table View Based on Field Value

federico,

I put your script into footer-extras and still have the correct row color in table view but not in detail+table view.

Ray
by rpierce
2021-03-06 16:44
Forum: Advanced Customizations > Hooks
Topic: Color Record Row in Table View Based on Field Value
Replies: 42
Views: 15422

Re: Color Record Row in Table View Based on Field Value

I have the code working as it is written in my app. the screen shots I meant to show everyone didn't come through so here they are again. As oyu can see, the color code works in table view as I have it now. I just need to figure out how to make it appear in the combination detail and table view. aud...
by rpierce
2021-03-06 05:07
Forum: Advanced Customizations > Hooks
Topic: Color Record Row in Table View Based on Field Value
Replies: 42
Views: 15422

Re: Color Record Row in Table View Based on Field Value

Once again I ask of our magnanimous coders: I have been working on this issue for my app also. I have managed to get code from this thread or another thread along the same lines working to a certain degree but wonder if anyone can help with a bit more.... I can get the rows in my table to turn Red a...
by rpierce
2021-03-05 19:54
Forum: Tips And Tricks
Topic: Change row colour from drop down menu. Please help!
Replies: 21
Views: 6507

Re: Change row colour from drop down menu. Please help!

Is there a way to change the color of an entire row in table view based on the condition of a radio button. Red if "unsafe" Green if "Safe"??
by rpierce
2021-03-04 23:32
Forum: Advanced Customizations > Others
Topic: Lookup Field Advance Customization help
Replies: 3
Views: 1093

Re: Lookup Field Advance Customization help

I don't see the "Filter by" option on my app. I'm using version 5.94 rev 1132
by rpierce
2021-03-02 19:40
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

The code above is working! I get an email to all the addresses in my table. This is great!! One question....what do you mean by your note?: "and paste the trace.txt file that should be in the main directory for your app." I see that file (trace.txt) now exists in my main app directory as you said. B...
by rpierce
2021-03-02 17:25
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Hi Again, Using that code there is no email message sent. When I modify it as below, I get a single email. It only sends to the first address in the table. $receipt=array ($response =sqlValue("SELECT email_address FROM eaddress",$eo)); while ($row = db_fetch_assoc($reponse )) { $receipt[] = $row['em...
by rpierce
2021-03-01 23:11
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Actually, I did change the code. It is currently commented out in the sample I included in my prior message above. When I uncomment the code I only get a single email message sent. When I include the code exactly as written I get no email: $receipt=array(); $response =sql("SELECT email_address FROM ...
by rpierce
2021-03-01 15:59
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Here is the current code with the array that calls for a query on the database commented out. As it is configured in this code, the email goes out to the two addresses. My assumption is that in sendmail the addresses must be comma delimited and have the quotes that are in the manual array. Just gues...
by rpierce
2021-03-01 15:41
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

I get the two messages when I use my manually created hooks array, but not when I use the array which involves a query on the database. Whenever I attempt to go that route only the first email address in the table is sent. When I initially tried the code you provided and got two messages I thought i...
by rpierce
2021-03-01 04:24
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

I may have jumped the gun,

I forgot to comment out the existing array code which is a list of emails entered manually into the hook file. Is there a better way to do this? Should I even be using sendmail?

I am still only getting a single message to go out.

Ray
by rpierce
2021-03-01 00:33
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

@ pböttcher,

that did it!! Please explain what that function is. I tried to find it online but there are so many conflicting things said that I have no idea what I just did.

Thanks to all of you for helping me with this......until the next one!!
Ray
by rpierce
2021-02-23 22:53
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Great!! Forward progress!! Initially I did not get the email after submitting the form. I modified the code a tiny bit and email came through, but only the first address in the table got an email. I assume that I somehow need to get a comma delimiter into the code somehow?? I tried adding a comma in...
by rpierce
2021-02-23 19:23
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Hello, The entire hook "incident after insert" is included here. The array code has been commented out for testing of the new code you have suggested. The array works fine, but I want to be able to allow the end user to specify the email addresses so that I don't have to go into the hooks and update...
by rpierce
2021-02-23 16:21
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

@ pbottcher,

Hi again. I added the code you provided with the necessary changes and managed to have no error messages but the email did not send. I assume that I have the code in the wrong place??
by rpierce
2021-02-23 00:07
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Hi pbottcher, I am including the entire hook code in hopes you will show me how to implement your suggestion. Thank you for offering your help. Ray [code function incident_after_insert($data, $memberInfo, &$args){ // to compose a message containing the submitted data, // we need to iterate through t...
by rpierce
2021-02-22 23:47
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Re: Populate an array from database

Hi Paul, Thank you for the questions. What I'm doing is trying to design the system so that admin users (not super admin) of the system can add and delete email addresses as projects change. (construction projects) If there is an incident or injury event and a report is completed using the App, cert...
by rpierce
2021-02-22 18:31
Forum: Advanced Customizations > Hooks
Topic: Populate an array from database
Replies: 24
Views: 826

Populate an array from database

Hi all, I'm using an array in Hooks to send an email to specified recipients when a form is submitted. Currently I have the email addresses of the recipients stored in the array within the hooks file: function tablename_before_insert $receipt=array('[email protected].com','[email protected].net'); ...