Auto Numbering unique inventory items by department?

Success!!

I did pull the application dbid by mistake.

Thank you very much for your help and feedback.

I will be sure to post as new questions in the future.

You are probably specifying the application dbid instead of the table id on this line of code:

var dbid = "your dbid here";

I sometimes deviate from my own coding practices to save time. I would adopt the convention of writing the dbid's as follows:

var dbid = "your application dbid";
var dbidTable1 = "your Table1 dbid"
var dbidTable2 = "your Table2 dbid"

Also, it would help if you posted a new question when the thread is so old (a year in this case). It becomes diffiucult to read through the whole thread and parse out what the new issue is. Just concentrate on the unique aspects of your question.

Update: It does actually have the XML response in the console.

This is the errtext I received:

"This operation is only supported on individual tables and not on the application itself. Please check the URL."

Agreed.
After responding, I added some console.log("test"); lines before and after the

console.log($("#_fid_191",xml).text());

statement and it's showing empty row

There is no XML response showing up in your post. The string "'Attr.nodeValue' is deprecated. Please use 'value' instead." is a diagnostic message to the console dealing with some aspect of the code you wrote or is possible the request of QuickBase's code.

(Thank you for such a fast response!)

If I'm debugging correctly this is the response I'm getting:

'Attr.nodeValue' is deprecated. Please use 'value' instead.

Debug your code:

$.when(promise).then(function(xml) {
  console.dirxml(xml);
  console.log($("#_fid_191",xml).text());
  var next_item = $("#_fid_191",xml).text() + 1;
  $("#_fid_310").val("TMJPM-" + next_item);
});

I'm new to AJAX and am having trouble getting this example to work.

What I'm trying to do is base the next number on a numeric item number field (because they don't line up directly with Record ID since we imported much of our data from an existing database).

The field ID containing my item number is 191 so I've made the following changes:

var dbid = "I put our dbid here";
var apptoken = "I put our app token here";

$.ajaxSetup({data: {apptoken: apptoken}});

var promise = $.get(dbid,{
  act: "API_DoQuery",
  clist: "191",
  slist: "191",
  options: "num-1.sortorder-D"
});

$.when(promise).then(function(xml)
{
  var next_item = $("#_fid_191",xml).text() + 1;

  $("#_fid_310").val("TMJPM-" + next_item);
});


All I ever get returned from "next_item", though, is 1

Any help would be greatly appreciated.

Thanks

This code when used in conjunction with the image onload technique will do what you want:

var dbid = "your dbid here";var apptoken = "your apptoken here";
$.ajaxSetup({data: {apptoken: apptoken}});
var promise = $.get(dbid,{ act: "API_DoQuery", clist: "3", slist: "3", options: "num-1.sortorder-D"});
$.when(promise).then(function(xml){ var next_rid = $("record_id_",xml).text() + 1; $("#_fid_8").val($("#_fid_7").val() + "-" + next_rid));});

All I am doing here is performing an AJAX query for the largest [Record ID#] in the table and adding one to it and prefixing it with the [Department Number] value which presumably has been selected and is in the field with fid=7. The calculated inventory number is then pushed into the field with fid=8. Minor modifications might be needed to get this to run in your application using the workflow you require.

Don't screw around with other solutions that modify the problem you need solved. This technique (IOL + script) will solve all QuickBase problems you can formulate.

Very helpful Mark.