Skip to main content
Question

Lookup a value with multiple conditions into a field in a separate table

  • March 5, 2024
  • 0 replies
  • 78 views
Forum|alt.badge.img+1

I have a table called "Forecasts" with many different forecasts at different time periods.  I want to create a field in another table that pulls a specific value from the "Forecasts" table into a field called "Original Forecast".  The criteria for the "original forecast" field would be: Year = 2024, Forecast Type = Original, and the Column Name = Yearly Forecast.

Can anyone point me in the correct direction?



------------------------------
Zachary Stein
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Quickbase Alumni
    • March 5, 2024

    Is the secondary table related to Forecasts? You can use native summary fields to pull the value in question using those constraints as the conditions, and then set 2024 as a variable or global setting, or based on the current year if it's rolling



    ------------------------------
    Chayce Duncan
    ------------------------------
      Terms & ConditionsAccessibility statement