Forum Discussion
MikeKlausing
6 years agoQrew Assistant Captain
I think what might be an easier way of doing this for me is to create a filter that filters all quotes and only shows the ones that havent been ordered yet.
------------------------------
Mike Klausing
------------------------------
------------------------------
Mike Klausing
------------------------------
- EvanWestbrook6 years agoQrew CadetMike,
You're on the right track with not wanting to delete the data. How about something like this?
- Make sure "Quotes" is related to "Dealer Orders" one to many
- Pull in any relevant "Quotes" fields to "Dealers Orders" with Lookup Fields through [Related Quote]
- Update the automation to copy only [Record ID#] on a "Quotes" record to [Related Quote] on a new "Dealer Orders" record
- Create a summary field on "Quotes" to count the # of "Dealer Orders" records related to a Quote.
- Set up a filter on "Quotes" so that a record is hidden if [# of Dealer Orders] > 0
------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------- BabiPanjikar6 years agoQrew Assistant Captain@Evan Westbrook solution should give you the desired outcome instead of going for deleting the data unless there is a need to do so.
------------------------------
Babi Panjikar
------------------------------- Jan-WillemSpeck6 years agoQrew Assistant CaptainHi
I'm in a similar situation and found this thread as i was orientating for solutions.
In my case the situation is about submitted change requests including budgets including currency exchange rates n relation to projects.
I was thinking to build something like Mike described in his initial post. Reason to do so is that I need to make sure in some way that projects managers (PM) cannot mess with budgets and details after approvals have been granted
I believe this would be easiest to manage to move and thus freeze the data incl costs and exchange rates to a new table where these group of PM's only have read access.
I will also build a quick test app around Even's suggestion to see how that works out.
Open for suggestions and experiences from others out there who faced similar issues as there is no need to re-invent the wheel.
Thanks JWS
------------------------------
Jan-Willem S
------------------------------