Search found 166 matches

by p.dimitrov
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.
by p.dimitrov
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...
by p.dimitrov
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!
by p.dimitrov
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:
final.jpg
by p.dimitrov
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...
by p.dimitrov
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:
entities.jpg
Client profile, we need to get value from [1228] in the order
client_profile.jpg
Order, we need to put here value of field [1228] from the client the order belong to
order.jpg
by p.dimitrov
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. ...
by p.dimitrov
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...
by p.dimitrov
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...
by p.dimitrov
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...