Formatting Data from a Table within Textblaze sent to Datablaze

Questions and Help
1

Hi Everyone!

I am a real estate agent and I am looking to keep track of property's rents within Datablaze.

Typically I will document the current rents within a table that looks like this:
scrnli_6_28_2024_1-23-38 PM

If I were to directly copy and paste this Table into Datablaze then it would show up like this:
scrnli_6_28_2024_1-20-53 PM

I am wondering if there is a way to format this data so that it shows up in a better fashion within
the Datablaze cell? I am open to any suggestions

Thank you!!

2

Hi!

The long text field type in Data Blaze currently only support plain text without styling.

But guess what? :tada: We're actually working on a "Snippet field" for Data Blaze that will support all the styling you can use in snippet.

3

Thanks Scott! I guess I'm not really looking to format it with "bold" or "underlining" but I'd be curious to understand how to "display" this data better into the cell.

Is there maybe an option to add characters when sending the data to DB?
For example- Be able to format it - so that it shows up something like the picture below?
scrnli_6_29_2024_12-44-37 PM

I'm also open to any other suggestions, where maybe "Unit Mix" + "Rent" + "Expiration" are all separate columns and the data is entered into DB in a more reader-friendly format

Best,
Andrew

4

If you are copying and pasting to Data Blaze, no you wouldn't be able to add characters like that when you copy and paste. The Snippet Field will support tables so that would work.

Two thing that might help you today:

  1. You could use a Text Blaze formula to format the data prior to inserting it. You could output the contents in a {formparagraph} in the snippet you could copy and paste. Or you could use our {dbinsert} command to programmatically create the row in Data Blaze when you insert the snippet.

  2. You could add a Formula Field to your space that formatted the data in the space itself (you would have two fields in your space for it then) one for the unformatted and one for the formatted contents.

Let me know if you need help with either of these.

1 Like
5

Thank you Scott! I met with Ashwin- and he came up with this ingenious solution below, using a repeat formula, for my case. Which will properly "send" the data from my "actively" created table. I just wanted to share this with everyone.

Here is the output that is produced / the data that is sent to DataBlaze:
image

Please note- that within the "tableexpirationall" + "tableunitmixall" + "tablerentinfoall" formulas, the part that determines what is "in between" the entered values is this:
image
So in this case, (space)//(space) is entered in between the values that are sent to DataBlaze

** In order to send this data to Datablaze, I simply linked those previously mentioned variables to my corresponding Datablaze columns*

Please excuse the messy formatting of the generated tables within the snippet inserted below:

Snippet contents.

1 Like