Trouble creating an automation

Topic Labels: Automations Data Formulas
310 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have some base level automations and table links created, but I am now experiencing difficulty creating further links.

Three main tables: Students

Student List.png

Class List

Class List.png

Class Price

Class Price.png

Current links: Students to Class Lists. Class Lists table has hours per class. Based on classes students are put in (in Class Lists), it changes their total hours (in Students). On Students table there is a Roll Up that calculates total hours students are in based upon their Class List. 

Class Price table is connected (vaguely) to Students table, but establishing the correct link to make things work is not happening in my brain. 

I want to, based upon the Roll Up hours in Students table, have students automatically assigned to that specific number in the Class Prices table and/or have the dollar amount assigned to a total hours on the Class Prices table to be placed in the Students table, so it can easily be seen how much they own either monthly or by semester.

So far, I can have it create a completely new record (which I don’t want) in the class price table.

Do I need to create yet another junction table to make this function properly? Or is there some sort of automation step I am missing?

Current automation I’ve been playing with (though it is not actually adding in students to the Class Price table):

Automation 3.pngAutomation 1.pngAutomation 2 results.pngAutomation 2.pngAutomation 3 results.png

1 Reply 1

To work effectively, you should understand how linking works. When you copy and paste value in linked field, it 

  • Search this value in PRIMARY field of linked table
  • first found record will be linked
  • if the value absent, new record will be created with that value, and linked

You can copy-paste whole field, or you can turn existing field to linked.

Note: the search will ignore 'limit selection to a view' and 'allow multiple linked records' settings (multiple will be always allowed).  

I think you should link Classes to Prices by Length column. Then you should add price lookup in 'Classes'.

To be honest, I don't know why do you need automation. And other link fields in 'Prices', as well