Jump to content
  • 0

Check if table is empty when accessing datapage


LuluSW
 Share

Question

On a submission form that add records to table A.  I have a field that uses a dropdown control that lookup values from  table B.

My problem is that if table B is empty the submission form won't work well.

So,  how can a raise an alert on this submission form to inform the user that he first needs to add values to table B?  

It's something that before the user submits anything,  the system will identify that the lookup table is empty and raise an alert.

Thanks for your help!

 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
On 8/10/2017 at 5:25 AM, LuluSW said:

On a submission form that add records to table A.  I have a field that uses a dropdown control that lookup values from  table B.

My problem is that if table B is empty the submission form won't work well.

So,  how can a raise an alert on this submission form to inform the user that he first needs to add values to table B?  

It's something that before the user submits anything,  the system will identify that the lookup table is empty and raise an alert.

Thanks for your help!

 

Hi LuluSW,

I would suggest adding "Any" option to your drop-down.

You can allow a user to add an option to the drop-down by using concept described in this article.

Hope this helps.

 

Link to comment
Share on other sites

  • 0
On 8/17/2017 at 11:01 AM, Vitalikssssss said:

Hi LuluSW,

I would suggest adding "Any" option to your drop-down.

You can allow a user to add an option to the drop-down by using concept described in this article.

Hope this helps.

 

Thanks Vitalikssss,  but I really need to validate if the drop-down is empty.  The logic will not allow a "Any" option.

Link to comment
Share on other sites

  • 0

I tried to look for different options to resolve your issue but the only one that came up was a GET API call to count the values in table B. This way, if it is 0(zero) and alert could be fired and then you could redirect your user to Table B to add records.

Most people are afraid of using APIs but it is really easy. Although, it can not be widely published due to you need to take into consideration some variables, I can offer you development assistance. Please visit my site at https://www.futuresuite.net for more information, I will be happy to assist you.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...