Hi fellow AppSheeters!
I am struggling, and have been looking / trying various codes for a solid two hours and getting nowhereโฆ
What I am trying to do is have:
As far as I can see, this should work when placed in the โValid Ifโ section:
SELECT(Clients[ClientID],
[_THISROW].[Service Area] = [ServiceArea])
But, when I do that, the field disappears from the form to complete. If I just leave it as โClients[ClientID]โ then all clients are returned, but we have 1,500 across 30 sites so thatโs obviously not ideal!
Iโm sure thereโs something small that Iโm missing, so would be very grateful for any help.
Thanks
Jo
I believe you may wish to elaborate below
It sounds that you have parent child tables with referencing. What is the key in Clients table? And have you referenced it in the Incident table?
Could you elaborate why you mention enumlist , do you wish to select many clients at a time?
The key in clients is ClientID, and itโs referenced as such:
I partly used EnumList as I found a similar setup in another app template, but I have also tried with List and Ref with no better results. In this particular field I may not need more than one client, but in others (e.g. witnesses) I will need that capability.
Thanks for helping out!
Thank you. I believe your valid_if expression and set up looks good. Does the field disappear even after saving the field definition in the editor?
Also the field will appear in the form only after one of the service area options is selected.
You wonโt believe itโฆor maybe you will! But itโs working now! Canโt see that I did anything different, but happy that itโs working now.
Thanks againโฆ
Thank you for the update. Good to know it works the way you wish.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |