Apologies as I come from another low-code tool where it was possible to define views consisting of two (or more) tables joined by record-selector type fields. In each view, you could choose one table which was editable and the others were read-only. This made it possible to display record lists with data from two (or more) different tables. For example,
Name | Address | Phone | Case Status
where Name, Address, and Phone come from the Contact table and Case Status from a Case table where the view was Contact and Case joined on ContactID.
In Corteza, is the only way to accomplish this to duplicate āCase Statusā as a field on the Contact module and create a workflow to continuously update the related Contact records when Case Status changes on the Case module? While also preventing Case Status from ever being directly edited on the Contact module through permissioning? This feels overly complicated and Iām hopeful Iām missing something.
If not, do you anticipate anything āviewā-like in the future for Corteza record lists?
The only way to show multiple fields from the linked module/table is by using:
Reporter, by using 2 Load datasources and linking them. Data not editable though
Similarly, you can have a Database view and create a module that points to that view.
The most common way people show linked data is by having Record blocks on record pages that display relevant data from the linked record (via Record field). The record list can be configured to open in a dialog to make checking different records easier.
I was able to point a module at a view, but the record list is behaving strangely. There are 441 records in my view. The default of 14 records does show, but the buttons to move to the next page are greyed out. If I change the number of records per page to something greater than 441, they do all show, but still no ability to page, even with the āuser can select records per pageā option.