Forum Discussion
EvanMartinez
4 years agoQuickbase Staff
Hi Emsegal,
Due to how flexible JavaScript Insertion can be with what can be written there are going to be some use cases we aren't able to replicate but I have done something similar to your use case with a button using our native formula functions.
First thing I did was set my report I used for my general users to not be able to click on the record to edit or view and then I created my own view and edit button fields. Then I used the formula language to display different buttons in each of those fields that opened different forms depending on which status the record was currently in. So if it was a "Short Term Project" for example it would show the button that opened Form 2, and if it was a "Strategic Project" then show the button that opens up Form 5. The advantage here is that it is all in the QB formula language so it is easier to pass on to others and get support from care when changes are needed, etc. If your curious to chat about the method more in depth if you open up a discussion in the forum I'm happy to walk through it more in depth.
Due to how flexible JavaScript Insertion can be with what can be written there are going to be some use cases we aren't able to replicate but I have done something similar to your use case with a button using our native formula functions.
First thing I did was set my report I used for my general users to not be able to click on the record to edit or view and then I created my own view and edit button fields. Then I used the formula language to display different buttons in each of those fields that opened different forms depending on which status the record was currently in. So if it was a "Short Term Project" for example it would show the button that opened Form 2, and if it was a "Strategic Project" then show the button that opens up Form 5. The advantage here is that it is all in the QB formula language so it is easier to pass on to others and get support from care when changes are needed, etc. If your curious to chat about the method more in depth if you open up a discussion in the forum I'm happy to walk through it more in depth.