Search found 1040 matches

by pböttcher
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.

Code: Select all

If ($sendmail == 'Complete')
by pböttcher
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?
by pböttcher
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...
by pböttcher
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:

Code: Select all

$j(function() {
$j('th').css('text-align','center');
})
by pböttcher
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.
by pböttcher
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.
by pböttcher
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.
by pböttcher
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);
by pböttcher
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
category.PNG
category.PNG (22.61 KiB) Viewed 154 times
You need to have a lookup from the category to the animals table (but I assume you have that already)
by pböttcher
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...
by pböttcher
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...
by pböttcher
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

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>";
by pböttcher
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.
by pböttcher
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.
by pböttcher
2020-10-13 16:21
Forum: Getting Started
Topic: user to swap permissions easily
Replies: 8
Views: 195

Re: user to swap permissions easily

Hi,

mybe this helps (read till the end)

viewtopic.php?t=2811
by pböttcher
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...
by pböttcher
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...
by pböttcher
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 #

Code: Select all

SELECT `superviseur`.`telephone` FROM `superviseur`
LEFT JOIN `stage` ON `superviseur`.`id` = `stage`.`cosupernom`
WHERE `stage`.`id` = %ID%
by pböttcher
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#
by pböttcher
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.
by pböttcher
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...
by pböttcher
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...
by pböttcher
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.
by pböttcher
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).