Element keeps deleting itself

[AlfredoChavez]

Hi!

I am having some trouble adding an element to a table. Some times the element deletes the field that ref another table. This has happened multiple times. The first column in this table was originally full.

It also sometimes shows 0 related elements but still shows an element or it counts some elements but doesn't show any.

.

Any idea what could I be doing wrong?

Thanks!

Edit:

I am adding data by clicking addd and filling out the following form.

I checked the events being triggered by elements being added to the table and the  field 'Cod Re' was missing even though I filled it out in the form. The column is a ref type without any formulas or data validation.

[WillowMobileSys]

---

@AlfredoChavez wrote:

It also sometimes shows 0 related elements but still shows an element or it counts some elements but doesn't...

---

This could likely mean that the datasource used in the App Formula doesn't match the datasource specified in the column definition.  Open the column definition and make sure these match.  See image. 

Fix this problem first and then see if you still have the first issue you raised.

[AlfredoChavez]

I don't have any formulas. It is just a ref type column.

[WillowMobileSys]

The column with the name "Related xyz" in the parent table MUST have an expression listed in it.  Again, I was attempting to address your second issue first as it may help with the first.

[AlfredoChavez]

They are the same table. This is happening with a lot of my tables.

[WillowMobileSys]

---

@AlfredoChavez wrote:

the  field 'Cod Re' was missing even though I filled it out in the form. The column is a ref type without any formulas or data validation.

---

Make sure that the value being supplied to the field is the Row Key from the referenced table.  It looks like you are using a dropdown to select the value.  The expression used to create that dropdown list MUST return a list of Row Keys from the referenced table.

A common mistake is to have the expression return a more user friendly value for the dropdown.  Instead the expression should return Row Keys AND then, in the referenced Table,  the column you wish displayed is set as the Label.  AppSheet will automatically display the column set as Label in the dropdown but then record the Row Key to the datasource as a pointer to the row.

If you are unsure what I mean, then please post the expression used in the dropdown and the Table definition so we can help verify you are using the correct expression in that Ref column.

I hope this helps!

[Saany]

Hello Willow,

I have same problem as Alfredo. Can you please suggest what might be the problem as obviously i cannot see it.

Every time i enter the values in the inline view they disappear. But if i go back to google sheets, entry is there in the Crew Entry table.

I also have another one which works okay, there it is:

thank you for the help