Katlyn, I think that this can be done, but it might take some one on one consulting time to get this working.
Part of the solution might be the technique here
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=8d321e15-bd9a-4f49-b4c9-e89822b6677f&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fcommunities%2fallrecentposts------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------