Translation components API.

See the Weblate's Web API documentation for detailed description of the API.

GET /api/translations/libo_help-24-2/textshared02/fi/units/?format=api&page=13
HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 2273,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/units/?format=api&page=14",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/units/?format=api&page=12",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "You have several possibilities:"
            ],
            "previous_source": "",
            "target": [
                "On useita mahdollisuuksia:"
            ],
            "id_hash": -6659339590724313499,
            "content_hash": -6659339590724313499,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3153224\nhelp.text",
            "note": "XgAQb",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 601,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478809/?format=api",
            "priority": 100,
            "id": 109037517,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=239545ecc82e9e65",
            "url": "https://translations.documentfoundation.org/api/units/109037517/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.794757Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "First case: There is only one table in the form."
            ],
            "previous_source": "",
            "target": [
                "Ensimmäinen tapaus: lomakkeella on vain yksi taulu"
            ],
            "id_hash": -481164807545358537,
            "content_hash": -481164807545358537,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3159110\nhelp.text",
            "note": "22NCE",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 602,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 10,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478817/?format=api",
            "priority": 100,
            "id": 109037522,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=79528f2827d6f737",
            "url": "https://translations.documentfoundation.org/api/units/109037522/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.796698Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Under <emph>Data field</emph>, specify the field of the data source table whose contents you want to be displayed."
            ],
            "previous_source": "",
            "target": [
                "<emph>Tietokentässä</emph> määritetään se lähdetietokannan taulun kenttä, jonka sisältö halutaan esittää."
            ],
            "id_hash": -6194709294615424412,
            "content_hash": -6194709294615424412,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3156356\nhelp.text",
            "note": "TMN36",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 603,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 18,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478825/?format=api",
            "priority": 100,
            "id": 109037526,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=2a07f8b7afa31264",
            "url": "https://translations.documentfoundation.org/api/units/109037526/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.799040Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Second case: The control belongs to a subform that is created by an SQL query."
            ],
            "previous_source": "",
            "target": [
                "Toinen tapaus: ohjausobjekti kuuluu SQL-kyselyn luomaan alilomakkeeseen."
            ],
            "id_hash": -8260506453139821159,
            "content_hash": -8260506453139821159,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3146898\nhelp.text",
            "note": "ZTCVz",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 604,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478830/?format=api",
            "priority": 100,
            "id": 109037537,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=0d5cc9259bc76d99",
            "url": "https://translations.documentfoundation.org/api/units/109037537/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.864083Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Under <emph>Data field</emph>, specify the field of the SQL statement whose contents you want to be displayed."
            ],
            "previous_source": "",
            "target": [
                "<emph>Tietokentässä</emph> määritetään se SQL-lauseen kenttä, jonka sisältö halutaan esittää."
            ],
            "id_hash": -1458712529968571179,
            "content_hash": -1458712529968571179,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154273\nhelp.text",
            "note": "UkdBb",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 605,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 17,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478834/?format=api",
            "priority": 100,
            "id": 109037558,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=6bc19caebdcfdcd5",
            "url": "https://translations.documentfoundation.org/api/units/109037558/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.875623Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Third case: <link href=\"text/shared/02/01170900.xhp\">Combo Boxes</link>"
            ],
            "previous_source": "",
            "target": [
                "Kolmas tapaus: <link href=\"text/shared/02/01170900.xhp\">Yhdistelmäruudut</link>"
            ],
            "id_hash": 8499289370055573744,
            "content_hash": 8499289370055573744,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3153949\nhelp.text",
            "note": "6FD9z",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 606,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478842/?format=api",
            "priority": 100,
            "id": 109037562,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f5f38aa6a16a80f0",
            "url": "https://translations.documentfoundation.org/api/units/109037562/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.878139Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "For combo boxes, the field of the data source table in which the values entered or selected by the user should be stored is specified under <emph>Data field</emph>. The values displayed in the list of the combo box are based on an SQL statement, which is entered under <emph>List content</emph>."
            ],
            "previous_source": "",
            "target": [
                "Yhdistelmäruuduille se lähdetiekannan kenttä, johon käyttäjän syöttämä tai valitsema arvo pitää tallentaa, määritetään <emph>Tietokenttä</emph>-ominaisuudella. Yhdistelmäruudun luettelossa esitetyt arvot perustuvat SQL-lauseeseen, joka on syötetty <emph>Luettelon sisällöksi</emph>."
            ],
            "id_hash": 5089503659383241866,
            "content_hash": 5089503659383241866,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3147494\nhelp.text",
            "note": "AXEkS",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 607,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 50,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478849/?format=api",
            "priority": 100,
            "id": 109037566,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=c6a18c9ce496bc8a",
            "url": "https://translations.documentfoundation.org/api/units/109037566/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.880782Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Fourth case: <link href=\"text/shared/02/01170900.xhp\">List Boxes</link>"
            ],
            "previous_source": "",
            "target": [
                "Neljäs tapaus: <link href=\"text/shared/02/01170900.xhp\">Luetteloruudut</link>"
            ],
            "id_hash": 809733597273324822,
            "content_hash": 809733597273324822,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3145167\nhelp.text",
            "note": "ahU6a",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 608,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478859/?format=api",
            "priority": 100,
            "id": 109037572,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=8b3cc06aa42cfd16",
            "url": "https://translations.documentfoundation.org/api/units/109037572/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.883659Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The data source table does not contain the data to be displayed, but rather a table linked to the data source table through a common data field."
            ],
            "previous_source": "",
            "target": [
                "Lähdetietotaulu ei sisällä esitettävää tietoa, vaan taulun, joka on linkitetty tietolähteeseen yhteisen tietokentän kautta."
            ],
            "id_hash": -4282696108386294293,
            "content_hash": -4282696108386294293,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3153764\nhelp.text",
            "note": "KwJVt",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 609,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 27,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478865/?format=api",
            "priority": 100,
            "id": 109037578,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=4490ce9482afe5eb",
            "url": "https://translations.documentfoundation.org/api/units/109037578/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.886300Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If you want a list box to display data from a table that is linked to the current data source table, under <emph>Data field</emph> specify the field of the data source table to which the content of the list box refers. Or you can specify the database field that controls the display of the data in the form. This data field provides the link to the other table if both tables can be linked through a common data field. It is usually a data field in which unique identification numbers are stored. The data field whose contents are displayed in the form is specified by an SQL statement under <emph>List content</emph>."
            ],
            "previous_source": "",
            "target": [
                "Jos halutaan, että luetteloruutu esittää aineistoa taulusta, joka on linkitetty nykyiseen tietolähdetauluun, <emph>Tietokentässä</emph> määritetään se lähdetietokannan taulun kenttä, jonka sisältöön luetteloruutu viittaa. Vaihtoehtoisesti voidaan määritellä tietokantakenttä, joka ohjaa tietojen esittämistä lomakkeella. Tämä tietokenttä tarjoaa linkin toiseen tauluun, jos molemmat taulut voidaan linkittää yhteisen tietokentän kautta. Tavallisesti se on tietokenttä, johon on tallennettu yksilölliset tunnistenumerot. Se tietokenttä, jonka sisältö esitetään lomakkeella, on määritelty SQL-lauseella <emph>Luettelon sisältö</emph>-ominaisuudessa."
            ],
            "id_hash": 4562771754625008913,
            "content_hash": 4562771754625008913,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3149021\nhelp.text",
            "note": "C8pJR",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 610,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 111,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478869/?format=api",
            "priority": 100,
            "id": 109037584,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=bf5238bc799c0511",
            "url": "https://translations.documentfoundation.org/api/units/109037584/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.888611Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "List boxes work with references. They can either be implemented with linked tables by SQL statements (fourth case) or through value lists:"
            ],
            "previous_source": "",
            "target": [
                "Luetteloruudut toimivat viitteillä. Ne voidaan toteuttaa joko SQL-lausein linkitetyillä tauluilla (neljäs tapaus) tai arvoluetteloilla:"
            ],
            "id_hash": 5844444602735809300,
            "content_hash": 5844444602735809300,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3153924\nhelp.text",
            "note": "MFCve",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 611,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 22,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478883/?format=api",
            "priority": 100,
            "id": 109037591,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=d11ba366a7845314",
            "url": "https://translations.documentfoundation.org/api/units/109037591/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.891666Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "<emph>References through linked tables (SQL statements)</emph>"
            ],
            "previous_source": "",
            "target": [
                "<emph>Viitteet linkitettyjen taulujen kautta (SQL-lauseet)</emph>"
            ],
            "id_hash": -2756911875870332625,
            "content_hash": -2756911875870332625,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3145641\nhelp.text",
            "note": "mCErh",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 612,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 6,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478891/?format=api",
            "priority": 100,
            "id": 109037597,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=59bd7b4171b1692f",
            "url": "https://translations.documentfoundation.org/api/units/109037597/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.893890Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If you want a list box to display data from a database table that is linked by a common data field to the table on which the form is based, the link field of the form table is specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Jos luetteloruudun halutaan esittävän sen tietokannan taulun tietoja, joka on linkitetty yhteisen tietokentän kautta tauluun, johon lomake perustuu, lomaketaulun linkkikenttä määritellään <emph>Tietokenttä</emph>-ominaisuudessa."
            ],
            "id_hash": -8589591949903675699,
            "content_hash": -8589591949903675699,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3147341\nhelp.text",
            "note": "jBTmx",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 613,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 42,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478896/?format=api",
            "priority": 100,
            "id": 109037604,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=08cba3a1946fbecd",
            "url": "https://translations.documentfoundation.org/api/units/109037604/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.896092Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The link is created with an SQL Select, which, if you selected \"SQL\" or \"Native SQL\", is specified under <emph>Type of list contents</emph> in the field <emph>List content</emph>. As an example, a table \"Orders\" is linked to the current form control, and in the database a table \"Customers\" is linked to the \"Orders\" table. You can use an SQL statement as follows:"
            ],
            "previous_source": "",
            "target": [
                "Linkki luodaan SQL:n Select-lauseella. Jos <emph>Luettelon sisältötyyppi</emph> -ominaisuudeksi on valittu \"SQL\" tai \"SQL [suora]\", tuo SQL-lause määritellään <emph>Luettelon sisältö</emph> -kentässä. Esimerkiksi taulu \"Orders\" on linkitetty käsiteltävään lomakkeen ohjausobjektiin ja tietokantataulu \"Customers\" on linkitetty \"Orders\"-tauluun. SQL-lausetta voi käyttää seuraavasti:"
            ],
            "id_hash": 1272607705272927535,
            "content_hash": 1272607705272927535,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3155174\nhelp.text",
            "note": "zuhT8",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 614,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 62,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478913/?format=api",
            "priority": 100,
            "id": 109037611,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=91a935f72337c52f",
            "url": "https://translations.documentfoundation.org/api/units/109037611/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.898635Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "SELECT CustomerName, CustomerNo FROM Customers,"
            ],
            "previous_source": "",
            "target": [
                "SELECT CustomerName, CustomerNo FROM Customers,"
            ],
            "id_hash": -983449770690426920,
            "content_hash": -983449770690426920,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3148537\nhelp.text",
            "note": "pjEag",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 615,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": true,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478929/?format=api",
            "priority": 100,
            "id": 109037618,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=725a15a4e38ec7d8",
            "url": "https://translations.documentfoundation.org/api/units/109037618/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.902493Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "where \"CustomerName\" is the data field from the linked table \"Customers\", and \"CustomerNo\" is the field of the table \"Customers\" that is linked to a field of the form table \"Orders\" specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "missä \"CustomerName\" on tietokenttä linkitetystä taulusta \"Customers\" ja \"CustomerNo\" on kenttä taulusta \"Customers\", joka on linkitetty lomaketaulun \"Orders\" kenttään, joka on määritetty <emph>Tietokenttä</emph>-ominaisuudessa."
            ],
            "id_hash": -2969856831118907018,
            "content_hash": -2969856831118907018,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154967\nhelp.text",
            "note": "LraC6",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 616,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 35,
            "source_unit": "https://translations.documentfoundation.org/api/units/108478956/?format=api",
            "priority": 100,
            "id": 109037625,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=56c8f2f27363e976",
            "url": "https://translations.documentfoundation.org/api/units/109037625/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.905234Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "<emph>References Using Value Lists</emph>"
            ],
            "previous_source": "",
            "target": [
                "<emph>Arvoluetteloita käyttävät viitearvot</emph>"
            ],
            "id_hash": -6695374420482136210,
            "content_hash": -6695374420482136210,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3163808\nhelp.text",
            "note": "LGoHm",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 617,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479007/?format=api",
            "priority": 100,
            "id": 109037630,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=231540702cece76e",
            "url": "https://translations.documentfoundation.org/api/units/109037630/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.907694Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "For list boxes, you can use value lists. Value lists are lists that define reference values. In this way, the control in the form does not directly display the content of a database field, but rather values assigned in the value list."
            ],
            "previous_source": "",
            "target": [
                "Luetteloruuduille voidaan käyttää arvoluetteloita. Arvoluettelot ovat luetteloita, jotka määrittävät viitearvoja. Tätä tapaa käytettäessä lomakkeen ohjausobjekti ei esitä tietokannan kenttien sisältöä, vaan arvoja, jotka on kytketty niihin arvoluettelossa."
            ],
            "id_hash": -217965766752047294,
            "content_hash": -217965766752047294,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3145295\nhelp.text",
            "note": "soM4u",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 618,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 42,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479068/?format=api",
            "priority": 100,
            "id": 109037636,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=7cf9a14a3b8c6f42",
            "url": "https://translations.documentfoundation.org/api/units/109037636/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.909899Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If you work with reference values of a value list, the contents of the data field that you specified under <emph>Data Field</emph> in the form are not visible, but rather the assigned values. If you chose \"Valuelist\" on the <emph>Data</emph> tab under <emph>Type of list contents</emph> and assigned a reference value to the visible list entries in the form under <emph>List entries</emph> (entered in the <link href=\"text/shared/02/01170101.xhp\"><emph>General</emph></link> tab), then the reference values are compared with the data content of the given data field. If a reference value corresponds to the content of a data field, the associated list entries are displayed in the form."
            ],
            "previous_source": "",
            "target": [
                "Kun käytetään arvoluettelon viitearvoja, lomakkeella ei näy <emph>Tietokenttä</emph>-ominaisuudessa määritellyn kentän sisältö, vaan kytketyt arvot. Kun <emph>Tiedot</emph>-välilehdellä valitaan \"Arvoluettelo\" <emph>Luettelon sisältötyyppi</emph> -ominaisuudeksi ja kytketään viitearvo lomakkeella näkyvään luetteloriviin <emph>Luettelomerkinnät</emph>-ominaisuudessa (syötetään <link href=\"text/shared/02/01170101.xhp\"><emph>Yleistä</emph></link>-välilehdellä), silloin viitearvoja verrataan annettuun tietokenttään. Jos viitearvo vastaa tietokentän sisältöä, liitetyt luettelomerkinnät esitetään lomakkeella."
            ],
            "id_hash": -6677701340150126352,
            "content_hash": -6677701340150126352,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3151186\nhelp.text",
            "note": "VGDPF",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 619,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 104,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479126/?format=api",
            "priority": 100,
            "id": 109037642,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=23540a02d833a8f0",
            "url": "https://translations.documentfoundation.org/api/units/109037642/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.912623Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Bound field"
            ],
            "previous_source": "",
            "target": [
                "Sidottu kenttä"
            ],
            "id_hash": 1394669791084496666,
            "content_hash": 1394669791084496666,
            "location": "01170102.xhp",
            "context": "01170102.xhp\nhd_id3154664\nhelp.text",
            "note": "sBFuk",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 620,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479739/?format=api",
            "priority": 100,
            "id": 109037648,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=935adcc9248f471a",
            "url": "https://translations.documentfoundation.org/api/units/109037648/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.915684Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "<ahelp hid=\".\" visibility=\"hidden\">Use an index to specify the table field or table SQL query to link to the field that is provided under <emph>Data field</emph>. Valid values for this property are 1, 2, 3, and so on.</ahelp>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 5280825289098856240,
            "content_hash": 5280825289098856240,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3148475\nhelp.text",
            "note": "mYEfs",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 621,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 37,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479758/?format=api",
            "priority": 100,
            "id": 109037655,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=c949429f15a30730",
            "url": "https://translations.documentfoundation.org/api/units/109037655/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.917741Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If you delete the contents of the <emph>Bound field</emph> cell in the property browser, the first field of the result set is used to display and to exchange data."
            ],
            "previous_source": "",
            "target": [
                "Jos <emph>Sidottu kenttä</emph>-ominaisuuden arvo poistetaan, tulosjoukon ensimmäistä kenttää käytetään esittämiseen ja tietojen vaihtoon."
            ],
            "id_hash": -8430351819525409924,
            "content_hash": -8430351819525409924,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_idN10AD2\nhelp.text",
            "note": "iMiFJ",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 622,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 29,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479788/?format=api",
            "priority": 100,
            "id": 109037661,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=0b015fafa19eb37c",
            "url": "https://translations.documentfoundation.org/api/units/109037661/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.919729Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "This property for list boxes defines which data field of a linked table is displayed in the form."
            ],
            "previous_source": "",
            "target": [
                "Tämä luetteloruudun ominaisuus määrää, mikä linkitetyn taulun tietokenttä esitetään lomakkeella."
            ],
            "id_hash": 102749402758240680,
            "content_hash": 102749402758240680,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154588\nhelp.text",
            "note": "rwfaY",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 623,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 18,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479826/?format=api",
            "priority": 100,
            "id": 109037668,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=816d0a099449d9a8",
            "url": "https://translations.documentfoundation.org/api/units/109037668/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.922237Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If a list box in the form is to display contents of a table linked to the form table, then define in the <emph>Type of list contents</emph> field if the display is determined by an SQL command or the (linked) table is accessed. With the <emph>Bound field</emph> property, you use an index to specify to which data field of the query or of the table the list field is linked."
            ],
            "previous_source": "",
            "target": [
                "Jos lomakkeen luetteloruudun on tarkoitus esittää lomaketauluun linkitetyn taulun sisältöä, silloin määritellään <emph>Luettelon sisältötyyppi</emph> -kentässä, määrätäänkö esitys SQL-komennolla vai haetaanko (linkitetty) taulu. <emph>Sidottu kenttä</emph> -ominaisuutena oleva indeksi määrittää sen, mihin kyselyn tai taulun tietokenttään luettelokenttä on linkitetty."
            ],
            "id_hash": -1340460639614234189,
            "content_hash": -1340460639614234189,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3151213\nhelp.text",
            "note": "ynxKU",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 624,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 70,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479936/?format=api",
            "priority": 100,
            "id": 109037676,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=6d65ba267c6691b3",
            "url": "https://translations.documentfoundation.org/api/units/109037676/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.924619Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The property <emph>Bound field</emph> is only for forms that are used to access more than one table. If the form is based on only one table, the field to be displayed in the form is specified directly under <emph>Data field</emph>. However, if you want the list box to display data from a table that is linked to the current table over a common data field, the linked data field is defined by the property <emph>Bound field</emph>."
            ],
            "previous_source": "",
            "target": [
                "<emph>Sidottu kenttä</emph> -ominaisuutta tarvitaan vain lomakkeissa, joista pääsee käsiksi useampaan kuin yhteen tauluun. Jos lomake perustuu vain yhteen tauluun, lomakkeella esitettävä kenttä määräytyy suoraan ominaisuudella <emph>Tietokenttä</emph>. Jos sen sijaan halutaan luetteloruudun esittävän aineistoa taulusta, joka on linkitetty yhteisen tietokentän kautta nykyiseen tauluun, linkitetty tietokenttä määritellään <emph>Sidottu kenttä</emph> -ominaisuudella."
            ],
            "id_hash": -4141404447950045556,
            "content_hash": -4141404447950045556,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3148427\nhelp.text",
            "note": "gYpBd",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 625,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 76,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479950/?format=api",
            "priority": 100,
            "id": 109037684,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=4686c698c0b6fe8c",
            "url": "https://translations.documentfoundation.org/api/units/109037684/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.927565Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If you selected \"SQL\" under <emph>Type of list contents</emph>, the SQL command determines the index to be specified. Example: If you specify an SQL command such as \"SELECT Field1, Field2 FROM tablename\" under <emph>List content</emph>, refer to the following table:"
            ],
            "previous_source": "",
            "target": [
                "Jos valitaan \"SQL\" <emph>Luettelon sisältötyyppi</emph> -ominaisuudeksi, SQL-komento määrää käytettävän indeksin. Esimerkki: jos sellainen SQL-komento kuin \"SELECT Kenttä1, Kenttä2 FROM taulun_nimi\" määritetään <emph>Luettelon sisällöksi</emph>, niin vaihtoehdot näkyvät seuraavassa taulukossa:"
            ],
            "id_hash": 1474562121179004358,
            "content_hash": 1474562121179004358,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3150365\nhelp.text",
            "note": "XAnRG",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 626,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 40,
            "source_unit": "https://translations.documentfoundation.org/api/units/108479960/?format=api",
            "priority": 100,
            "id": 109037688,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=9476b26fc81efdc6",
            "url": "https://translations.documentfoundation.org/api/units/109037688/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.929948Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Bound field"
            ],
            "previous_source": "",
            "target": [
                "Sidottu kenttä"
            ],
            "id_hash": -3989004440384999630,
            "content_hash": -3989004440384999630,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154716\nhelp.text",
            "note": "xQEAN",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 627,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480082/?format=api",
            "priority": 100,
            "id": 109037693,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=48a435989b656f32",
            "url": "https://translations.documentfoundation.org/api/units/109037693/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.933094Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Link"
            ],
            "previous_source": "",
            "target": [
                "Linkki"
            ],
            "id_hash": 8607783635618654627,
            "content_hash": 8607783635618654627,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3150666\nhelp.text",
            "note": "n4FEd",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 628,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480103/?format=api",
            "priority": 100,
            "id": 109037700,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f774fd9c507869a3",
            "url": "https://translations.documentfoundation.org/api/units/109037700/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.939830Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "-1"
            ],
            "previous_source": "",
            "target": [
                "-1"
            ],
            "id_hash": -8685261095376900500,
            "content_hash": -8685261095376900500,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154286\nhelp.text",
            "note": "FCGuF",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 629,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480119/?format=api",
            "priority": 100,
            "id": 109037704,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=0777c10cdc8a2e6c",
            "url": "https://translations.documentfoundation.org/api/units/109037704/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.942194Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The index of the selected entry in the list is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Valitun listamerkinnän hakemisto linkitetään kenttään, joka määritetään <emph>Tietokentässä</emph>."
            ],
            "id_hash": 5814389305535713275,
            "content_hash": 5814389305535713275,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3845757\nhelp.text",
            "note": "KxZ3G",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 630,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 18,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480125/?format=api",
            "priority": 100,
            "id": 109037708,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=d0b0dc4476494ffb",
            "url": "https://translations.documentfoundation.org/api/units/109037708/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.944355Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "{empty} or 0"
            ],
            "previous_source": "",
            "target": [
                "{tyhjä} tai 0"
            ],
            "id_hash": 8448153377304456594,
            "content_hash": 8448153377304456594,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3854206\nhelp.text",
            "note": "JZsUc",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 631,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480141/?format=api",
            "priority": 100,
            "id": 109037712,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f53ddebc863fad92",
            "url": "https://translations.documentfoundation.org/api/units/109037712/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.946723Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The database field \"Field1\" is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Tietokannan kenttä \"Kenttä1\" on linkitetty <emph>Tietokenttä</emph>-ominaisuuden määrittämään kenttään."
            ],
            "id_hash": 5778391308415738189,
            "content_hash": 5778391308415738189,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3145257\nhelp.text",
            "note": "DkSZe",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 632,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 13,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480162/?format=api",
            "priority": 100,
            "id": 109037715,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=d030f8479f53214d",
            "url": "https://translations.documentfoundation.org/api/units/109037715/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.948809Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "1"
            ],
            "previous_source": "",
            "target": [
                "1"
            ],
            "id_hash": 248871419711422145,
            "content_hash": 248871419711422145,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3150887\nhelp.text",
            "note": "BLMSL",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 633,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480198/?format=api",
            "priority": 100,
            "id": 109037720,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=83742b3cd6a57ec1",
            "url": "https://translations.documentfoundation.org/api/units/109037720/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.951117Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The database field \"Field2\" is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Tietokannan kenttä \"Kenttä2\" on linkitetty <emph>Tietokenttä</emph>-kenttään."
            ],
            "id_hash": -3087024027415408502,
            "content_hash": -3087024027415408502,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3156064\nhelp.text",
            "note": "fkYCG",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 634,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 13,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480216/?format=api",
            "priority": 100,
            "id": 109037726,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=5528b000b8cf108a",
            "url": "https://translations.documentfoundation.org/api/units/109037726/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.953051Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If you selected \"Table\" under <emph>Type of list contents</emph>, the table structure defines the index to be specified. Example: If a database table is selected under <emph>List content</emph>, refer to the following table:"
            ],
            "previous_source": "",
            "target": [
                "Jos valitaan \"Taulu\" <emph>Luettelon sisältötyyppi</emph> -ominaisuudeksi, taulun rakenne määrittää käytettävän indeksin. Esimerkki: jos tietokannan taulu on valittu <emph>Luettelon sisältöön</emph>, niin vaihtoehdot näkyvät seuraavassa taulukossa:"
            ],
            "id_hash": 5867121339991804324,
            "content_hash": 5867121339991804324,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154134\nhelp.text",
            "note": "TGHbv",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 635,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 33,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480253/?format=api",
            "priority": 100,
            "id": 109037732,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=d16c33c5fc5349a4",
            "url": "https://translations.documentfoundation.org/api/units/109037732/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.955323Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Bound field"
            ],
            "previous_source": "",
            "target": [
                "Sidottu kenttä"
            ],
            "id_hash": -7326830403341917264,
            "content_hash": -7326830403341917264,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3155379\nhelp.text",
            "note": "CVNoA",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 636,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480278/?format=api",
            "priority": 100,
            "id": 109037739,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=1a51de913f45e3b0",
            "url": "https://translations.documentfoundation.org/api/units/109037739/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.957799Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Link"
            ],
            "previous_source": "",
            "target": [
                "Linkki"
            ],
            "id_hash": -7855290430113272840,
            "content_hash": -7855290430113272840,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3155529\nhelp.text",
            "note": "gK3AN",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 637,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480283/?format=api",
            "priority": 100,
            "id": 109037744,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=12fc66f91192abf8",
            "url": "https://translations.documentfoundation.org/api/units/109037744/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.960420Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "-1"
            ],
            "previous_source": "",
            "target": [
                "-1"
            ],
            "id_hash": 4384090768571891592,
            "content_hash": 4384090768571891592,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154287\nhelp.text",
            "note": "Lv77m",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 638,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480294/?format=api",
            "priority": 100,
            "id": 109037746,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=bcd76b537bcbff88",
            "url": "https://translations.documentfoundation.org/api/units/109037746/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.962321Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The index of the selected entry in the list is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Valitun listalla olevan merkinnän hakemisto  linkitetään kenttään, joka määritetään <emph>Tietokentässä</emph>."
            ],
            "id_hash": 9161973066774810069,
            "content_hash": 9161973066774810069,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3145757\nhelp.text",
            "note": "CvS3g",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 639,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 18,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480324/?format=api",
            "priority": 100,
            "id": 109037749,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=ff25ddf646cf0dd5",
            "url": "https://translations.documentfoundation.org/api/units/109037749/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.963862Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "{empty} or 0"
            ],
            "previous_source": "",
            "target": [
                "{tyhjä} tai 0"
            ],
            "id_hash": -447409127919565245,
            "content_hash": -447409127919565245,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3155373\nhelp.text",
            "note": "FuJKV",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 640,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480342/?format=api",
            "priority": 100,
            "id": 109037753,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=79ca7bc4c5164643",
            "url": "https://translations.documentfoundation.org/api/units/109037753/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.965659Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The 1st column of the table is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Taulun 1. sarake linkitetään kenttään, joka määritetään <emph>Tietokentässä</emph>."
            ],
            "id_hash": -1795813250321033103,
            "content_hash": -1795813250321033103,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154260\nhelp.text",
            "note": "CFAW4",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 641,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480361/?format=api",
            "priority": 100,
            "id": 109037755,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=6713fd5d0bacd871",
            "url": "https://translations.documentfoundation.org/api/units/109037755/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.967250Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "1"
            ],
            "previous_source": "",
            "target": [
                "1"
            ],
            "id_hash": -4629223141375206030,
            "content_hash": -4629223141375206030,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3156448\nhelp.text",
            "note": "odzAa",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 642,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480390/?format=api",
            "priority": 100,
            "id": 109037760,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=3fc1b21460501d72",
            "url": "https://translations.documentfoundation.org/api/units/109037760/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.969634Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The 2nd column of the table is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Taulun 2. sarake linkitetään kenttään, joka määritetään <emph>Tietokentässä</emph>."
            ],
            "id_hash": 9070529669402142835,
            "content_hash": 9070529669402142835,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154486\nhelp.text",
            "note": "eJNuh",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 643,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480405/?format=api",
            "priority": 100,
            "id": 109037764,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=fde0fead355b2873",
            "url": "https://translations.documentfoundation.org/api/units/109037764/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.971607Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "2"
            ],
            "previous_source": "",
            "target": [
                "2"
            ],
            "id_hash": -7489788156738910419,
            "content_hash": -7489788156738910419,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3149949\nhelp.text",
            "note": "EZDLj",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 644,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480428/?format=api",
            "priority": 100,
            "id": 109037768,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=180eed5aa2a6472d",
            "url": "https://translations.documentfoundation.org/api/units/109037768/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.973593Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "The 3rd column of the table is linked to the field specified under <emph>Data field</emph>."
            ],
            "previous_source": "",
            "target": [
                "Taulun 3. sarake linkitetään kenttään, joka määritetään <emph>Tietokentässä</emph>."
            ],
            "id_hash": -5829053843900003601,
            "content_hash": -5829053843900003601,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3146767\nhelp.text",
            "note": "8vdfG",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 645,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480448/?format=api",
            "priority": 100,
            "id": 109037773,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=2f1b0a69a1b70aef",
            "url": "https://translations.documentfoundation.org/api/units/109037773/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.975831Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "Type of list contents"
            ],
            "previous_source": "",
            "target": [
                "Luettelon sisältötyyppi"
            ],
            "id_hash": -5094269746401048319,
            "content_hash": -5094269746401048319,
            "location": "01170102.xhp",
            "context": "01170102.xhp\nhd_id3149772\nhelp.text",
            "note": "Va4fc",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 646,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480467/?format=api",
            "priority": 100,
            "id": 109037778,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=394d84a7ffbf0901",
            "url": "https://translations.documentfoundation.org/api/units/109037778/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.978044Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "<ahelp hid=\".\" visibility=\"hidden\">Determines the data to fill the lists in list and combo boxes.</ahelp> Determines the data to fill the lists in list and combo boxes."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1825653477436253576,
            "content_hash": -1825653477436253576,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3154419\nhelp.text",
            "note": "Yhnur",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 647,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 26,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480493/?format=api",
            "priority": 100,
            "id": 109037783,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=66a9f9d5c2749a78",
            "url": "https://translations.documentfoundation.org/api/units/109037783/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.980043Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "With the \"Valuelist\" option, all entries entered in the <emph>List entries</emph> field of the <link href=\"text/shared/02/01170101.xhp\"><emph>General</emph></link> tab appear in the control. For database forms, you can use reference values (see the <link href=\"text/shared/02/01170102.xhp\"><emph>References Using Value Lists</emph></link> section)."
            ],
            "previous_source": "",
            "target": [
                "\"Arvoluettelo\"-vaihtoehdolla kaikki <link href=\"text/shared/02/01170101.xhp\"><emph>Yleistä</emph></link>-välilehden <emph>Luettelomerkinnät</emph>-kentän syötteet näkyvät ohjausobjektissa. Tietokantalomakkeille voidaan käyttää viitearvoja (katso <link href=\"text/shared/02/01170102.xhp\"><emph>Arvoluetteloita käyttävät viitearvot</emph></link> -osio)."
            ],
            "id_hash": 5943166949537780611,
            "content_hash": 5943166949537780611,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3153326\nhelp.text",
            "note": "RC3x3",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 648,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": true,
            "num_words": 37,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480519/?format=api",
            "priority": 100,
            "id": 109037789,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=d27a5eda340a9383",
            "url": "https://translations.documentfoundation.org/api/units/109037789/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.981774Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "If the content of the control is read from a database, you can determine the type of the data source with the other options. For example, you can choose between tables and queries."
            ],
            "previous_source": "",
            "target": [
                "Jos ohjausobjektin sisältö on luettu tietokannasta, voidaan tietolähteen tyyppi määrittää muilla asetuksilla. Esimerkiksi voidaan valita taulut tai kyselyt."
            ],
            "id_hash": 3600282486965950697,
            "content_hash": 3600282486965950697,
            "location": "01170102.xhp",
            "context": "01170102.xhp\npar_id3153067\nhelp.text",
            "note": "wGtpV",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 649,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 33,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480547/?format=api",
            "priority": 100,
            "id": 109037796,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=b1f6c5d8c6aa58e9",
            "url": "https://translations.documentfoundation.org/api/units/109037796/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.984659Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api",
            "source": [
                "List content"
            ],
            "previous_source": "",
            "target": [
                "Luettelon sisältö"
            ],
            "id_hash": 8499722232249266573,
            "content_hash": 8499722232249266573,
            "location": "01170102.xhp",
            "context": "01170102.xhp\nhd_id3153820\nhelp.text",
            "note": "qMDCC",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 650,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/108480562/?format=api",
            "priority": 100,
            "id": 109037801,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f5f5145636b5318d",
            "url": "https://translations.documentfoundation.org/api/units/109037801/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T17:28:47.986619Z"
        }
    ]
}