PrashantMaheshw
Qrew Captain
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Commissions table
QuickBase formula are quite robust and are capable of taking quite an abuse :D You can use an excel to list down all the conditions and build 1 single giant formula. Your current idea of using dropdown in 1 single field should work fine. It will goes like If ( [Location] = "X" and [Supervisor] = "Mr. A" and ["Manager"] = "Uno" and [Product] = "12", 1.24%*[Sales Commission], [Location] = "X" and [Supervisor] = "Mr. B" and ["Manager"] = "Uno" and [Product] = "12", 1.22%*[Sales Commission], [Location] = "X" and [Supervisor] = "Mr. C" and ["Manager"] = "Uno" and [Product] = "12", 1.04%*[Sales Commission]) You can continue to build like above in 1 formula with 50+ combos easily , it's easy to manage and you can make changes . -- Another way would be list down all the combinations in a child table and then doing a parent child relationship to manually select the right combination. If there is a business case to have history of previous commissions or changes , this would be a right approach .Deleting Orphaned Children (records)
Hellos, I have a scenario where I have a table where orphaned children exists , they can be recognised visually from hyperlink (See Screenshot). The question is how to filter for them so they can be deleted in QuickBase . I can do this easily outside of QuickBase but how to do this natively ?Re: Join multi-line text field to one line
line breaks are identified as \n . So you need to use jinja to replace \n with ' '. from QuickBase page Return a copy of the value with all occurrences of a substring replaced with a new one. The first argument is the substring that should be replaced, the second is the replacement string. If the optional third argument count is given, only the first count occurrences are replaced: {{ "Hello\nWorld"|replace("\n", "") }} output: Goodbye World {{ a.myfield | replace('\n', '') }}Re: Convert Excel (once uploaded) to PDF inside QuickBase
there is no inbuilt solution for this as MarkShnier__You recommended. You can consider a pipeline which after the excel is uploaded , sends it to a service with api , a quick google search gives many option but they all become expensive very quickly. upward of $250/monthly providing the user a desktop option to print to pdf , later version of excel support this and upload those, cheapest but users have to be trained ask user to instead upload on office 365 or google sheets, you can then view the same in browser.
