Need Value from same field of a different record

Question

I'm looking to be able to reference the value of a field from a different record using certain parameters in the same table.

Context:
I have a field collection form that has hundreds of manual entry fields and one of the is an "ahead" and "back" length span of a utility pole. For many of our projects, the field technicians will have many consecutive poles that are collected and therefore, the "ahead" span length of wires will also end up being the "back" span length of the next pole. I want to be able to auto-fill that information in if the technician confirms that the current pole is consecutive.

I'm hoping this can be done via formula field, so that I can have two fields: one manual entry span field and one formula field that has the span length of the previous pole in the sequence. Then, I would have a checkbox or something asking to use previous pole's ahead span length with a form rule to change the manual entry value with the value that's in the formula field.

Can this be done? I can't seem to think of any good solutions. I was originally thinking of a DoQuery but I want the change to be live with no reloadings or save and re-edits.

#Formulasandfunctions
#Forms
#Tablesandfields
#APIsandcustomcode

------------------------------
Jordan McAlister
------------------------------

markshnier__you · Answer

What is the definition of the "Previous Pole"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

jordanmcalister · Answer

The pole they collected before their current one. Every pole is a new field record collected. Telecommunication companies want to route their lines on utility poles, so our field technicians will walk pole to pole following the route the telecommunication company wants and they collect a bunch of information. In this case, one of the things they collect is distances to the adjacent poles to run stress and tension analysis tests. If pole A is connected to pole B, then the "ahead" span of pole A will be the "back" span of pole B. If they are on pole B then the previous pole is pole A and I want there to be an option to use the previous pole's "ahead" span information for the "back" span of their current pole - if that makes sense.

Let me know if I need to explain a little more - thanks.

------------------------------
Jordan McAlister
------------------------------

markshnier__you · Answer

So this is may be doable.You need to know the Record ID# of the most current record for the current user (I assume that the Key field is Record ID#)&nbsp;Not tested but make a table and load up up with some users, well at least you. Set the Key field to be userid.Relate that table to the details table via Record Owner.&nbsp; One User has many poles.Get the Max Record ID#.&nbsp; &nbsp;Now you know the Record ID of the most recent Pole.&nbsp; Get the data you need up to that record via a summary fields or a reverse relationship.Then make a relationship to the pole table based on a reference field of current user and look up the info from the last pole.To self maintain that user table, you can set up an Automation to add a record into the table when a pole record is saved and the user does not exists.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jordanmcalister · Answer

One thing that may throw it off is that all the pole field records are created in advance when the poles are imported with the project. We have projects, poles, field collection and whenever a pole is imported into poles (usually 200 at a time) it automatically generates the pole field record. I do see where you are going with this though - is it kind of the same idea with the "click..click..click" report that needs a user table to be able to reference data between two separate tables?------------------------------Jordan McAlister------------------------------

markshnier__you · Answer

If the pole table [Record ID#]s&nbsp; are generally sequential because they are created by some automated process or import, the you can related the table to itself and the formula for the reference field for the Previous (Parent) Pole would be[Record ID#] -1------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Need Value from same field of a different record

Related Content

Add button to create record in different app

Find and Replace Field Values

Custom Record Titles

Using AND with Null values

Grabbing value between 2 fields