Search found 38 matches
- 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...
- 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...
- 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...
- 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.
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.
- 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...
- 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 ...
- 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!
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!
- 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...
- 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...
- 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...