Search found 38 matches

by weitau
17 Sep 2020, 06:50
Forum: Discussion
Topic: MySQL Query returns FK to Global List
Replies: 7
Views: 936

Re: MySQL Query returns FK to Global List

There should be a field type that will store the actual value from a list, not just the index value Excel lists work this way. Once the user selects the choice, then the choice then fills the cell. This works as a data entry validator but it uses more storage space but in today's age, storage is che...
by weitau
16 Sep 2020, 08:52
Forum: Discussion
Topic: MySQL Query returns FK to Global List
Replies: 7
Views: 936

Re: MySQL Query returns FK to Global List

Yes, I was considering this and some form of GetValue(). I can do SQL, but I'm unfamiliar with the way Rukovoditel references fields in the current table vs joined tables. For example when I use [243], is that the field in the current table or the table that has field_243? What is the syntax and usa...
by weitau
16 Sep 2020, 07:04
Forum: Bug Report version 2.7
Topic: Unhandled error on insert
Replies: 2
Views: 1972

Unhandled error on insert

I have a Standard Report that is not a menu item. This report is in a Report Group by itself and the report group item is In Menu. I have Add Item button turned on for this report. I added new record and click Save. The record is saved, but the screen falls back to the Dashboard. I believe it should...
by weitau
16 Sep 2020, 05:15
Forum: Suggestions
Topic: Allow MySQL Query to return > 1 column
Replies: 1
Views: 516

Allow MySQL Query to return > 1 column

Currently MySQL query can only return 1 field from 1 record.

Allow this function to return more than 1 field in the template similar to the attached.
The result will be concatenated and stored in the desired field.
2020-09-15_21-11-04.png
by weitau
16 Sep 2020, 05:05
Forum: Discussion
Topic: MySQL Query returns FK to Global List
Replies: 7
Views: 936

MySQL Query returns FK to Global List

The MySQL query works great to reference fields in a related table. However if that field is a List type, what is returned is the foreign key, not what the FK represents. For example, I have two tables, People id = 3 [100] Name (heading) = Bob [105] Country = 14 --> but displays France because its a...
by weitau
14 Sep 2020, 09:55
Forum: Discussion
Topic: Display same field in multiple tabs
Replies: 1
Views: 286

Re: Display same field in multiple tabs

My JS friend gave me this code and it works - but you first must make any edit on the record for the JS to run You would add this to the Entity Form Configuration - Add Javascript - Javascript in Form. Hope this helps someone Field 240 - Company Name Field 258 - Person Name Field 347 - Name We want ...
by weitau
14 Sep 2020, 06:18
Forum: Discussion
Topic: Display same field in multiple tabs
Replies: 1
Views: 286

Display same field in multiple tabs

Is it possible to display the same field across multiple tabs in a Form?

For example, I have three tabs in my form, Company, Address, and Phone.
I want to display the company name on the Address and phone tabs.

Thank you!
by weitau
14 Sep 2020, 04:57
Forum: Discussion
Topic: Best way to handle US & European addresses
Replies: 0
Views: 317

Best way to handle US & European addresses

I'm trying to setup address fields to handle clients from the United States and Europe. I'm finding that while the fields may be similar, the layouts are different. For example, US layout MARY ROE [name] 799 E DRAGRAM St [street address] TUCSON AZ 85705 [city/town + State + postal code] US format.pn...
by weitau
13 Sep 2020, 16:51
Forum: Discussion
Topic: Entity drop-down list (ajax) Condition?
Replies: 4
Views: 476

Re: Entity drop-down list (ajax) Condition?

Using e.field_241 works! Thank you! I am able to display the lookup record and selected fields using the heading template (with the ability to add formatting). The list is not sorted by the first field in the template, but that's a minor issue. 2020-09-13_8-47-50.png Anyway you can click on field na...
by weitau
13 Sep 2020, 09:11
Forum: Discussion
Topic: Entity drop-down list (ajax) Condition?
Replies: 4
Views: 476

Re: Entity drop-down list (ajax) Condition?

Unfortunately, that did still returns "The results cannot be loaded" Ok, so I then go to one of the original tables -Tasks. I added a Entity Drop down list field "ticket list" to lookup the Tickets table. For condition, I check if field_169 has the value of 46 (Status=New) This d...