Forum Discussion
AJCampani
5 years agoQrew Cadet
Thanks Mark! I'll give this a try. I was hoping to avoid user input for the prior term to lessen the risk that they choose the wrong term since it will ultimately populate rent rolls for each mall tenant (and cause major headaches at the end of the year if its wrong). If I want to lessen that risk, without getting too complicated, do you have any guidance as to what avenue might accomplish this, even if it takes outside help (so I know what yo ask for)?
------------------------------
Albert Campani
------------------------------
------------------------------
Albert Campani
------------------------------
MarkShnier__You
Qrew Legend
5 years agoI think that it could be done automatically and then there could be an overrode by authorized Roles.
Feel free to contract me directly by my email signature and we can take this off line.
But if you think you can figure this out yourself, I think that the answer would be to pre calculate the the highest Term (Summary Maximum) so far for each of these Lease Types
Primary Term Escalation
Option Term
Holdover
That would assume that you already have a structure where 1 Primary Lease has many Child Lease Extensions (Escalations, Options or Holdovers) .
Then create Summary fields to get the Maximum (only) [Record ID#] for those three.
Then we make a button to ADD Lease and it would know which Previous Lease to attach to and it would pre-populate the field for Related Previous Lease.
Give that a try and feel free to post back with questions or contact me by the email in my signature line for one on one help. It's not a big project, probably an hour to get it working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Feel free to contract me directly by my email signature and we can take this off line.
But if you think you can figure this out yourself, I think that the answer would be to pre calculate the the highest Term (Summary Maximum) so far for each of these Lease Types
Primary Term Escalation
Option Term
Holdover
That would assume that you already have a structure where 1 Primary Lease has many Child Lease Extensions (Escalations, Options or Holdovers) .
Then create Summary fields to get the Maximum (only) [Record ID#] for those three.
Then we make a button to ADD Lease and it would know which Previous Lease to attach to and it would pre-populate the field for Related Previous Lease.
Give that a try and feel free to post back with questions or contact me by the email in my signature line for one on one help. It's not a big project, probably an hour to get it working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AJCampani5 years agoQrew CadetThanks! That's a great idea - I'll make an attempt at it now.
------------------------------
Albert Campani
------------------------------