Auto-populate tax depending on another dropdown field selection?
I'm wondering if it's possible to tell Ninox to apply tax based on my 'job type' dropdown field? For example, if I pick 'shipping' that would be taxable, but 'design' (as a service) isn't taxable in my case. Attached is a screen shot to help visualize.
Even better if I could have it default to 10.1%, then if I need to change it I could.
There are various methods you could use for this, the option i'd look into is using a switch case
'Tax rate' := switch 'job type' do case 1: 10 case 2: 20 default: 10.1 end
Put a script like this in your update trigger in job type, and fill in your tax values for each case it needs to be different, and then your default can be 10.1 for ones not needing anything else specific
- 10 days agoLast active