22
Views
6
Comments
Close/open form or check box based on data in database
Question

i want to show the checkbox when there are no data in db. and close it when have data. then, the user can fill the form and submit it and then it will display the data and close the form and checkbox. i hope you can understand.

FBS.oml
Champion

Hi

For checkbox visibility you can use data size like if you are using aggregate to fetch the data then can use empty property of aggregate to control the visibility.

On each data added by form you just need to refresh the aggregate.

Regards

Champion

Hi @Azfar Aiman 

Very simple logic you need to apply there is Empty property with the aggregate or list just use this empty property of aggregate/list for showing or hiding checkbox and form

Put check box or form inside true branch of below condition

Condition - not Aggregate.list.empty

This condition means when there is no data in tabe it shows true.

Thanks

Arun

is it like this?

how can i make the details will display after submit the form.

FBS.oml
Champion

Hi Azfar,

Please check attached oml which is modified.

As there is no data for Name drop down so I was not able to save data but I put the open/close condition.

Do let me know if need any clarification

Thanks

Arun

FBS.oml
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.