Question

Frank Lora

So I have a table called plans which has a starting and ending date and a list of subjects. When the user creates a plan, a bunch of "Entries" are created that relate to that Plan. Subjects are added to every day that's selected, thereby creating an "entry" to that plan. 

How can I automatically create entries based on the starting and end date? 

I'd be happy to show the data structure I have.

Ray Deck

So you have a second table called, say, "entries" that you want to populate with one record per date in the plan? (So a plan of 4/1/22 - 4/30/22 would generate 30 records in "Entries")?

Frank Lora

Correct. But it would also generate one entry per subject. So if you have 3 subjects and a plan of 4/1/22 - 4/30/22, it'll then generate 90 entries that are related to that plan.

Frank Lora

Bump!

Ray Deck

I made a short video walking through this process - let me know if it helps? https://www.loom.com/share/5127d5d5989641cc8c793b6927f06b85

Frank Lora

Whoa, i think that's exactly what I was looking for. I'll look to implement this today or in the next couple of days and I'll follow up with you! Thanks for taking the time to help me out. 

Question: do you offer any xano services?