Units
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=20
{ "count": 2273, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/units/?format=api&page=21", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/units/?format=api&page=19", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\"HID_PROP_CURSORSOURCETYPE\">Defines whether the data source is to be an existing database table or query, or if the form is to be generated based on an SQL statement.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_PROP_CURSORSOURCETYPE\">Ominaisuudella määrätään, onko tietolähteenä tietokannan taulu tai kysely, vai perustuuko lomake SQL-lauseeseen.</ahelp>" ], "id_hash": 2066435611993626897, "content_hash": 2066435611993626897, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3150541\nhelp.text", "note": "MwaSF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/108489097/?format=api", "priority": 100, "id": 109039704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=9cad743d9c18d911", "url": "https://translations.documentfoundation.org/api/units/109039704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.227046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "If you choose \"Table\" or \"Query\", the form will refer to the table or query that you specify under <emph>Content</emph>. If you want to create a new query or a <link href=\"text/shared/02/01170203.xhp\">subform</link>, then you have to choose the \"SQL\" option. You can then enter the statement for the SQL query or the subform directly in the <emph>List content</emph> box on the Control properties Data tab page." ], "previous_source": "", "target": [ "Jos valitaan \"Taulukko\" tai \"Kysely\", lomake viittaa tauluun tai kyselyyn, joka määritellään <emph>Sisältö</emph>-ominaisuudella. Mikäli on tarve luoda uusi kysely tai <link href=\"text/shared/02/01170203.xhp\">alilomake</link>, silloin valitaan \"SQL\"-vaihtoehto. SQL-kyselyn tai alilomakkeen lause voidaan syöttää suoraan ohjausobjektin ominaisuuksien Tiedot-välilehden <emph>Luettelon sisältö</emph> -ruutuun." ], "id_hash": 5053696435938678322, "content_hash": 5053696435938678322, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3153192\nhelp.text", "note": "pBBUS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 66, "source_unit": "https://translations.documentfoundation.org/api/units/108489132/?format=api", "priority": 100, "id": 109039707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=c622562202c85632", "url": "https://translations.documentfoundation.org/api/units/109039707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.229705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Analyze SQL command" ], "previous_source": "", "target": [ "Analysoi SQL-komento" ], "id_hash": -1725604470741361229, "content_hash": -1725604470741361229, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3158409\nhelp.text", "note": "ZSNb6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/108489161/?format=api", "priority": 100, "id": 109039710, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=680d6be062a29db3", "url": "https://translations.documentfoundation.org/api/units/109039710/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.232823Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Specifies whether the SQL statement is to be analyzed by %PRODUCTNAME.</ahelp> If set to Yes, you can click the <emph>...</emph> button next to the <emph>Content</emph> list box. This will open a window where you can graphically create a database query. When you close that window, the SQL statement for the created query will be inserted in the <emph>Content</emph> list box." ], "previous_source": "", "target": [ "" ], "id_hash": 2925056808308835113, "content_hash": 2925056808308835113, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3145171\nhelp.text", "note": "6XMSF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 954, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/108489194/?format=api", "priority": 100, "id": 109039712, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=a897e3ab67160329", "url": "https://translations.documentfoundation.org/api/units/109039712/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.235081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Filter" ], "previous_source": "", "target": [ "Suodatus" ], "id_hash": 4443041638787631305, "content_hash": 4443041638787631305, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3154684\nhelp.text", "note": "DuT7M", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108489241/?format=api", "priority": 100, "id": 109039715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=bda8dad48a34c8c9", "url": "https://translations.documentfoundation.org/api/units/109039715/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.237269Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Enter the required conditions for filtering the data in the form. The filter specifications follow SQL rules without using the WHERE clause.</ahelp> For example, if you want to display all records with the \"Mike\" forename, type into the data field: Forename = 'Mike'. You can also combine conditions: Forename = 'Mike' OR Forename = 'Peter'. All records matching either of these two conditions will be displayed." ], "previous_source": "", "target": [ "" ], "id_hash": -6117565072115808814, "content_hash": -6117565072115808814, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3150449\nhelp.text", "note": "oF5Lv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/108489271/?format=api", "priority": 100, "id": 109039718, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=2b1a0afaaa3345d2", "url": "https://translations.documentfoundation.org/api/units/109039718/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.239565Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The filter function is available in user mode through the <link href=\"text/shared/02/12030000.xhp\"><emph>AutoFilter</emph></link> and <link href=\"text/shared/02/12090000.xhp\"><emph>Default Filter</emph></link> icons on the <link href=\"text/shared/main0213.xhp\"><emph>Form Navigation</emph> Bar</link>." ], "previous_source": "", "target": [ "Suodatustoimintoon pääsee käyttötilassa <link href=\"text/shared/02/12030000.xhp\"><emph>Automaattinen suodatus</emph></link> ja <link href=\"text/shared/02/12090000.xhp\"><emph>Oletussuodatin</emph></link>-kuvakkeilla <link href=\"text/shared/main0213.xhp\"><emph>Lomakkeen navigointi</emph> -palkista</link>." ], "id_hash": 8672874056669514625, "content_hash": 8672874056669514625, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3156212\nhelp.text", "note": "2eNBc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/108489310/?format=api", "priority": 100, "id": 109039722, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f85c3d00f17ccb81", "url": "https://translations.documentfoundation.org/api/units/109039722/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.241939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Sort" ], "previous_source": "", "target": [ "Lajittele" ], "id_hash": -70931781410018055, "content_hash": -70931781410018055, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3156005\nhelp.text", "note": "kFDjB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108489325/?format=api", "priority": 100, "id": 109039724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=7f03ffebadc52cf9", "url": "https://translations.documentfoundation.org/api/units/109039724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.244733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Specifies the conditions to sort the data in the form. The specification of the sorting conditions follows SQL rules without the use of the ORDER BY clause.</ahelp> For example, if you want all records of a database to be sorted in one field in an ascending order and in another field in a descending order, enter Forename ASC, Name DESC (presuming Forename and Name are the names of the data fields)." ], "previous_source": "", "target": [ "" ], "id_hash": 816989551825864923, "content_hash": 816989551825864923, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3163712\nhelp.text", "note": "utCtn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 72, "source_unit": "https://translations.documentfoundation.org/api/units/108489382/?format=api", "priority": 100, "id": 109039728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=8b5687ab35c948db", "url": "https://translations.documentfoundation.org/api/units/109039728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.247040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The appropriate icons on the <link href=\"text/shared/main0213.xhp\"><emph>Form Navigation</emph> Bar</link> can be used in User mode to sort: <link href=\"text/shared/02/12010000.xhp\"><emph>Sort Ascending</emph></link>, <link href=\"text/shared/02/12020000.xhp\"><emph>Sort Descending</emph></link>, <link href=\"text/shared/02/12100100.xhp\"><emph>Sort</emph></link>." ], "previous_source": "", "target": [ "Vastaavia <link href=\"text/shared/main0213.xhp\"><emph>Lomakkeen navigointi</emph> -palkin kuvakkeita</link> voi hyödyntää käyttötilassa: <link href=\"text/shared/02/12010000.xhp\"><emph>Nouseva lajittelu</emph></link>, <link href=\"text/shared/02/12020000.xhp\"><emph>Laskeva lajittelu</emph></link> ja <link href=\"text/shared/02/12100100.xhp\"><emph>Lajittelu</emph></link>." ], "id_hash": 3525069519243641137, "content_hash": 3525069519243641137, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3156444\nhelp.text", "note": "vFong", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/108489414/?format=api", "priority": 100, "id": 109039732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=b0eb900d17130131", "url": "https://translations.documentfoundation.org/api/units/109039732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.249443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Add data only" ], "previous_source": "", "target": [ "Lisää vain tietoja" ], "id_hash": -6050809341043943048, "content_hash": -6050809341043943048, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3148616\nhelp.text", "note": "TLB5m", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/108489445/?format=api", "priority": 100, "id": 109039738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=2c0734f67f75d978", "url": "https://translations.documentfoundation.org/api/units/109039738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.252803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Determines if the form only allows the addition of new data (Yes) or if it allows other properties as well (No).</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -1018229513832181104, "content_hash": -1018229513832181104, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3153139\nhelp.text", "note": "aHghx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/108489470/?format=api", "priority": 100, "id": 109039742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=71de85a6e836d290", "url": "https://translations.documentfoundation.org/api/units/109039742/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.255524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "If <emph>Add data only</emph> is set to \"Yes\", changing or deleting data is not possible." ], "previous_source": "", "target": [ "Jos <emph>Lisää vain tietoja</emph> on asetettu \"Kyllä\"-tilaan, tietojen muuttaminen tai poistaminen eivät ole sallittuja." ], "id_hash": 1049873000219761953, "content_hash": 1049873000219761953, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3148575\nhelp.text", "note": "jxpnX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 963, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/108489496/?format=api", "priority": 100, "id": 109039748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=8e91e5ee655f5d21", "url": "https://translations.documentfoundation.org/api/units/109039748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.294093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Navigation bar" ], "previous_source": "", "target": [ "Siirtymistyökalurivi" ], "id_hash": 1864723375749421246, "content_hash": 1864723375749421246, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3148455\nhelp.text", "note": "DBEFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108489511/?format=api", "priority": 100, "id": 109039752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=99e0d407cfe958be", "url": "https://translations.documentfoundation.org/api/units/109039752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.297708Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Specifies whether the navigation functions in the lower form bar can be used.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4733572140231391453, "content_hash": 4733572140231391453, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3157976\nhelp.text", "note": "rXDye", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/108489534/?format=api", "priority": 100, "id": 109039754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=c1b106c8312d78dd", "url": "https://translations.documentfoundation.org/api/units/109039754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.299734Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The \"Parent Form\" option is used for subforms. If you choose this option for a subform, you can navigate using the records of the main form if the cursor is placed in the subform. A subform is linked to the parent form by a 1:1 relationship, so navigation is always performed in the parent form." ], "previous_source": "", "target": [ "\"Päälomake\"-asetusta käytetään alilomakkeille. Jos valitaan tämä vaihtoehto alilomakkeille, voidaan siirtyä käyttäen päälomakkeen tietueita, jos kohdistin on sijoitettu alilomakkeeseen. Alilomake liitetään päälomakkeeseen suhteella 1:1, joten siirtyminen suoritetaan aina päälomakkeessa." ], "id_hash": 6732897270609226971, "content_hash": 6732897270609226971, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3149485\nhelp.text", "note": "CjNAE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/108489600/?format=api", "priority": 100, "id": 109039759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=dd700e652bdc2cdb", "url": "https://translations.documentfoundation.org/api/units/109039759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.307685Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Cycle" ], "previous_source": "", "target": [ "Kierto" ], "id_hash": 3781782374178237467, "content_hash": 3781782374178237467, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3151051\nhelp.text", "note": "itmyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 967, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108489633/?format=api", "priority": 100, "id": 109039761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=b47b970856ba2c1b", "url": "https://translations.documentfoundation.org/api/units/109039761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.341416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Determines how the navigation should be done using the tab key.</ahelp> Using the tab key, you can move forward in the form. If you simultaneously press the Shift key, the navigation will follow the opposite direction. If you reach the last (or the first) field and press the tab key again, it can have various effects. Define the key control with the following options:" ], "previous_source": "", "target": [ "" ], "id_hash": 2611660868983138366, "content_hash": 2611660868983138366, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3154944\nhelp.text", "note": "x2yQr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 968, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/108489667/?format=api", "priority": 100, "id": 109039765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=a43e7bb92187283e", "url": "https://translations.documentfoundation.org/api/units/109039765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.343483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Option" ], "previous_source": "", "target": [ "Asetus" ], "id_hash": 8681858159585623235, "content_hash": 8681858159585623235, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3166413\nhelp.text", "note": "uThBR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 969, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108489703/?format=api", "priority": 100, "id": 109039767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f87c27ff686d7cc3", "url": "https://translations.documentfoundation.org/api/units/109039767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.345596Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Meaning" ], "previous_source": "", "target": [ "Selite" ], "id_hash": -8795066909725957892, "content_hash": -8795066909725957892, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3150424\nhelp.text", "note": "u8bTv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108489754/?format=api", "priority": 100, "id": 109039770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=05f1a53e6dfde0fc", "url": "https://translations.documentfoundation.org/api/units/109039770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.348434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Default" ], "previous_source": "", "target": [ "Oletus" ], "id_hash": 5055619061430142763, "content_hash": 5055619061430142763, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3150417\nhelp.text", "note": "JNwhB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108489787/?format=api", "priority": 100, "id": 109039773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=c6292ac0243cc72b", "url": "https://translations.documentfoundation.org/api/units/109039773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.350503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "This setting automatically defines a cycle which follows an existing database link: If the form contains a database link, the Tab key will, by default, initiate a change to the next or previous record on exit from the last field (see All Records). If there is no database link the next/previous form is shown (see Current Page)." ], "previous_source": "", "target": [ "Asetus määrää kierron, joka seuraa tiekannan linkkiä: jos lomakkeessa on tietokantalinkki, Sarkain käynnistää, oletuksena, muuton seuraavaan tai edelliseen tietueeseen viimeisesti kentästä poistumisen seurauksena (katso Kaikki tietueet). Jos tietokantalinkkiä ei ole seuraava/edellinen lomake esitetään (katso Nykyinen sivu)." ], "id_hash": 1253031846652629550, "content_hash": 1253031846652629550, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3157847\nhelp.text", "note": "GGLCT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 57, "source_unit": "https://translations.documentfoundation.org/api/units/108489823/?format=api", "priority": 100, "id": 109039777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=9163a9d35ffb522e", "url": "https://translations.documentfoundation.org/api/units/109039777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.352458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "All records" ], "previous_source": "", "target": [ "Kaikki tietueet" ], "id_hash": 5844185286613643707, "content_hash": 5844185286613643707, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3153418\nhelp.text", "note": "N3g3d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108489848/?format=api", "priority": 100, "id": 109039782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=d11ab78dea2bb1bb", "url": "https://translations.documentfoundation.org/api/units/109039782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.354847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "This option applies to database forms only and is used to navigate through all records. If you use the Tab key to exit from the last field of a form, the current record is changed." ], "previous_source": "", "target": [ "Tämä asetus soveltuu vain tietokantalomakkeille ja sitä käytetään siirtymiseen kaikkien tietueiden kautta. Jos Sarkainta käytetään lomakkeen viimeisestä kentästä poistumiseen, kohdistettu tietue vaihtuu." ], "id_hash": -3057078166605618644, "content_hash": -3057078166605618644, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3152972\nhelp.text", "note": "BqCW3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/108489877/?format=api", "priority": 100, "id": 109039785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=5593139ac4dea22c", "url": "https://translations.documentfoundation.org/api/units/109039785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.764614Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Active record" ], "previous_source": "", "target": [ "Aktiivinen tietue" ], "id_hash": -7387244224959583931, "content_hash": -7387244224959583931, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3151020\nhelp.text", "note": "T3T3G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108489924/?format=api", "priority": 100, "id": 109039788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=197b3c84463a6945", "url": "https://translations.documentfoundation.org/api/units/109039788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.767683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "This option applies to database forms only, and is used to navigate within the current record. If you use the Tab key to exit from the last field of a form, the current record is changed." ], "previous_source": "", "target": [ "Tämä asetus soveltuu vain tietokantalomakkeille ja sitä käytetään siirtymiseen kohdistetussa tietueessa. Jos Sarkainta käytetään lomakkeen viimeisestä kentästä poistumiseen, kohdistettu tietue vaihtuu." ], "id_hash": -303339283107436748, "content_hash": -303339283107436748, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3145301\nhelp.text", "note": "Em2iW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/108489971/?format=api", "priority": 100, "id": 109039791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=7bca528777f5a734", "url": "https://translations.documentfoundation.org/api/units/109039791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.769714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Current page" ], "previous_source": "", "target": [ "Nykyinen sivu" ], "id_hash": 2874863117943890082, "content_hash": 2874863117943890082, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3146913\nhelp.text", "note": "ovFpV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108490004/?format=api", "priority": 100, "id": 109039793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=a7e590c62aeae0a2", "url": "https://translations.documentfoundation.org/api/units/109039793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.772009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "On exit from the last field of a form, the cursor skips to the first field in the next form. This is standard for HTML forms; therefore, this option is especially relevant for HTML forms." ], "previous_source": "", "target": [ "Poistuttaessa lomakkeen viimeisestä kentästä, kohdistin hyppää seuraavan lomakkeen ensimmäiseen kenttään. Tämä on normaalia HTML-lomakkeissa; siksi tämä vaihtoehto sopii erityisesti HTML-lomakkeille." ], "id_hash": -2658833635743115589, "content_hash": -2658833635743115589, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3150330\nhelp.text", "note": "Gt8K2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/108490038/?format=api", "priority": 100, "id": 109039794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=5b19ece538abd6bb", "url": "https://translations.documentfoundation.org/api/units/109039794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.774215Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Allow additions" ], "previous_source": "", "target": [ "Salli lisäykset" ], "id_hash": -2992961275685615081, "content_hash": -2992961275685615081, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3155064\nhelp.text", "note": "FoBDJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108490067/?format=api", "priority": 100, "id": 109039797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=5676dd93c0424a17", "url": "https://translations.documentfoundation.org/api/units/109039797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.776809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Determines if data can be added.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4010370725362950519, "content_hash": 4010370725362950519, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3154360\nhelp.text", "note": "VkCUS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/108490094/?format=api", "priority": 100, "id": 109039798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=b7a7b2ed46e26177", "url": "https://translations.documentfoundation.org/api/units/109039798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.779365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Allow modifications" ], "previous_source": "", "target": [ "Salli muutokset" ], "id_hash": -466544088508696214, "content_hash": -466544088508696214, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3156054\nhelp.text", "note": "B4Bj2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108490130/?format=api", "priority": 100, "id": 109039801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=7986809f9461796a", "url": "https://translations.documentfoundation.org/api/units/109039801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.781762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\"> Determines if the data can be modified.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3968642636125111183, "content_hash": 3968642636125111183, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3156377\nhelp.text", "note": "KzsCx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/108490174/?format=api", "priority": 100, "id": 109039804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=b713737366b5038f", "url": "https://translations.documentfoundation.org/api/units/109039804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.784044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Allow deletions" ], "previous_source": "", "target": [ "Salli poistot" ], "id_hash": -5794477751979932288, "content_hash": -5794477751979932288, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3149019\nhelp.text", "note": "WZwcW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/108490214/?format=api", "priority": 100, "id": 109039807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=2f95e12f5e550580", "url": "https://translations.documentfoundation.org/api/units/109039807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.786025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">Determines if the data can be deleted.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -8701455460634757012, "content_hash": -8701455460634757012, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3148995\nhelp.text", "note": "KjopN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/108490226/?format=api", "priority": 100, "id": 109039810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=073e385c5ffb786c", "url": "https://translations.documentfoundation.org/api/units/109039810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.789314Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Link master fields" ], "previous_source": "", "target": [ "Linkitä pääkentät" ], "id_hash": 8031545306657628080, "content_hash": 8031545306657628080, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3153714\nhelp.text", "note": "TGmFA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/108490261/?format=api", "priority": 100, "id": 109039814, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=ef75c7e748c89fb0", "url": "https://translations.documentfoundation.org/api/units/109039814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.792738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">If you create a <link href=\"text/shared/02/01170203.xhp\">subform</link>, enter the data field of the parent form responsible for the synchronization between parent and subform.</ahelp> To enter multiple values, press Shift + Enter after each input line." ], "previous_source": "", "target": [ "" ], "id_hash": 2386300273114981899, "content_hash": 2386300273114981899, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3147339\nhelp.text", "note": "cDFUa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/108490299/?format=api", "priority": 100, "id": 109039817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=a11dd7748a6fa60b", "url": "https://translations.documentfoundation.org/api/units/109039817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.795697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The subform is based on an <link href=\"text/shared/00/00000005.xhp#sql\">SQL</link> query; more specifically, on a <link href=\"text/sdatabase/02010100.xhp\">Parameter Query</link>. If a field name is entered in the <emph>Link master fields</emph> box, the data contained in that field in the main form is read to a variable that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL statement, this variable is compared to the table data that the subform refers to. Alternatively, you can enter the column name in the <emph>Link master fields</emph> box." ], "previous_source": "", "target": [ "" ], "id_hash": -4157434670920314718, "content_hash": -4157434670920314718, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3149568\nhelp.text", "note": "zUdJF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 82, "source_unit": "https://translations.documentfoundation.org/api/units/108490345/?format=api", "priority": 100, "id": 109039821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=464dd3319ee6d0a2", "url": "https://translations.documentfoundation.org/api/units/109039821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.797713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Consider the following example:" ], "previous_source": "", "target": [ "Katsotaan seuraavaa esimerkkiä:" ], "id_hash": 8248928153740742222, "content_hash": 8248928153740742222, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3156089\nhelp.text", "note": "KAQ4c", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/108490385/?format=api", "priority": 100, "id": 109039823, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=f27a14737d6f8e4e", "url": "https://translations.documentfoundation.org/api/units/109039823/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.879260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The database table on which the form is based is, for example, a customer database (\"Customer\"), where every customer has been given a unique number in a data field named \"Cust_ID\". A customer's orders are maintained in another database table. You now want to see each customer's orders after entering them into the form. In order to do this you should create a subform. Under <emph>Link master fields</emph> enter the data field from the customer database which clearly identifies the customer, that is, Cust_ID. Under <emph>Link slave fields</emph> enter the name of a variable which is to accept the data of the field Cust_ID, for example, x." ], "previous_source": "", "target": [ "Se tietokannan taulu, mihin lomake perustuu, on esimerkiksi asiakastietokanta (\"Customer\"), jossa jokaiselle asiakkaalle on annettu yksilöllinen numero tietokannan \"Cust_ID\"-nimiseen kenttään. Asiakkaan tilaukset säilytetään toisessa tietokannan taulussa. Nyt esiintyy tarve nähdä kukin asiakkaan tilauksista sen jälkeen kun ne on syötetty lomakkeelle. Tätä varten pitää luoda alilomake. <emph>Linkitä pääkentät</emph> -kenttään syötetään asiakastietokannan tietokenttä, joka tarkasti määrittää asiakkaan, se on Cust_ID. Kenttään <emph>Linkitä alisteiset kentät</emph> syötetään sen muuttujan nimi, johon tieto kentästä Cust_ID sijoitetaan, esimerkiksi x." ], "id_hash": 192617738330589911, "content_hash": 192617738330589911, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3151017\nhelp.text", "note": "nnWRE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 107, "source_unit": "https://translations.documentfoundation.org/api/units/108490433/?format=api", "priority": 100, "id": 109039825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=82ac50cffea24ad7", "url": "https://translations.documentfoundation.org/api/units/109039825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.886659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The subform should show the appropriate data from the orders table (\"Orders\") for each customer ID (Customer_ID -> x). This is only possible if each order is uniquely assigned to one customer in the orders table. Alternatively, you can use another field called Customer_ID; however, to make sure that this field is not confused with the same field from the main form, the field is called Customer_Number." ], "previous_source": "", "target": [ "Alilomakkeen pitää esittää asiaankuuluvaa tietoa tilaustaulusta (\"Orders\") jokaisesta asiakasnumerosta (Customer_ID -> x). Tämä on mahdollista vain, jos jokainen tilaus on yhdistetty yksilöitävästi yhteeen tilaustaulun asiakkaaseen. Vaihtoehtoisesti voidaan käyttää toista kenttää, jota nimitetään Customer_ID:ksi; sekaannuksen estämiseksi päälomakkeen samannimisen kentän kanssa, tämä kenttä nimetäänkin Customer_Numberiksi." ], "id_hash": -4778763154632961858, "content_hash": -4778763154632961858, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3151248\nhelp.text", "note": "FpEoP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 990, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/108490478/?format=api", "priority": 100, "id": 109039830, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=3dae6c3ad66090be", "url": "https://translations.documentfoundation.org/api/units/109039830/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.890785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Now compare the Customer_Number in the \"Orders\" table with the Customer_ID from the \"Customers\" table, which can be done, for example, using the x variable with the following SQL statement:" ], "previous_source": "", "target": [ "Verrataan nyt Customer_Numberia \"Orders\"-taulusta Customer_ID:hen \"Customers\"-taulussa, mikä voidaan tehdä, esimerkiksi käyttämällä muuttujaa x seuraavassa SQL-lauseessa:" ], "id_hash": -3238343712117944587, "content_hash": -3238343712117944587, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3153537\nhelp.text", "note": "2pAGX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/108490505/?format=api", "priority": 100, "id": 109039834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=530f178d22970ef5", "url": "https://translations.documentfoundation.org/api/units/109039834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.893425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "SELECT * FROM Orders WHERE Customer_Number =: x (if you want the subform to show all data from the orders table)" ], "previous_source": "", "target": [ "SELECT * FROM Orders WHERE Customer_Number =: x (jos halutaan alilomakkeen esittävän kaikki tilaustaulun tiedot)" ], "id_hash": 1441258188636147042, "content_hash": 1441258188636147042, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3155335\nhelp.text", "note": "QnzcR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/108490532/?format=api", "priority": 100, "id": 109039838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=940060afbb47cd62", "url": "https://translations.documentfoundation.org/api/units/109039838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.895540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "or:" ], "previous_source": "", "target": [ "tai:" ], "id_hash": 7380560091270366434, "content_hash": 7380560091270366434, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3163727\nhelp.text", "note": "Gs8Vq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/108490547/?format=api", "priority": 100, "id": 109039842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=e66d044c939844e2", "url": "https://translations.documentfoundation.org/api/units/109039842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.897408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "SELECT Item FROM Orders WHERE Customer_Number =: x (if you want the subform from the orders table to show only the data contained in the \"Item\" field)" ], "previous_source": "", "target": [ "SELECT Item FROM Orders WHERE Customer_Number =: x (jos halutaan tilaustaulun alilomakkeen esittävän vain \"Item\"-kentän tiedot)" ], "id_hash": 309310433542067934, "content_hash": 309310433542067934, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3153921\nhelp.text", "note": "KK2MB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/108490569/?format=api", "priority": 100, "id": 109039846, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=844ae4335498d6de", "url": "https://translations.documentfoundation.org/api/units/109039846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.899086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "The SQL statement can either be entered in the <emph>Data source</emph> field, or you can create an appropriate parameter query, which can be used to create the subform." ], "previous_source": "", "target": [ "SQL-lause voidaan syöttää joko <emph>Tietolähde</emph>-kenttää tai voidaan luoda asiaankuuluva parametrikysely, jota voidaan käyttää alilomakkeen luomiseen." ], "id_hash": -8041282891789980307, "content_hash": -8041282891789980307, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3148488\nhelp.text", "note": "PGoEB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 995, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/108490619/?format=api", "priority": 100, "id": 109039850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=10679fd0806ead6d", "url": "https://translations.documentfoundation.org/api/units/109039850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.902851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Link slave fields" ], "previous_source": "", "target": [ "Linkitä alisteiset kentät" ], "id_hash": -4409638271607241092, "content_hash": -4409638271607241092, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3150648\nhelp.text", "note": "hDkCP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/108490643/?format=api", "priority": 100, "id": 109039851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=42cdd15af0e2067c", "url": "https://translations.documentfoundation.org/api/units/109039851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.904391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "<ahelp hid=\".\">If you create a subform, enter the variable where possible values from the parent form field can be stored.</ahelp> If a subform is based on a query, enter the variable that you defined in the query. If you create a form using an SQL statement entered in the <emph>Data source</emph> field, enter the variable you used in the statement. You can choose any variable name. If you want to enter multiple values, press Shift + Enter." ], "previous_source": "", "target": [ "" ], "id_hash": 1058372411312619826, "content_hash": 1058372411312619826, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3149923\nhelp.text", "note": "i66Gk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 77, "source_unit": "https://translations.documentfoundation.org/api/units/108490678/?format=api", "priority": 100, "id": 109039856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=8eb01819c05cc132", "url": "https://translations.documentfoundation.org/api/units/109039856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.907163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "If, for example, you specified the Customer_ID database field as a parent field under <emph>Link master fields</emph>, then you can define under <emph>Link slave fields</emph> the name of the variable in which the values of the Customer_ID database field are to be stored. If you now specify an SQL statement in the <emph>Data source</emph> box using this variable, the relevant values are displayed in the subform." ], "previous_source": "", "target": [ "Jos, esimerkiksi määritetään tietokannan Customer_ID-kenttä pääkentäksi <emph>Linkitä pääkentät</emph> -ominaisuudelle, silloin voidaan <emph>Linkitä alisteiset kentät</emph>-ominaisuudessa määrittää sen muuttujan nimi, johon tietokannan Customer_ID-kenttä tallennetaan. Jos nyt määritetään SQL-lause <emph>Tietolähde</emph>-ruudussa muuttujaa käyttäen, vastaavat arvot esitetään alilomakkeessa." ], "id_hash": -5299745732540545970, "content_hash": -5299745732540545970, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3155114\nhelp.text", "note": "9A7by", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 66, "source_unit": "https://translations.documentfoundation.org/api/units/108490696/?format=api", "priority": 100, "id": 109039860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=36738555e407444e", "url": "https://translations.documentfoundation.org/api/units/109039860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.909221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "What is a subform?" ], "previous_source": "", "target": [ "Mikä on alilomake?" ], "id_hash": 558413144039315748, "content_hash": 558413144039315748, "location": "01170203.xhp", "context": "01170203.xhp\nhd_id3152778\nhelp.text", "note": "yRsdD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 999, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/108490732/?format=api", "priority": 100, "id": 109039864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=87bfe1cbc05f5924", "url": "https://translations.documentfoundation.org/api/units/109039864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.912024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textshared02/fi/?format=api", "source": [ "Forms are created based on a database table or database query. They display the data in a visually pleasant fashion and can be used to enter data or edit data." ], "previous_source": "", "target": [ "Luotavat lomakkeet perustuvat joko tietokannan tauluun tai tietokantakyselyyn. Niiden avulla esitetään aineisto helposti luettavassa muodossa ja niitä voi käyttää aineiston syöttämiseen tai muokkaamiseen." ], "id_hash": -794809897139328215, "content_hash": -794809897139328215, "location": "01170203.xhp", "context": "01170203.xhp\npar_id3155579\nhelp.text", "note": "9cMxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/108490762/?format=api", "priority": 100, "id": 109039868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textshared02/fi/?checksum=74f8449c110bab29", "url": "https://translations.documentfoundation.org/api/units/109039868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:28:50.915426Z" } ] }