9/3/2023 0 Comments Linking tables in ninox![]() ![]() Download the iPhone, iPad, and Mac apps for free. To sync data on multiple devices, install Ninox on your iPhone, iPad, or Mac. More than “just” a database, it’s an entire application development platform." Easily the best of the App Store databases." "I found it easy to create databases and tables, to import and export data, design appropriate layouts, powerful filtering for fields, and also a very good formula field. Ninox provides a large number of use cases, such as inventory, invoicing, accounting, CRM, event management, and real estate. The Ninox platform is used by individuals, start-ups, agencies, small businesses, and enterprises in a wide range of industries. Digitize your organization, improve your workflows, and become more productive. AN easy way to look for missing links is to add, in a tabular view of the "Current Categories" table, a formula column containing "'Master List'", and to filter that column with the condition "undefined", *without* the quotes.Ninox is an easy-to-use database app for your iPhone, iPad, and Mac to help you and your team create, connect, and collaborate with databases.īuild tailor-made business apps and databases, also for CRM and ERP, without a single line of code. Before deleting the field, it is probably prudent to verify that all records in "Current Categories" have a working link to a record in 'Master List'. If you need the value of "email" in that table, you may obtain it with the formula "'Master List'.email". Now that the reference fields have been initialized, the "email" field in the "Current Categories" has become redundant, and should be deleted. A side effect is that, if several records in the "Master List" table contain the same value in the "email" field, the link will point to the first one. The "first" function is needed because "select" always returns an array. Enter the formula:įirst(select 'Master List' )Īnd execute the update. Chose the "Assign calculated value" option for the "Master List" field. So, in the "Current Categories" table, select the "Update multiple fields" option from the "Gear" menu. To populate the references, one must again work from the "N" side. Those are the names by default of the reference fields, you may change them if you prefer more descriptive names. You will see that a N:1 reference field named "Master List" has been created in the "Current Categories" table, and that a 1:N reference field named "Current Categories" has also been created in the "Master List" table. So, in the "Current Categories" table, perform the action "Create table reference" to the "Master List" table. Links are always created from the "N" side. From your description, I understand that several records in the "Current Categories" table must be linked to one record in the "Master List" table, so the "Current Categories" table must include a N:1 reference to the "Master List" table. Fortunately, it is not very difficult to make Ninox initialize its flavor of links from values in an imported table.įirst, the link must be defined. ![]() Ninox manages links by some internal mechanism - what I would call "hard links". Contrary to some other well-known database systems, Ninox does not manage links depending on the value of some data fields - what I would call "soft links", because changing the value of a data field "automatically" updates the link.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |