Help

Circular reference in main field: a workaround?

Topic Labels: Base design Formulas
177 1
cancel
Showing results for 
Search instead for 
Did you mean: 
IVV-FSH
4 - Data Explorer
4 - Data Explorer

Hello everyone,

I'd like to have an informative main field in one of my tables but im blocked because of circular references. 

To be brief, I have a table Programme, that is referenced in Sessions, that is referenced in Half-days, that have begin & end dates.
In Sessions, i have a cumulative field that defines which is the earliest half-day of the Session in the field {from} and the latest in the field {to}.
Id Like for Sessions to have in their main field this formula:

{from} {Code name of Programme (from Programme)}

and I can't because it is causing a circular reference.

Is there a workaround any of you can think of?

or How can I get more information about the error to try and solve it?

1 Reply 1
FarioConsulting
6 - Interface Innovator
6 - Interface Innovator

Hi,
Maybe instead of directly referencing Programmes in your formula for the main field, use an editable field. You can copy values into this field manually or through automation after calculating the earliest and latest half-days