'composite' field

  1. Z

    Combining lookup fields into one string?

    Hi, I am new to Runabase. I have the following question. I have a simple table, 'routes' with a combined field 'Route' and 5 lookup fields ('From', 'Via#1', Via#2', 'Via#3' and 'To'). Those 5 get their values from a second table 'places', field 'place'. Now I want to get a unique name of the...
  2. RunaBase

    What's new in RunaBase 6.0.36

    - Fixed error of representing empty date as "dd.mm.1752" - Fixed copying from the Object field - Fixed copying from a Composite field located on a hidden tab - Fixed visual bug of filters on the tab - Fixed output of constants in a Word document in the form of links when outputting child lists...
  3. RSZ-EC

    Conditional formatting in Mask property of [String] field

    Hi everybody! Working in version 5, I need to return a numeric value with sign always expressed. By now, I use a long-step method, using [1(Value)], and if it not a minus, adding a plus sign. I wonder if there's a way to avoid inflating my database with more [Composite] and [String] fields for...
  4. RSZ-EC

    [Question] Is there a way to get first (or last) letters of a [String] field?

    Hi everybody! I need to create a [Composite] (or any other) field with a code using the first three letters from a [String] field. So, if the [String] fields contains "General", I need to automatically get "GEN" in another field. Is there a way to do that (mainly in version 5)? Thanks in advance!
  5. MatthijsG

    Some small things

    Some questions. I think the're covered in the Russian documentation, but my Russian isn't quite good ;-) - Is it possible to create a one-to-many-link and how? Like, one object with adres, which is selectable in the object 'person' - Is it possible to join fields? In object adres i need...
  6. RunaBase

    What's new in RunaBase 6.0.16

    RunaBase 6.0.16 from 16 July 2019 - Linux version; - Added translation into Uzbek language: Cyrillic and Latin (thanks to LilRock) - Fixed translation into Romanian language (thanks to sapsergiu) - Design of the program is transferred to work with windows; - Added document printing settings: by...
  7. RunaBase

    [5] What's new in RunaBase 5.1.26, Manager 5.1.10 from 1 Jul 2019

    RunaBase v5.1.26 - Added the Capital function to bring the first character in the string to uppercase - Fixed formation of Outlook letters - New function of the Composite field: Split - splitting the line and taking the specified part - New function of the Composite field: Week / week - getting...
  8. RunaBase

    How to split a string value into substrings

    For example, there is a field "Full name", which must be presented in different versions for documents, such as "John Michael Smith" in the document you want to get options "J.M. Smith", "Michael Smith" and others. To do this, use the Split function for the Composite field. Function syntax...
  9. RunaBase

    What's new in RunaBase 6.0.15

    RunaBase 6.0.15 from 05 June 2019 - New function Split of the Composite field - splitting the string and taking the specified part - Fixed work of the Capital function - Fixed output to a Word document using text fields - Added context menu for the Value property in the Condition field - Fixed...
  10. RSZ-EC

    Getting substrings of a 'string' field

    Greetings! Please let me know if this is possible. I'm trying to get two substrings of a 'string' field, separated by a slash character ('/'). For example, in "+3.00/-2.00x0", I want to get "+3.00" in a 'Composite' field and "-2.00x0" in another. How can I do this? Thank you very much as always!
  11. RunaBase

    What's new in RunaBase 6.0.14

    RunaBase 6.0.14 from 17 May 2019 - Added a declination of cases for the Kazakh language - Operations separated into general and national - Fixed the Del function in the object and the Composite field - Fixed console display for the Executable field - Fixed execution of several Operations...
  12. RunaBase

    [5] What's new in RunaBase 5.1.24

    RunaBase 5.1.24 from 12 Apr 2019 - Added SMS gateway textlocal.com; - Added check for the integrity of the archive; - Fixed opening of the form if there is a field behind the Caption, with the New Line property: no; - Prohibition of going beyond the bottom edge of the screen; - Fixed work of a...