+ Start a Discussion
Laura McCoy 4Laura McCoy 4 

Relate a record's fields to each other within the record? 

Is there any way to relate a record's fields to each other within the record? 
For example, on a record we would like to create 5 fields to represent the upcoming years 2021, 2022, 2023, 2024, 2025.  Then we want to associate those years with other fields on the same record such as Price, Spend, Savings. By doing so, we will be able display the total spent for that year or how much saved, ect.
It is similar to a spreadsheet/table.  We also need to be able to REPORT on the fields.
Any ideas or guidance would be greatly appreciated!
Mosh HamedaniMosh Hamedani
Our  web scraping Service (https://it-s.com/our-services/data-tranformation-services/web-scraping-services/) provides high-quality structured data to improve business outcomes and enable intelligent decision making,