Auto-fill Field within the Same Record
I am so frustrated! I've been searching for weeks on a way to auto-fill fields within the same record. I know there has to be an easy way to do this, but I just cannot find it. Here's what I need: ...
Forum Discussion
Sorry. That wasn't very clear. I have an app that only has one table. Each record has multiple tabs. I need to copy information from the main tab company information fields into different locations in the same record.
------------------------------
Rebecca Moore
------------------------------
------------------------------
Rebecca Moore
------------------------------
- MarkShnier__You
Qrew Legend
I will answer your question below, but I have to say it is usually not a good idea to have the same information captured in different fields on the form. Eventually you will want to run some report by customer and you'll have a mess on your hands with the customer being on multiple places on the form and perhaps the customer name spelled differently on each tab.
Now just to be clear about my interpretation of what you were saying, you seem to be saying that you were capturing for example the customer name in two different fields with two different field names.
But having said that if you do have a field that needs to be auto filled from another field, you can have a form rule that says the followingWhere multiple conditions are true
my customer name field number two is blank and my customer name field one is not blank copy then actin
Copies of value from customer name number one into the field customer name number two.Remember to uncheck the box at the very bottom of the form so that this fires all the time.
Going back to what would be a better set up, for Common fields it would be better to have those fields at the top of the form and then have the tabs below that says it's a common information is seen by our users for all tabs and then on the tabs there's only unique information just for that tab.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you. So, what if I removed one of the tabs in my table and created a new table with that information. How could I get the "main" form to populate the address? I've tried multiple times to do this, but it's just not making any sense to me. Basically taking the info highlighted below from one table auto-populating fields in another table. That would remove the duplicates withing the same table.
------------------------------
Rebecca Moore
------------------------------- MarkShnier__YouIt is possible that you were missing one of the most powerful and fundamental concepts of QuickBase. That is relationships.
https://help.quickbase.com/user-assistance/about_relationships.html?Highlight=Relationships
Do you have any relationships in your application?.For example your customer Table would hold all the customer information and then it would have child records for the other types of information. Then you would look up information from the parent record down to the trial tables.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
