Hi Keiran,
Harry mentioned maybe we can try to integrate our Solar Panel Case Study with Sandbox but we don't know what exactly he meant by that.
Thanks,
Ivana Rajda

Hi Milica,

A simple way of getting a count of the rows is to use the GetDatasourceRow() expression:

NumberOfResults:=GetDataSourceRow("string DatasourceName","string FilterName","Boolean returnRowCount","Boolean refresh");

set the third parameter to

"True"

to return the number of results for the specified filter.

Could you please provide more information on what you are trying to do with Sandbox integrations?

Thanks

Keiran

Hi Keiran,

There was a little misunderstanding, we found out how to save the data in database, but we don't know how to count the number of rows in the DB, to be more specific, we find a way how to calculate that, but we don't know how to do that with just one function. Also, can you help us with the sandbox integrations, if you can sent us some steps how to do that?

Thanks,
Milica Milin

Hi Milica,

To get rows of data into the data designer the best way is to use the write data function Writing away data

With regards to Do not accept default response there is currently a bug with the validation of this field type. You can work around this by using a validator expression to validate the response. Creating a Validator

Let me know if you need anymore help

Thanks

Keiran

Hi Keiran,

Can you show us how to get a number of rows into the data table, we are connected to the data base through the data designer? We also have an issue with the multiple choice question, when we select some response to be the default and we check option 'Do not accept default response if this is mandatory question' , we can still save that default response in DB. Do you have a suggestion on how to set this?

Thanks,
Milica

Hi Keiran,

Thanks for this response. We've looked at the Data Designer Training and have managed to have a play with the tools. We are looking forward to receiving the requirements doc from your side so that we can finally build you something.

Thanks,
Milica

Hi Milica,

Unfortunately you can not currently edit a property type, this functionality is going to be released in the next version of the platform. We anticipate this to be in the next few weeks. In the meantime you can access details about the data designer via the training site Data Designer Training

Thanks

Keiran

Hi Keiran,

We used the data designer, we included tables and worked with them, but we have one more question. Is it possible to edit the property type without deleting the property and creating a new one? Do you have some documentation about working with the data designer?

Thanks,
Milica

Hi Milica,

Was planning on discussing as part of our planned meeting on Thursday.

Thanks

Keiran

Hi Keiran,
Do you still want to plan a short call early this week about our DB issue or will we include it in the planned meeting on Thursday?

Thanks,
Milica