MarkShnier__You
Qrew LegendJoined 6 years ago
User Profile
Qrew Legend
User Widgets
Contributions
Re: Unduplicated people summary report
I have not tested, but try changing the summarize what setup to be [people name], and use the summary method to be Distinct Count. Please post back and let me know if that works. https://helpv2.quickbase.com/hc/en-us/articles/4570321780372-Create-a-summary-field10Views1like0CommentsRe: Help with searches...
np, just make a formula field of type formula multi select. use a syntax like this. Formula Multi Select Text Split(List(";", If([Chocolate], "Chocolate"), If([Vanilla], "Vanilla"), If([Strawberry], "Strawberry"))) Then include that field as a Dynamic Filter on the report configuration. It will offer up a drop down list of all your states.22Views0likes0CommentsRe: Bulk upsert field limit in pipeline
np, In regular Quickbase go to any table home page or field list and look for import export. Then select import from another table. Go to select the app, but caveat! Your browser will probably block the pop up , so acknowledge that in the browser URL and select always allow popups from Quickbase. Then select your app and the source table. Then do the field mapping and filtering. Save and note the id# from the URL it will be #10 as it will be the first one for that table. Then compose the URL like my example including the xxxxxxxx for the the table id. Then in the pipeline you will just have one step as this will be a scheduled pipeline. Just look in Quickbase steps for the Make request step. Put in the URL and select Method = Post. Feel free to post back if you get stuck anywhere16Views0likes2CommentsRe: Bulk upsert field limit in pipeline
I think I have a way easier way. The only downside I can see is that if the two apps are already completely separate then this will cause them to be in the the same Quickbase server instance which can affect performance if you have a lot of concurrent users. You can create a saved Table to Table import. Then simply have a pipeline step to do a Quickbase Make Request step https://mycompany.quickbase.com/db/xxxxxxxx?a=API_RunImport&id=10 Set the Method to POST Replace the 10 with the number of your import from the URL If you get lucky and the field names match, the Saved T2T copy will guess the matching correctly for 400! fields.9Views0likes0CommentsRe: Validate New Drop-Down Options Before Saving
Well, Plan B would be to let them select a drop-down choice of Other and then just have a free form field which would be exposed and required by form rules where they can enter the other choice into. That way you don't clutter your main drop down field with choices that may hardly ever be used.14Views0likes0Comments