Quickly Update Asset Assignments
Good afternoon,
I am brainstorming how I can assign numerous assets to one mission quickly. The relationships are as follows:
Each Mission has many Asset Assignments
Each Asset/Service has many...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThere is probably a way to speed up this process but it would probably take 1-2 hours of consulting time. if you have a small budget to work with, contact me directly by my email address and we can get on a zoom call and I can estimate the time required.
But back to grid edit .... the assignment table just needs to have the two columns copy pasted for Related Asset and Related Mission (typically these will be the [Record ID#] of each of those two Parent tables.
If you make any sort of dummy report there and go into grid edit it will have 4 blank rows at the bottom. If you highlight those at the left and right click it will allow you to insert blank rows. You can double that to 8 rows and then repeat to double to 16 and then double to 32 to make enough room to copy paste. I see no reason why you could not copy paste the reference fields for a related mission and related asset.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hey Mark,
Sorry I am unable to allocate any funds toward this solution at this time, so I would like to understand the second part a bit better. When you are saying copying and pasting a reference field, do you mean from a downloaded excel? Because from my experience quickbase does not allow you to copy a key field from grid edit mode. Or potentially, reference field and key field is where the issue is. I am trying to copy a key field then move it to the reference field.
------------------------------
Bailey Desormeaux
------------------------------