Forum Discussion
UPDATE:
I van now create multiple records using the bulk upsert method, however the search query doesn't seem to be working correctly because the [Related Plant Tags] that get added to the join are 1) not the correct tags and 2) the number of records created not correct.
In the screenshot below you can see that my [Starting Tag] is 178605 and and my [Ending Tag] = 178610. This should a total of 6 records (tags 178605 through 178606). However, 7 records are created and the tag numbers are not correct.
Also, to get this to work I had to use the "OR" operator instead of "AND". If I use "AND" no records are created. If I use OR I get the issue described above. It is probably also pertinent to note that when I try other tag numbers the number of records created are all over the place. Sometimes 25 records are created, sometimes 41, and other times 7 (as seen in the screenshot). I'm sure I'm missing something basic here but can't for the life of me figure it out.
------------------------------
Matt S
------------------------------
Looks like I figured it out!! Either one of the following seems to work (they are the same thing just written as a normal query and as an advanced). Seems I had my logic turned around.
If you think there is a better and/or more optimized way to do this I'm all ears, but this seems to work.
@Mark Thanks for your help/input. Greatly Appreciated! Your solutions on other threads have been very valuable to me as well!
------------------------------
Matt S
------------------------------
- MarkShnier__You2 years agoQrew Champion
I don't really understand why you would need both an Advanced Query and a regular filter, but if its working, great!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- MattS2 years agoQrew Member
You're right, I don't need both. My understanding is that you can only do one or the other. I posted both ways of doing it in case some beginner like me has a similar issue/question and stumbles upon this post in the future.
Thank again for your time and help!
------------------------------
Matt S
------------------------------