Replacing blank values with '--' in output table

[miu]

Hello Guys,

I have a table which enters date & text field. When there is no value entered, the date is saved as 1900-01-01 while the text field saves as blank in the DB.

In the output table, i want to display '--' instead of 1900-01-01 & blank space.

How to achieve this result?

[Teodor]

@miu

When there is no value entered, the date is saved as 1900-01-01 while the text field saves as blank in the DB.

What are you sending to your database as value?
What is the exact value your db returns, you can see it in the network > XHR tab in the browser dev tools.

[miu]

I am sending blank values.
This is what the network > XHR tab returns:

This is the DB entry:

Also, I don't mind sending dummy values if that is required to achieve the desired result.

[Teodor]

Are you sure this is the value your db returns - 1900-01-01 and not 0000-00-00?
Can you just check what the server action actually returns in the Network > XHR as explained here:

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[miu]

This is what the Update server action returns from the XHR page:

[Teodor]

not the update server action ... i need the info from the one returning the actual dates on your page.

[miu]

This is the response from the query which returns the dates & other info on the page.

[Teodor]

You can then use the replace formatter and replace 1900-01-01 with whatever string you like

[miu]

Yes, got it.
Thanks for your help, yet again !!