LuluSW Posted August 10, 2017 Report Share Posted August 10, 2017 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! Quote Link to comment Share on other sites More sharing options...
0 Vitalikssssss Posted August 17, 2017 Report Share Posted August 17, 2017 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. Quote Link to comment Share on other sites More sharing options...
0 LuluSW Posted September 9, 2017 Author Report Share Posted September 9, 2017 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. Quote Link to comment Share on other sites More sharing options...
0 douvega Posted September 29, 2017 Report Share Posted September 29, 2017 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. Quote Link to comment Share on other sites More sharing options...
Question
LuluSW
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
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.