Skip to main content

Trouble creating an automation

  • September 19, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img

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

Three main tables: Students

Class List

Class Price

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):

1 reply

Alexey_Gusev
Forum|alt.badge.img+23
  • Brainy
  • 1126 replies
  • September 20, 2023

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


Reply