Extending Users for Forms

Question

I am looking to extend the usage of the built in user in a few ways. I want to create a HR app and I am thinking I can user the base built in to Quick Base and extend its data with addresses etc. Is there a way to do that? Or should I be creating a new Employees table?

In a seperate app, project manager, I have it set to use the user table for assigning certain values. However, for example it displays names as last name, first name. Is there a way to change that behavior so it reads name First Name Last Name?

quickbasecoachd · Answer

The built in User table is only for controlling access Permissions so yes, you should create a new table for Employees. You may also want to have a separate app for the HR app.

For your other question, there is a field setting on that User type field to change the display to "Full Name". That means like John Smith. .

ivanweiss · Answer

Thanks, the plan is to make a seperate app for HR functions....

As to the user name full name I did find that. But is there a way to globally set it in my application? I use it a lot so a bit of a pain to change it individually

quickbasecoachd · Answer

There is no Global setting.

But you will end up wanting a table of users in your app to use for drop down lists anyways.

When you just are using the native User field, you will be unable to filter the drop down list. You will find that for some apps you only want to have the drop down list fir Managers, or technicians or some other criteria.

But there will still not be a global setting. It�s an extra Click when you create each User field.

ivanweiss · Answer

So you are saying it is best to create a standalone table?&nbsp; I am new so my thinking was that doesnt give me the ability to use the "current logged in user" in some of the dynamic forms and other places.&nbsp; That is why I went this route first.&nbsp; But I am a newbie so possibly wrong on that.&nbsp; But yes I could already see why filtering on a role would help me a lot as one thing I am doing is assigning project managers, designers, etc. so right now it is going to show all 50 people

quickbasecoachd · Answer

You can have a table of Users and set the Key  field to be the Userid.   That was sort of give you the best of both worlds, because you can�t still default certain fields to be the current user and yet still brought in information from your employee table.

Forum Discussion

Extending Users for Forms

Related Content

Allow users to edit multiple forms

Switch between forms

Get the role of a user in a user field

Prevent save a record - New forms

Form Rule Question