Search found 161 matches
- 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.
- 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.
- 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...
- 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...
- 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?)
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?)
- 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.
- 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...
- 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...
- 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.
- 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.