There are some form elements like a select list or a radio button that uses predefined lists. When these lists are a part of the form they are static or only changeable by modifying the form. For example, you may have a part list. If you make it static, every new part will require a change in form design. The concept of Lists makes them these lists dynamic and allows to change the list items by Office users. This is a more comfortable way for both users and system admins.
Lists may have location info or coordinates. MOBIDI App may uses these coordinates to choose the closest ones to limit the number of choices. When you have thousands of ATM points or customer or place to serve locations or customers, this feature is a great time saver. And also prevent many intolerable mistakes.
...
Open Lists page
Use + to create a new
Give a name and template and choose Geometric Template if your list has geometry.
In the last page make your entries or choose a different data source as list.
...
import lists from other sources.
Import
You can import Excel(xlsx, xls, csv), mdb, accdb, accde, kml, shp files or a table in a DB as list. Once you define them they will be checked every 10minutes for changes and reimport using the rules you have selected. You need to choose which column to use as Keyword. In case of a spatial table SRID(the projection system) will be utilized.
...
Kemal Ünal (Unlicensed) QQ:bir iç eğitime bu konuyu dahil edelim. Ben halen excel kullan, 10dk da bir al, ve var olan kayıtları güncelle arasındakiilişkiyi kavrayamıyorum.
serdar ak Bey Select ile sadece o anlık keyword yüklemesi yapılıyor. Connect ile excel dosyasına bağlanıyoruz. Database dictionary olarak düşünün.
...
If you have a file-based source use From-File, otherwise use From-DB.
...
Notifying
You should use your list in your form elements(select or radio). After doing that you will not modify your form if list items are changed.
The keyword is what will show in the select lists. You should also set the ID values. When
...
your keyword changes(because of a typo or some other reason) if ID remains same this change will affect the panels and existing records. But if you do not use ID the changed line will be a new entry.
If you delete a row in the list, the deleted row will continue to exist in old records and it will be shown by its ID.
Whether a new item added, or an old item changed MOBIDI Office will update mobile user which use the affected forms. You already know how to update mobile users using the Project menu on the main menu.
Sözlükte silme işlemi var. Select sözlükteki sıraya bakıyor. Sözlükte silme olursa sadece silinen kelime eksilir. Ekstra bir sıra değişikliği olmaz. Select bu sıraya göre gözükmeye devam eder.
Kemal Ünal (Unlicensed) QQ: silinirse eski kayıtlara ne oluyor. Ö<zgür bey ID ve diğer koyular hakkında bir yığın uyarıda bulunuyor, burası ile ilgili mi? ID olursa ne olmazssa ne?
Select alana bağlı bir sözlük silindiğinde eski kayıtlarda seçilen değer kalmaya devam ediyor. Yeni kayıt ekleme sırasında select içi boş geliyor.
Export and Import Operations in List Arrangements
You can download your existing lists as excel and make necessary arrangements.
...
After making your edits, click the Upload (up arrow) button and select your file.
Before clicking the Download button, pay attention to the option to Refresh list completely.
...
When You need a different Template
For more complex and special requirements you may need other than the current Spatial and Non-Spatial Templates. Please check the following documentation to define a new template. https://decesw.atlassian.net/wiki/spaces/DESTEK/pages/edit-v2/2303983907?draftShareId=30060f37-23ab-46b7-a53f-c317c1f50819