Reading an external JSON file into a Chief Architect schedule with a Ruby text macro

[SHCanada2]

2 hours ago, BradAtHarmony said:

I've also moved to real Chief schedules. One note per member, over-provisioned, cropped with the layout box edge — your video. Thank you for posting it; it solved the blank-row problem I'd given up on.

did the "group similar rows" not work to get rid of the same null blank rows in the schedule

[BradAtHarmony]

4 minutes ago, SHCanada2 said:

did the "group similar rows" not work to get rid of the same null blank rows in the schedule

Jason - it does the opposite here, and I spent an hour figuring it out.

Chief groups on the note object's own properties, not on what the macros render. Every note in these schedules is identical as an object: same note type, same Macro Input strings. The thing that makes row 3 differ from row 4 is %schedule_number%, which isn't resolved until the row is drawn.

So with Group Similar Objects checked, all 31 notes collapse into a single row with Qty 31 - not 24 populated rows plus one blank. I had exactly that on screen and couldn't work out why duplicating a note wasn't adding rows. Unchecking it is what makes the schedule iterate at all.

Which leaves the overshoot to deal with some other way, hence the layout box crop.

[Joe_Carrick]

FWIW, using macros in Chief (particularly in Schedules) requires some very careful consideration of the source data.  Macros that may work for an Object may not work for inclusion in a Schedule that includes that Object.

 

I encountered that problem when creating my "Braced Wall Lines & Panels" system.  I had to completely revamp my approach.

 

One thing you could try is opening and closing the Schedule.  The rows might update when you do that.

[SHCanada2]

16 hours ago, BradAtHarmony said:

Chief groups on the note object's own properties, not on what the macros render

hmm i was wondering that before I wrote it but I had checked mine that has two fields and they are both macros, and it works,  but they come from rooms not notes...maybe its something along the lines of what joe said...interesting