Search found 161 matches

by Paullm
04 Mar 2021, 16:48
Forum: Discussion
Topic: Using field as prefix or suffix
Replies: 6
Views: 384

Re: Using field as prefix or suffix

??? I'm not understanding. To state the obvious ... you can't have alpha characters in a numeric field.
by Paullm
04 Mar 2021, 06:16
Forum: Discussion
Topic: Merge development
Replies: 4
Views: 426

Re: Merge development

The main problem is simply that Ruko entities (tables) and fields are structured using numeric identifiers; not as table and field names.
by Paullm
04 Mar 2021, 05:37
Forum: Discussion
Topic: Using field as prefix or suffix
Replies: 6
Views: 384

Re: Using field as prefix or suffix

Can you provide several examples of how the accounts should be formatted? Do you mean like this? (for example) ... USD1234567890 EUR1234567890 GBP1234567890 ... OR 0011234567890 0021234567890 0031234567890 Both "text pattern" and "static text by pattern" field types will enable y...
by Paullm
04 Mar 2021, 05:16
Forum: Discussion
Topic: obtaining entity information two levels above
Replies: 12
Views: 1100

Re: obtaining entity information two levels above

Hi Luis, You would simply need to add a field with type = "Value from parent entity" to EACH of your sub-entities: projects, process and deadline. As you set up each field, just select the corresponding "connecting" field from the parent entity IMMEDIATELY above. p.s. keep in min...
by Paullm
02 Mar 2021, 07:31
Forum: Discussion
Topic: Lost all my system
Replies: 2
Views: 228

Re: Lost all my system

Very sorry to hear this! Do you have a copy of the 2.7.2 zipped software file to re-install and revert back to?
Or, are you using a hosting service with daily backups (just to see if they have a copy of your 2.7 Ruko software folder, before the update?)
by Paullm
24 Feb 2021, 07:14
Forum: Discussion
Topic: Editing a record with a unique field
Replies: 5
Views: 365

Re: Editing a record with a unique field

Glad to hear it's working, now! Just worth a mention ... if you do change field attributes for populated tables, Ruko does not re-scan table data to do validation checks or make adjustments, per the changed settings.
by Paullm
24 Feb 2021, 05:23
Forum: Discussion
Topic: Editing a record with a unique field
Replies: 5
Views: 365

Re: Editing a record with a unique field

Albro, I just tried your data in one of my tables (entities) ... 11.1 and 1.1.1 in a unique NON-NUMERIC field in two records (rows). Ruko validated and accepted both values, as they are indeed unique. Something else is going on. Did you set the CodPRES field as unique before or after importing the d...
by Paullm
23 Feb 2021, 23:16
Forum: Discussion
Topic: Editing a record with a unique field
Replies: 5
Views: 365

Re: Editing a record with a unique field

When importing data into Ruko from an Excel worksheet, you must pre-process the data ... manually if necessary ... to ensure that everything is in the correct format and that any fields you have designated as unique, are unique. Are you trying to change the value of that unique field to a value that...
by Paullm
18 Feb 2021, 20:06
Forum: Suggestions
Topic: Logical OR in Filters
Replies: 2
Views: 438

Re: Logical OR in Filters

I'm not understanding the purpose of this thread, as you already posted this topic.
by Paullm
18 Feb 2021, 18:46
Forum: Discussion
Topic: MySql formula - conditional formating results
Replies: 3
Views: 331

Re: MySql formula - conditional formating results

Happy it worked! I'm keeping a OneNote notebook of all the code snippets from these posts, for future reference/use.