Offline Mode: Loading Error on Forumlar from CDS & Add Data Forms to a Single Row in Collections

[PivotMananger]

Im trying to remove this Error

 

I already build up a Offline Cache Mode with this guide but I cant remove the DataForms from my CDS. 

Is there a Option to remove or to ignore this Error ? 

___________________

And How Can I save my DataForms to a single Row in a Collection ? 

Collect(
OfflineData;
DataFormPage1.Updates;
DataFormPage2.Updates;
DataFormPage3.Updates;
DataFormPage4.Updates;
DataFormPage5.Updates;
DataFormPage6.Updates;
DataFormPage2Bemerkung.Updates;
DataFormPage3Bemerkung.Updates;
DataFormPage4Bemerkung.Updates;
DataFormPage5Bemerkung.Updates
)

 This Code is making 10 Rows to my Collection 

[PivotMananger]

Im also looking for a Solution to implement a View mode

The Formulas switch to ViewForm Mode  If you Click on the selected Gallery Item).

The DataFormulars (Six DataFormular) load the filtered Record to their formular fields.

[v-siky-msft]

Hi @PivotMananger ,

Could your share more details with your Issue?

When does this error occur?

What does 'remove the DataForms' mean? 

If you want to patch these in one row, you should modify it as below:

Collect(
OfflineData; {
column1: DataFormPage1.Updates;
column2: DataFormPage2.Updates;
column3: DataFormPage3.Updates;
column4: DataFormPage4.Updates;
column5: DataFormPage5.Updates;
column6: DataFormPage6.Updates;
column7: DataFormPage2Bemerkung.Updates;
column8: DataFormPage3Bemerkung.Updates;
column9: DataFormPage4Bemerkung.Updates;
column10: DataFormPage5Bemerkung.Updates
})

 Best regards,

Sik

[v-siky-msft]

Hi  @PivotMananger ,

To you second post, what does DataFormulars mean?

Can you share more app logical design of your apps?

Best regards,

Sik

[PivotMananger]

1st Problem:

This error occurs everytime if the user is trying to use the formulars in offline mode. 

Because the formulars has a cds as datasource.

I want to remove the red errors as you can see in my first pictures.

3rd Problem

Im also still looking for a solution to my 2nd post.

DataFormPage1-6

are my formulars

If I click on my Gallery Item. my formulars should switch to view mode and load every fields from the selected record to my formulars

 --> Click --> Load Selected Record (Using Filter with Projekt Nr.) --> Switch other Screens (They are  Formulars) to Viewmode -> Load the data of the selected Record to  the formular fields.

This is my Code so far

EditForm(DataFormPage1);;
ClearCollect(
    CurrentItem;
    First(
        Filter(
            LocalCollection;
            'CDS (cr318_id)' = ThisItem.'CDS(cr318_id)'
        )
    ));; 
Navigate(XX_DemoPage1_DataCard);;

 My CurrentItem Collection is filled with my Selected Item. Now I just need to load CurrentItem to my 6 forms.

[PivotMananger]

2nd Problem

Ok I still have trouble with the collect solution 

My Offline Data Collection need to collect every single field as column. 

Do I have to name every field item in my collect fx ?  like

 Column: TextBoxPage1ProjektNo.Text 

Or is there a Solution to use my "DataFormPage1" to generate for every field a column to my OfflineData Collection

[PivotMananger · Accepted solution]

I fixed my 1st problem:

Solution:

I changed in my forms the Datasource from cds to localcollection.

Like this the app is also a way faster. 

I also fixed my problem No. 3 

I used a patch method (instead of Collect) and rewrite my saving algorithm 

_____

But im still looking for a solution to my other two problem

Do you need more information ? 🙂