Hi Sam, would love to help but could use more information
Could I get screenshots of the following please?
- The
Applications Import
linked field with linked records in it
- The
Applications Import
table with the linked records from the previous screenshot visible, as well as the NAF
field
And with reference to the screenshots, an example of what you would want the rollup to display
Thanks!
Hi Sam, would love to help but could use more information
Could I get screenshots of the following please?
- The
Applications Import
linked field with linked records in it
- The
Applications Import
table with the linked records from the previous screenshot visible, as well as the NAF
field
And with reference to the screenshots, an example of what you would want the rollup to display
Thanks!
Thanks Adam,
Ive kind of got it to work but requires me to select the records to rollup which i want it to do itself as there are too many.

The below screen is the raw application data sample

Thanks Adam,
Ive kind of got it to work but requires me to select the records to rollup which i want it to do itself as there are too many.

The below screen is the raw application data sample

Hey Sam, hmm, given that Table 1 (the consolidated data table) has it’s primary key as the date, we can just use an automation to paste the Date
value from Table 2 (the raw data table) into the linked field

Does that help?
You can find the setup here
Adam, that is legendary…ive managed to make it work in my data.
Now a fresh problem is i need a running tally of the results to compare Forecast MTD to Actual MTD… this is currently how i have the data setup

Adam, that is legendary…ive managed to make it work in my data.
Now a fresh problem is i need a running tally of the results to compare Forecast MTD to Actual MTD… this is currently how i have the data setup

Hey Sam, glad I could help.
I’ve got a vague idea of what you’re trying to do, but could you share a bunch of example data as well as the expected output please? That way I can be sure whatever I give you is exactly what you’re looking for
Hi Adam,
See attached screen, i need it it to calculate a running MTD figure…once i have that i can then create a formula to work out the variance as we travel through the month.
Column D is what i need to solve which is a running tally of column C.

Cheers
Hi Adam,
See attached screen, i need it it to calculate a running MTD figure…once i have that i can then create a formula to work out the variance as we travel through the month.
Column D is what i need to solve which is a running tally of column C.

Cheers
Hi Sam, thanks for the example. I’m assuming that “month to date” is reset every month. I’ve updated the base linked previously with a solution that should work for your purposes of getting the data in column D, and is powered by the automation “Create links every day”
How it works:
At 12 am every day, it will run and do the following:
- Look in the
Consolidated
table for the record which has the value Yes
in the field Is Today?
to find the record we need to update
- Look in the
Raw Data
table for records which have the value Yes
in the field This Month?
to identify records with dates for the current month
- Paste the record IDs from Step 2 into a linked field of the record from Step 1. Note that this is a different linked field from the one we created previously.
This will enable us to do a rollup that gets the total for the month that’s correct to that day.
Let me know if you have any questions
Raw data:

Consolidated:
