Values from columns (column is a formula based on other values in the sheet) disappears

[Dan_Oliphant]

Here is a video of what I am describing. I am using a database and the column type is decimal.

[Steve]

Are the computed values being stored in the database correctly?

Please post screenshots of the affected column configurations.

[Dan_Oliphant]

| bol_total_labor | decimal(9,2) | YES | | NULL | |
| bol_totalmat | decimal(9,2) | YES | | NULL |
| bol_storagecharges | decimal(9,2) | YES | | NULL |

| total_addserv | decimal(9,2) | YES | | NULL | |
| bol_totalcharges | varchar(255) | YES | | NULL | |
| bol_deposit | decimal(9,2) | YES | | NULL | |
| bol_totaldue | varchar(255) | YES | | NULL |

[Steve]

Dan_Oliphant:

| bol_total_labor | decimal(9,2) | YES | | NULL | |
| bol_totalmat | decimal(9,2) | YES | | NULL |
| bol_storagecharges | decimal(9,2) | YES | | NULL |

| total_addserv | decimal(9,2) | YES | | NULL | |
| bol_totalcharges | varchar(255) | YES | | NULL | |
| bol_deposit | decimal(9,2) | YES | | NULL | |
| bol_totaldue | varchar(255) | YES | | NULL |

I don’t know what all this is telling me. Are these the SQL column settings? I’m really more interested in the AppSheet column configurations. Sorry for the confusion.

Dan_Oliphant:

when i search the values in MYsql they are still NULL

So, no, the values aren’t being saved?

Dan_Oliphant:

would it be easier to write a code that calculates bol_totalcharges and bol_totaldue in the database itself?

That depends on your database skills, but AppSheet prefers to manage the data it’s expected to use, so doing it in the database may cause problems later, it will require a sync before the value will be visible in the app, and will prevent the calculation from occurring while the app is offline.

[Dan_Oliphant]

i have tried bol_totalcharges and bol_totaldue a few different column types.

when i search the values in MYsql they are still NULL

[Dan_Oliphant]

would it be easier to write a code that calculates bol_totalcharges and bol_totaldue in the database itself?

[Dan_Oliphant]

[Dan_Oliphant]

so these are all the column configurations. Is it because the things that are being added together to get bol_totalcharges are formulas themselves?

[Steve]

Dan_Oliphant:

Is it because the things that are being added together to get bol_totalcharges are formulas themselves?

I don’t think so.

I suspect the problem might be that the database is rejecting the values for some reason. As a result, the fields in the database row remain NULL. When the app syncs in the background, the database returns the NULL values of those fields, AppSheet sees they’re blank in the database, so blanks the app’s copy.

Is there a log file on the database that might show why the update failed? The audit log in the app editor might show something as well.

So you know, I’ve not used AppSheet with a database back-end, so I’m winging it here. You may want to engage support@appsheet.com to get someone more qualified.

[Dan_Oliphant]

[Dan_Oliphant]

I agree. I think it has to do the with column type in the database. just not sure which other column type to try to get the data to stick

[Dan_Oliphant]

Here is another video that may help someone (smarter than me )

this seems to be the issue… just don’t know how to solve it.

[Dan_Oliphant]

here is a video with sound

https://drive.google.com/file/d/1S3eog0NBzVLPWK3Ihw5HgduIgS1SI8TX/view