Paul McCudden:
Hey everyone. I’m a beginner here with FM BetterForms. I’m setting up my first app and I’m attempting to find a way to set up log ins. I’ve read through the default way of setting up logins and have an example of that working through using a template. However I need to update it to work a different way. It would involve 2 things:
• The logins need to come from a table in FileMaker
• Based on what they log in with, I need to pull in values and store it in the app data model
Does anyone have any recommendations or links to documentation on how to set this up?
Linxue Ren:
Hi you can reference to this doc https://docs.fmbetterforms.com/reference/authentication/basic-auth
Paul McCudden:
Thanks @Linxue Ren. I was looking at that documentation earlier. Am I missing something? It seems to just talk about the stardard Auth. Apologies if I wasn’t clear. I’m looking to do something more than that. The users need to come from a non-standard table in Filemaker.
Linxue Ren:
Sorry if this doesn’t cover it. Our team @Jason Perry can provide suggestions.
Jason Wood:
Don’t try to use a different table. Require email validation and match based on email to determine what they should have access to.
For example:
User creates account.
Record created in BF table.
User clicks a link in email to verify that its theirs.
In Global Before, check for a matching record in your business file. Put the ID in a global so you have easy access to it. Make sure you clear globals like this at the start of every Global Before. Use this to validate what the user can do and what data you should send them.
Jason Perry:
@Paul McCudden The process that @Jason Wood recommends is definitely the type of approach that you want to do. I would also add that you could use a token value in the User table that matches the email link and that your User and BF_User records can be joined by having a FK for the BF_User in the User table. Please DM me with any further questions
Paul McCudden:
Great advice @Jason Wood and @Jason Perry. Thank you for your help. I’ll go about it that way. I’ll get started on implementing this and I’m sure I’ll have some more questions.