Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I suggest using only 1 table but have two forms and set the forms usage by Role.
- TinaMak7 years agoQrew TraineeI am not sure if using a role would work in this situation. I don't want my customer to have access to anything, I just want to be able to send them a report of their claims without my cost being visible to them.
I was thinking I would have to set up some sort of relationship between the tables. _ would that work? - QuickBaseCoachD7 years agoQrew Captainno problem to have one table and save yourself all that hassle. Let's keep it KISS,
Just make a new from called Customer Form. Take the easy way and duplicate your form, and rename it. Then acquire a machete and hack away at anything that the customer should not see.
As soon as you have multiple forms, QuickBase needs to know which form to use in which situation. So there will then be a forms usage section and you can associate a form with a report. So when you view or print records using that Customer Form report, it will use the Customer form.
Note also that when you go to print a report, you can choose to either print the usual list format or else print the records on one page per record and you will get to choose which form to use. - TinaMak7 years agoQrew TraineeAwesome! I will try this out! TY