Search found 25 matches

by eagle
2017-03-02 21:07
Forum: Advanced Customizations > Hooks
Topic: Action buttons in detail view
Replies: 1
Views: 1434

Action buttons in detail view

I would like to always have the action buttons ( Save, Cancel etc) at the bottom of my detail view. Now those buttons appear to the left of the input fields if the screen is wide. If I make the screen narrower they move to the bottom, below the last input field. Is there an easy way to always make t...
by eagle
2017-02-16 00:17
Forum: Advanced Customizations > Hooks
Topic: Update fields if value is changed
Replies: 0
Views: 943

Update fields if value is changed

I have the following fields in my project: TextFieldA - Text SignatureA - Date TextFieldB - Text SignatureB - Date When a record is updated ( records are never created in this project - there are only existing records ) I want to do the folowing: If the content of TextFieldA is changed ( meaning tha...
by eagle
2016-12-30 07:43
Forum: Tips And Tricks
Topic: How large is too large for a project with AppGini ...
Replies: 15
Views: 7763

Re: How large is too large for a project with AppGini ...

Although, I have been thinking what if AppGini could feed itself by reading or importing directly a database (MySql that is) and not just importing tables as CSV files. That is because there are lots of tools for databse design which facilitates and makes a faster DB design than going through the s...
by eagle
2016-06-16 08:04
Forum: Getting Started
Topic: importing data with Danish letters
Replies: 1
Views: 1660

Re: importing data with Danish letters

Make sure that the CSV files has the right encoding. One way to do that is open the CSV file in LibreOffice Calc and save it as a new CSV file. Choose "Edit filter settings" when saving and choose "Unicode" as character set. Then try to import that file. ( "Edit filter settings", "Unicode" etc may b...
by eagle
2016-04-05 09:34
Forum: Getting Started
Topic: Restricted Records
Replies: 4
Views: 2260

Re: Restricted Records

I would guess that all of this is already built in and could be utilised by modifying the group / membership system. Have you looked at Admin area > Members > View members records? You could add group ownership to any single record and adjust visibility of that record in the Groups section. Have not...
by eagle
2016-03-13 10:31
Forum: Tips And Tricks
Topic: Search tool for pdf file contents
Replies: 3
Views: 2403

Re: Search tool for pdf file contents

Perhaps you could solve it by adding this library: http://www.pdfparser.org/ You could create a couple of new fields for each file - for example date_indexed and fulltext_extracted Then you could create a nightly php script to traverse all files in your database where date_indexed = NULL and store t...
by eagle
2016-03-10 08:24
Forum: Getting Started
Topic: Can autofill save the looked up value?
Replies: 2
Views: 1819

Re: Can autofill save the looked up value?

Thanks, shasta59.

Got it sorted by hiring some help.

>Why do you need this to work this way?

It was for a log table for archiving puposes.
by eagle
2016-03-10 08:22
Forum: Advanced Customizations > Others
Topic: import from SQL
Replies: 2
Views: 1603

Re: import from SQL

Does not AppGini > File > Import do this for you?
by eagle
2016-01-19 15:11
Forum: Getting Started
Topic: Can autofill save the looked up value?
Replies: 2
Views: 1819

Can autofill save the looked up value?

I would like to use someting like lookup + autofill, but instead of storing the id of the record in the parent table, the "looked up" value should be stored instead. Example: 1. In my orders table I have a lookup field called "Customer_name". This field looks up the customer name in my customer tabl...
by eagle
2015-12-15 12:15
Forum: Getting Started
Topic: Lock down some fields
Replies: 4
Views: 2497

Re: Lock down some fields

Thanks, Ahmad.

That worked much better :)
by eagle
2015-12-14 10:29
Forum: Getting Started
Topic: Lock down some fields
Replies: 4
Views: 2497

Re: Lock down some fields

Hi Ahmad,

Thanks for answering.

>You can set the order ID field as read-only in order details. That would effectively lock it.

I tried that, but then the field does not save. When adding a new item the order ID shows correct as read only field, but in database it is stored as NULL?
by eagle
2015-12-11 14:37
Forum: Getting Started
Topic: Lock down some fields
Replies: 4
Views: 2497

Lock down some fields

1. In the Northwind demo I create a new order. 2. I then click "Order items" to add items to this new order Please consider the following questions: A) Is is possible to "lock" the order ID field? When adding order items it is now possible to select other order ids. Can this be locked down, so that ...
by eagle
2015-12-08 08:36
Forum: Getting Started
Topic: Reminder Email
Replies: 1
Views: 1381

