auto populate information from another table
I have seen other users ask this question, but the responses all seem to be specific to their business (which is awesome customer service BTW), but I cant figure out how to translate it to my business...
Forum Discussion
you have two or three choices.
My best suggestion is to put in a ticket and ask to have your Realm be given access to the Type Ahead Record Picker. That is a new feature in Early Access which will be pushed out to "GA" (General Availability) in a month or two.
That improved record picker searches as you type, so the user can just start typing whatever and get a smaller and small list, the more they type.
If you do want to limit the users to just key in a number, then copy the field for [Related Customer to a new field called [Customer ID entry]. Then change the field type for [Related Customer] to be a formula numeric field equal to the [Customer ID entry]
If you have existing data in your app, you may want to practise this in a copy of your app first so as to be sure not to lose data connecting the customers and their winnings.
But really, just sign up for EA for Type ahead record picker and that will solve your issue.
My best suggestion is to put in a ticket and ask to have your Realm be given access to the Type Ahead Record Picker. That is a new feature in Early Access which will be pushed out to "GA" (General Availability) in a month or two.
That improved record picker searches as you type, so the user can just start typing whatever and get a smaller and small list, the more they type.
If you do want to limit the users to just key in a number, then copy the field for [Related Customer to a new field called [Customer ID entry]. Then change the field type for [Related Customer] to be a formula numeric field equal to the [Customer ID entry]
If you have existing data in your app, you may want to practise this in a copy of your app first so as to be sure not to lose data connecting the customers and their winnings.
But really, just sign up for EA for Type ahead record picker and that will solve your issue.