Search found 166 matches
- 10 Oct 2018, 11:00
- Forum: Discussion
- Topic: ID label formatting
- Replies: 3
- Views: 733
Re: ID label formatting
The ID is set to auto increment in MySQL and the next value is kept in it, its for example 1 and it keep up from that. I have changed it to other numbers and it works. I'm not sure for the dashes format, but any plain number works.
- 08 Oct 2018, 11:03
- Forum: Discussion
- Topic: Transation of entity itself
- Replies: 1
- Views: 520
Transation of entity itself
Hi, is it possible for entities, field names and choices to be translated and change according to user chosen language? For example to have entity in bulgarian with names and fields: Поръчка Услуга Версия And then when an english user selects EN language in their profile to become: Order Service Ver...
- 05 Oct 2018, 14:30
- Forum: Discussion
- Topic: MySQL query field question
- Replies: 14
- Views: 8771
Re: MySQL query field question
This is perfect! You are a lifesaver!
- 05 Oct 2018, 11:04
- Forum: Discussion
- Topic: MySQL query field question
- Replies: 14
- Views: 8771
Re: MySQL query field question
The end goal is to calculate prices for services using the specific client prices:
- 05 Oct 2018, 10:58
- Forum: Discussion
- Topic: MySQL query field question
- Replies: 14
- Views: 8771
Re: MySQL query field question
Unfortunately I can't because: 1. value from parent entity can't be used in formula 2. field value from [1228] value possibly will change in the future and mess with the formulas in old finished orders I would use the select function, but I doesn't work either because of reason #2. If there is way f...
- 05 Oct 2018, 10:26
- Forum: Discussion
- Topic: MySQL query field question
- Replies: 14
- Views: 8771
Re: MySQL query field question
Okay, here it is:
Entities relations: Client profile, we need to get value from [1228] in the order Order, we need to put here value of field [1228] from the client the order belong to
Entities relations: Client profile, we need to get value from [1228] in the order Order, we need to put here value of field [1228] from the client the order belong to
- 05 Oct 2018, 09:29
- Forum: Discussion
- Topic: MySQL query field question
- Replies: 14
- Views: 8771
MySQL query field question
Hi, I have a question about usage of MySQL query. Can it be used to do this: I have "Orders" entity nested as sub-entity of "Users" entity. In each "Order" record I want to check which User is parent to the order and get some numbers from numeric fields in its profile. ...
- 28 Sep 2018, 10:30
- Forum: Bug Report version 2.3
- Topic: Search form doesn't appear if there is not input field
- Replies: 4
- Views: 3166
Search form doesn't appear if there is not input field
I don't know if this is a bug or how search operates, but search form doesn't appear in my entities if there is not added custom input field with "use for search" checked. This is strange, because you can search by ID of records. It doesn't make sense to be restricted of this and to have t...
- 21 Sep 2018, 16:17
- Forum: Suggestions
- Topic: Related items sub-entities
- Replies: 3
- Views: 988
Related items sub-entities
Hello, I propose a new field for displaying related items sub-entities. It could work just like current related items, but instead the parent record it show its sub-records: EXAMPLE.jpg For example here we have 2 orders attached with its sub-entities displayed. It could be used for creating invoices...
- 21 Sep 2018, 14:37
- Forum: Discussion
- Topic: Check which entity is linked in formula
- Replies: 5
- Views: 725
Re: Check which entity is linked in formula
Not really, just when using a formula I need to know which record is selected. Fixed value for every choise don't work for me because every client can have different price for the same service. Depending on what service is selected, I cross reference it with another entity with specific clients pri...