Re: Reminder Email

by eagle
2015-05-27 12:42
Forum: Getting Started
Topic: Make link in table view
Replies: 2
Views: 2046

Re: Make link in table view

Found the solution, so this topic can be closed.

Answer to #4 above is to edit the file \templates\x_template_TV.html
by eagle
2015-05-27 12:08
Forum: Getting Started
Topic: Make link in table view
Replies: 2
Views: 2046

Make link in table view

I need to build clickable links from the content of my field, in the table view. Example: 1) Table view of table X 2) The field 'mynumber' contains a text string (for example '156241') 3) Instead of simply displaying '156241' in my column i would like to make that number into a clickable link like t...
by eagle
2014-11-14 13:24
Forum: Getting Started
Topic: Comma as decimal point
Replies: 1
Views: 1900

Re: Comma as decimal point

I finally figured this one out :) Adding the following to the before_insert and before_update hooks will make it possible for the user to enter either 3.14 or 3,14 and it will work: $data['Price'] = str_replace(",",".",$data['Price']); If there is another way, w/o using hooks, I am still interested ...
by eagle
2014-11-13 16:44
Forum: Getting Started
Topic: Adding order items
Replies: 0
Views: 1421

Adding order items

1. In the Northiwind example I open an existing order. 2. The order items are shown below the order. 3. I can add another order item from that page, by using the "Add new" button in the "Order items tab". 4. After the new item is added ( by clicking "Save new" ) the popup window stays on top and I h...
by eagle
2014-11-13 16:27
Forum: Getting Started
Topic: Comma as decimal point
Replies: 1
Views: 1900

Comma as decimal point

I have a field of the decimal type with precition 2.

In Norway we use comma as decimal point, so my users enter "4,25" as a value.

This is then stored as 4.00 in the database.....

How can I make my application accept comma as decimal points?
by eagle
2014-05-12 12:55
Forum: Getting Started
Topic: Conditional colouring
Replies: 1
Views: 1599

Re: Conditional colouring

I managed to solve this one by myself eventually... For any other interested parties: In this case my colum is called 'b'. Edit /templates/myapp_templateTV.html Find <td id="myapp-b-<%%VALUE(id)%%>" class="myapp-b text-center"><%%VALUE(b)%%></td> Replace with: <td id="myapp-b-<%%VALUE(id)%%>" class=...
by eagle
2014-05-09 13:46
Forum: Getting Started
Topic: Conditional colouring
Replies: 1
Views: 1599

Conditional colouring

I have a colum that shows an integer from 1-5. In table view I would like to show the cell background based on the value of the cell. E.g. If the value is 1, then 1 is presented with a blue cell background. If the value is 2, then 2 is presented with a red cell background. I guess I can do this by a...
by eagle
2014-05-07 17:22
Forum: Getting Started
Topic: Hide Jump to menu
Replies: 0
Views: 1605

Hide Jump to menu

1) I have one table that I have opened for anonymous reading. (The other tables are shown to logged in users only). 2) I have chosen to "Hide the login/membership system". 3) Now I want anonymous users to see the one table from step #1 above. So I direct them to : http://www.mysite.com/myapp/publict...
by eagle
2014-05-07 05:54
Forum: Getting Started
Topic: Changing buttons
Replies: 2
Views: 2058

Re: Changing buttons

Thanks a lot, peebee!

All three answers understood, tested and works exactly as I wanted :D

Thanks again!
by eagle
2014-05-06 13:40
Forum: Getting Started
Topic: Changing buttons
Replies: 2
Views: 2058

Changing buttons

The new Bootstrap theme:

1) Where do I change the icon used for downloading uploaded files? (Now it is globe - I would like to change it to a PDF icon).

2) Can I easily remove the Save CSV and filter buttons?

3) Can we translate the text of the buttons in these themes?

Thanks for all help!
by eagle
2013-01-09 16:13
Forum: Tips And Tricks
Topic: Help and Tutorials in Printable PDF Format
Replies: 12
Views: 9611

Re: Help and Tutorials in Printable PDF Format

Thanks a lot, John!

That was a very nice idea. I have already downloaded your files and put them on my tablet.

Thanks!

Egil.
by eagle
2013-01-09 15:52
Forum: Tips And Tricks
Topic: Help and Tutorials in Printable PDF Format
Replies: 12
Views: 9611

Re: Help and Tutorials in Printable PDF Format

Thanks John, that was an excellent idea.

I already added the files to Calibre and my tablet!

Thanks!

Eagle.