Display table data in HTML Block

[sunsensesolar]

I have a Submit form where I select a client account in a dropdown and it displays the account info in fields below via cascading auto complete. Instead of using a dropdown and fields, can I instead load/display the table data (account info) in an HTML block using parameters? or any other way?

[MayMusic]

Do you want to save this info? If you want to save them then you need to have cascading element. If it is for showing purposes you can create a per-defined details page and instead of selecting the account on the same page search for it and see the details and add the submission page where you have deployed details page.

[sunsensesolar]

I do not need to save the info only display it with cascading autocomplete. But it needs to be on the Submission Form. I need to display in multiple lines (carrage return) so it looks like this:

Address: 1234 something Road
Billing Addess: 2334 somewhere parkway Suite 33
Phone: (555)-555-5555

I would like to display it in HTML however a text filed or text area would work

I've tried a creating a formula field that combines the account information to display in a single filed but a carrage return, +CHAR(13) , is not working in a cascading text field.

[Kurumi]

Hi @sunsensesolar,

Just an update: You could use the Calculated Values on this one. Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. Similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions that you can use in  Virtual Field then put it in HTML Block. After that, you can hide the Virtual field itself. For more information about Calculated Values, check this article: https://howto.caspio.com/datapages/datapage-components/calculated-values/ and Virtual Fields: https://howto.caspio.com/datapages/datapage-components/virtual-fields/

Hope it helps!