just retrieve the status field instead of the emailadvice .
then use e.g.
Code: Select all
If ($sendmail == 'Complete')Search found 1040 matches
- 2020-10-30 21:43
- Forum: Advanced Customizations > Hooks
- Topic: Send email on status change
- Replies: 1
- Views: 18
Re: Send email on status change
Hi,
just retrieve the status field instead of the emailadvice .
then use e.g.
just retrieve the status field instead of the emailadvice .
then use e.g.
- 2020-10-30 21:37
- Forum: Getting Started
- Topic: user to swap permissions easily
- Replies: 8
- Views: 195
Re: user to swap permissions easily
What code do you have for calling the chagee_group.php?
- 2020-10-30 21:32
- Forum: Tips And Tricks
- Topic: Filter table based on another table
- Replies: 1
- Views: 42
Re: Filter table based on another table
Hi David, maybe one idea is: Create a table to the favorits with a field for the pk of your recipe and a field for the user. Add a field to the recipe for the favorite selection. Once the user selects the favorite field and stores the record, store the information in the favorits table and set the f...
- 2020-10-23 20:57
- Forum: Advanced Customizations > Hooks
- Topic: How to Change Position of Column Label?
- Replies: 2
- Views: 77
Re: How to Change Position of Column Label?
Hi,
you can do that via the hooks/TABLENAME-tv-js file.
Add:
you can do that via the hooks/TABLENAME-tv-js file.
Add:
Code: Select all
$j(function() {
$j('th').css('text-align','center');
})- 2020-10-22 20:36
- Forum: Getting Started
- Topic: Lookup Field with autofill from multiple tables
- Replies: 2
- Views: 56
Re: Lookup Field with autofill from multiple tables
Hi,
maybe you can put up an example of what you try to achieve. I did not get it yet.
maybe you can put up an example of what you try to achieve. I did not get it yet.
- 2020-10-22 20:34
- Forum: Getting Started
- Topic: <!-- creatorGroup --> to appear straightaway
- Replies: 1
- Views: 71
Re: <!-- creatorGroup --> to appear straightaway
Hi,
as far as I know, there is no reference to the group of the user in the "create" page.
Add some javascript code to the page to populate the field with the groupname. This can be done in the hooks/TABLENAME.php -> TABLENAME-dv function. Expand the html with the necessary code.
as far as I know, there is no reference to the group of the user in the "create" page.
Add some javascript code to the page to populate the field with the groupname. This can be done in the hooks/TABLENAME.php -> TABLENAME-dv function. Expand the html with the necessary code.
- 2020-10-19 17:00
- Forum: Advanced Customizations > Hooks
- Topic: Upload more than one photo
- Replies: 1
- Views: 87
Re: Upload more than one photo
Hi,
not right away. You would need to create a child table that holds the photos is you want to have more than 1.
Each record can hold one photo per field.
An alternativ is to create more than one field within that record to hold more photos.
not right away. You would need to create a child table that holds the photos is you want to have more than 1.
Each record can hold one photo per field.
An alternativ is to create more than one field within that record to hold more photos.
- 2020-10-17 16:03
- Forum: Getting Started
- Topic: combining data from more than one table
- Replies: 14
- Views: 325
Re: combining data from more than one table
try
$origin=sqlvalue("SELECT origin from full_schedule where id=".$selectedID);
redirect($origin."_view.php?SelectedID=".$selectedID);
$origin=sqlvalue("SELECT origin from full_schedule where id=".$selectedID);
redirect($origin."_view.php?SelectedID=".$selectedID);
- 2020-10-17 12:59
- Forum: Advanced Customizations > Others
- Topic: sort combo box
- Replies: 4
- Views: 176
Re: sort combo box
Hi,
you can use the filter on the setting
You need to have a lookup from the category to the animals table (but I assume you have that already)
you can use the filter on the setting
- category.PNG (22.61 KiB) Viewed 154 times
- 2020-10-16 19:07
- Forum: Getting Started
- Topic: combining data from more than one table
- Replies: 14
- Views: 325
Re: combining data from more than one table
Hi, if you use CREATE VIEW full_schedule AS SELECT `ID`, `date`, `title` FROM meetings UNION ALL SELECT `ID`, `date`, `title` FROM study_visits and have in meeting e.g. ID=1, date=16.10.2020 and title = meeting and in study_visits e.g. ID=1, data=16.10.2020 and title = study. You will have in the vi...
- 2020-10-15 18:02
- Forum: Getting Started
- Topic: user to swap permissions easily
- Replies: 8
- Views: 195
Re: user to swap permissions easily
Hi, actually it does exactly what you want. You need to add your member to both groups in the group table. Why the href is not working is hard to say without knowing your environment. On my testsystem it works just fine. In the link you show http://xoa143t/ your host sounds strange. Is your host xoa...
- 2020-10-14 19:24
- Forum: Getting Started
- Topic: user to swap permissions easily
- Replies: 8
- Views: 195
Re: user to swap permissions easily
Hi,
can you try to change the statement in the hooks/header_extras.php file to
can you try to change the statement in the hooks/header_extras.php file to
Code: Select all
$output .= "<li><a href=\"http://{$host}/{$appURI}/change_group.php?User=".$user."&Group=".$row['groupname']."\"> <small><em>".$row['groupname']."</em></small></a></li>";- 2020-10-13 17:19
- Forum: Tips And Tricks
- Topic: Create Multiple Records in a Table from one form
- Replies: 2
- Views: 143
Re: Create Multiple Records in a Table from one form
Hi,
yes, you can do that in the after_insert hook. Create your sql statement to insert the record in the table an call the sql/sqlvalue function to execute it.
yes, you can do that in the after_insert hook. Create your sql statement to insert the record in the table an call the sql/sqlvalue function to execute it.
- 2020-10-13 16:29
- Forum: Getting Started
- Topic: combining data from more than one table
- Replies: 14
- Views: 325
Re: combining data from more than one table
Hi,
if your ID make it possible to identify from which table the record comes, you can use that logic, or
if you add the origin table to the record you could retrieve that information together with the selected id and redirect in the hooks/VIEW.php view_dv function directly to your desired page.
if your ID make it possible to identify from which table the record comes, you can use that logic, or
if you add the origin table to the record you could retrieve that information together with the selected id and redirect in the hooks/VIEW.php view_dv function directly to your desired page.
- 2020-10-13 16:21
- Forum: Getting Started
- Topic: user to swap permissions easily
- Replies: 8
- Views: 195
- 2020-10-12 16:10
- Forum: Advanced Customizations > Others
- Topic: Logoff in all users
- Replies: 3
- Views: 189
Re: Logoff in all users
Hi, you could use a session variable, set it to the logout time of the day (or next day if you are already later) and check in the header-extras.php if that session variable is set and the current time is greater than the time if. If so, reset the variable and force the logout (redirect to the signO...
- 2020-10-11 16:56
- Forum: Getting Started
- Topic: AG 5.8: Help with SQL to retrieve single value
- Replies: 6
- Views: 140
Re: AG 5.8: Help with SQL to retrieve single value
Hi, in order to circumvent your problem I would suggest that you create multiple views to the original table. Create the view view_supervisor in the database as select * from superviseur Then create a table view_supervisor as a copy of the supervisor table. Now reference (lookup) the stage.cosuperno...
- 2020-10-11 09:19
- Forum: Getting Started
- Topic: AG 5.8: Help with SQL to retrieve single value
- Replies: 6
- Views: 140
Re: AG 5.8: Help with SQL to retrieve single value
Hi,
please use % instead of #
please use % instead of #
Code: Select all
SELECT `superviseur`.`telephone` FROM `superviseur`
LEFT JOIN `stage` ON `superviseur`.`id` = `stage`.`cosupernom`
WHERE `stage`.`id` = %ID%- 2020-10-10 17:29
- Forum: Getting Started
- Topic: AG 5.8: Help with SQL to retrieve single value
- Replies: 6
- Views: 140
Re: AG 5.8: Help with SQL to retrieve single value
Hi,
try
select people.phone from people left join event on event.assistant_name=people.id where event.id=#ID#
try
select people.phone from people left join event on event.assistant_name=people.id where event.id=#ID#
- 2020-10-10 06:34
- Forum: Getting Started
- Topic: if that field says X, make this field default Y
- Replies: 3
- Views: 152
Re: if that field says X, make this field default Y
Hi,
yes you are, you should add the selected row in your statement.
Something like
WHERE group=meetings.group and id=$data['id']
assuming your PK is id.
yes you are, you should add the selected row in your statement.
Something like
WHERE group=meetings.group and id=$data['id']
assuming your PK is id.
- 2020-10-08 19:22
- Forum: Getting Started
- Topic: if that field says X, make this field default Y
- Replies: 3
- Views: 152
Re: if that field says X, make this field default Y
Hi, you could use the after_insert hook for that. Update the just inserted record according to your logic for the Group field. It depends where you want to hold your mapping fo UK Editor -> UK, France Editor -> France , etc. Either create a separate table for that (so you can retrieve the matching e...
- 2020-10-07 21:59
- Forum: Tips And Tricks
- Topic: Add Appgini Navbar to frontend Page
- Replies: 1
- Views: 153
- 2020-10-07 18:36
- Forum: Advanced Customizations > Hooks
- Topic: Custom Print Layout
- Replies: 1
- Views: 93
Re: Custom Print Layout
Hi, assuming that you have all those fields on that page, you can use customize the templates/table_templatesDV table_templatesDVP to your needs. Just remember that if you recreate your app those files will be overwritten, unless you make the read only. Another solution would be to customize your pa...
- 2020-10-04 12:03
- Forum: Advanced Customizations > Others
- Topic: Move Fields to different table
- Replies: 4
- Views: 161
Re: Move Fields to different table
Hi,
the after_update hook is automatically called after an update of the record has been made. So you can put your code within the hook and it will get executed.
the after_update hook is automatically called after an update of the record has been made. So you can put your code within the hook and it will get executed.
- 2020-10-03 19:19
- Forum: Advanced Customizations > Others
- Topic: Move Fields to different table
- Replies: 4
- Views: 161
Re: Move Fields to different table
Hi,
yes, you can use the after_update hook, test for your status and when the status is active, copy the record to the other table and remove it from the original (if that is what you want).
yes, you can use the after_update hook, test for your status and when the status is active, copy the record to the other table and remove it from the original (if that is what you want).