Search found 25 matches

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

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: 801

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: 6652

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: 1496

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: 1973

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: 2108

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: 1588

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: 1418

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: 1588

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: 2252

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: 2252

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: 2252

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: 1218

Re: Reminder Email

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

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: 1831

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: 1729

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: 1290

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: 1729

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: 1451

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: 1451

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: 1402

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: 1838

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: 1838

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: 8942

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: 8942

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.