[5e Community] macro fusing spell with attack

So I have this problem... I'm looking for a way to properly cast my Lightning Arrow. it has two parts, first is a arrow shot and then spell splash... I tried to write whole macro by myself, but it doesn't seem to work... then i've tought that i can put lightning arrow in a ranged attack and lightning splash in spell list and then make a simpler macro that uses arrow and splash at the same time!... and... yeah... I've found a way to cast ranged attack using %{chara|RangedAttack2}, but I can't find macro that casts like fourth spell in 3rd level list... is there a macro for that or should i write spell template below chara ranged attack? or is there a way to put all of this in one macro?

Hi, Mastuś . The  Sheet Rolls section of the Roll20 Wiki has instructions for acquiring the Ability call corresponding to a sheet roll button. In this case, the sheet roll button part of a Repeating Section —when you acquire the Ability call, it will contain that button's unique RowID (which is associated with a particular spell, regardless of whether its position within the section is altered).

The fourth spell in the 3rd level list would be %{chara|repeating_spellbooklevel3_$3_SpellCast} The first spell is $0 so the fourth is $3 Happy Gaming

thanks for replies, it works fine now :D