Forum Discussion
ChayceDuncan2
6 years agoQrew Cadet
You can write JS into a formula-url using the following syntax:
javascript: {
//enter your code here
}
If you're trying to do a doQueryCount - you'll have to do a couple things
1) Easiest method is to do a GET against your table using doQuery Count
2) Parse the XML response to get the count
3) Do another GET - this time an EditRecord call to store that value somewhere. So logging it as a record somewhere - or editing a field with the current count - your choice
So like:
javascript: {
$.get(' url for doQueryCount ',function(data) {
//parse the response
$.get(' editRecord ')
})
}
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
javascript: {
//enter your code here
}
If you're trying to do a doQueryCount - you'll have to do a couple things
1) Easiest method is to do a GET against your table using doQuery Count
2) Parse the XML response to get the count
3) Do another GET - this time an EditRecord call to store that value somewhere. So logging it as a record somewhere - or editing a field with the current count - your choice
So like:
javascript: {
$.get(' url for doQueryCount ',function(data) {
//parse the response
$.get(' editRecord ')
})
}
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base