ContributionsMost RecentMost LikesSolutionsRe: Hands On Integration Training Thank you. Unfortunately, I am in this alone at this point. I have a builder account and am learning from doing things there but, otherwise, I am on the market for work. I have submitted a couple of inquiries to Sharon and am waiting on a response. Her price point is what turned me away in the past but, I will see what she responds with as far as a direction is concerned and go from there. Re: Hands On Integration Training Thanks for the suggestion. I forgot about QuickBase Junkie. I watched some videos on YouTube some time ago that I thought were good. I will add that to the list of things I look into / sign up for. I just signed up to look at an API course on Coursera, and have taken some JavaScript courses via LinkedIn Learning. It would just be nice to have something more specific to or centered around QuickBase so, again, your suggestion is much appreciated. I am still open to others, should you or anyone else have any. I love to learn. I just prefer to know I am learning something I will use sooner than later. Re: Hands On Integration Training Anything, honestly. I just want to understand more in depth how to go about figuring out how to integrate QuickBase with other applications, and I know the methodology will vary with the application(s) in question. There are small yet critical details that I don't understand. For example, when a URL is needed for the integration, how do I figure out where to get the URL from? I understand SQL can be used with QuickBase. I assume this would be SQL in an outside application sending or retrieving data from your designated QuickBase application. Either way, how does that work? JavaScript can do a lot from the code pages but, again, that appears to involve URLs for the designated application. Many job descriptions are generic when they indicate wanting you to have experience integrating QuickBase with other applications. They likely just reference desired skills and languages like Python, SQL, JavaScript, JSON, REST, etc. Except for Python, I have done some research into these but, I still get left with the same questions. Hands On Integration Training Hello, Are there any suggestions for training (be it online or in person) where you can get some hands on experience with integrating a QuickBase app with other software applications? I constantly see references and online discussions about the concept of doing this but, I have yet to actually see anything like a practice module or something to follow along with. I see a lot of job opportunities where they want you to know how to do this stuff but, I have yet to have any experience with it. I, also, don't fully understand things like where to find the URL from the software that you want to use with REST, etc. The examples I have seen give you the exact URL for the use case but, don't explain the concept of how to get the URL. In the past, I asked a similar question and was just told things like, "learn JavaScript". That is too broad of a suggestion. I see platforms like Coursera that give you projects to complete to go with your education. It would be nice if QuickBase offered such things. Any input would be greatly appreciated. Oh, and I have the Builder, Expert Builder, and Pipelines certifications. I still feel in the dark about integrations though. James Re: Merging Two Completely Different Tables I don't understand why Pipelines are not an option. The data is in QB tables, though. I know code pages would be needed for the JS approach. Sounds like code page it is. Thank you for your input. I have been wanting to get some hands on experience with using the API calls in a code page. Time to do some learning. Re: Merging Two Completely Different Tables Unfortunately, Pipelines are off the table, otherwise, I believe I would be good to go. I don't have any background on the periods but they are not consistent. Period1 is for 1 month, then the next period is the rest of the year, then the next 2 periods cover a year each, but then the next two periods each cover half a year (6 whole months). Definitely complicated but, turns out the output just has to have the designated details but does not need to look exactly like that. The only thing I can think of is try to use JavaScript to loop through the records and generate everything but, I am not that skilled with it yet. I would love some suggestions, if you have any. Re: Merging Two Completely Different Tables In your example, is there a way to auto populate all of the related projects and then populate the related periods for each project, or does that have to be done manually? Re: Merging Two Completely Different Tables Here's a sample output to reflect where I am trying to ultimately get to: Name1 -- Before Period1 -- StartDate -- Period1 BeginDate-1 -- Amount Name1 -- Period1 -- BeginDate -- EndDate -- Amount Name1 -- Period2 -- BeginDate -- FinishDate -- Amount Name2 -- Period3 -- BeginDate -- FinishDate -- Amount Name3 -- Period7 -- BeginDate -- EndDate -- Amount Name3 -- After Period 7 -- Period7 EndDate+1 -- FinishDate -- Amount Again, StartDate and FinishDate are table1 dates, while BeginDate and EndDate are table2 dates. Re: Merging Two Completely Different Tables Thanks for responding. The 1st table shows a total amount accumulated over the start and finish date for that record. The 2nd table shows periods of time that the accumulated amounts may or may not correspond to. I want to show that Name1 has amounts accumulated before period1 started as well as some accumulated during period1, etc. I realized after I made this post that my current idea doesn't account for overlaps before the first period begins or after the last period ends. My example output is what I am going for as a result of putting the data together. Merging Two Completely Different Tables Greetings, I couldn't delete this post so, I am just completely modifying it, for anyone who navigated their way back to this and is thinking, "This isn't what I was looking for". lol I have two tables with completely different data. I want to create a third table which would be made up of the contents of each record in table1, duplicated for each record in table2, so I can add additional formulas, etc for a report. table1 structure Name -- StartDate -- FinishDate -- Amount table2 structure Period -- BeginDate -- EndDate Desired merger Name -- StartDate -- FinishDate -- Amount -- Period -- BeginDate -- EndDate --... Example output Name1 -- StartDate -- FinishDate -- Amount -- Period1 -- BeginDate -- EndDate --... Name1 -- StartDate -- FinishDate -- Amount -- Period2 -- BeginDate -- EndDate --... Name1 -- StartDate -- FinishDate -- Amount -- Period3 -- BeginDate -- EndDate --... Name2 -- StartDate -- FinishDate -- Amount -- Period1 -- BeginDate -- EndDate --... Name2 -- StartDate -- FinishDate -- Amount -- Period2 -- BeginDate -- EndDate --... Name2 -- StartDate -- FinishDate -- Amount -- Period3 -- BeginDate -- EndDate --... etc... The true challenge with this is being able to set this up so the merger of the data in this fashion happens dynamically. Meaning when one or both tables has a record added, modified, or removed, the merged output reflects the changes. I figure this calls for a relationship, especially for the dynamic aspect of things. However, I don't know how to set that up, assuming it's possible to do. If anyone has any suggestions, that would be greatly appreciated. Thank you in advance.