khultquist Red Ribbon

can you get a time in milliseconds and use that as a seed for a random number?

hmmm, can you change it to an html field (without losing the data)? Then you could just modify the value to be <b> or <font color=red> through a really simple formula or script

It's a pretty good idea, you can do something like that with a saved search and script. Something like this: field change: customer run saved search in script, with a filter of customer return results to a custom text area

Right, I meant skip the RAND altogether and make your own random function

Yes. The html file needs a real http address or relative path, and you can see in the "core" address that the folder structure isn't there.

try using the full paths to your scripts and css, I dont think the relative paths will work.

something like this (I didn't test it), and then make sure you set the field change to trigger no_spaces... or even better is to check which field changed in another function, and if it was your custom field then call the function no_spaces. function no_spaces() { var…

I would do it as client script, fired on field change, and check for a space with indexOf.

Is she creating the invoice from another transaction (such as Sales Order)? If so, you have to link the invoice form to the other transaction form.

Are you talking about a custom field on the item record, or on the bin record? Either is possible.

I don't know how to modify the bin sublist/list, as it's on a sub-tab. You can move the placement of it on the entry form, but I don't see where to modify what fields are shown. But I think you could add a custom sublist that duplicates the Bin Numbers list, and then show whatever fields you want.

Thanks tbuffington, I got everything to work. I use ODBC to generate some complex reports. Having a multiple-select field adds a new mapping table, which handles the many-to-many.

Kind of... if I understand sourcing, you either get [LIST] [*]a dynamic value -- when 'Store Value' is unchecked [*]a static value from record creation -- when 'Store Value' is checked [/LIST] For the dynamic value, you can't use Global Search. And for the static value, it won't update.

How does the validation/default work? If you change the source field, does it update the searched field?

Thanks, it looks like that will work! I have to test it a little bit more, and will post results.

I got this to work without too much effort. I created a custom item field called 'Search Description', with id 'custitem_search_description' and placed it on the item form. I tried to have it hidden or in-line but it wouldn't work, so I placed it in an inconspicuous place. The new field has 'Global Search' checked. Then I…

I'm going to try this with a user event script that updates the value when the record is saved. When it's working I'll post the code & instructions.

JCirocco - did you attempt it? If so, do you have details/advice on the best way to do it, ie copy the field with user event or client script? I was thinking about doing it for item descriptions, so I could type in 'Motor' and get a list of all my motor items.

You can run multiple web queries in one excel workbook, one query per sheet, and then consolidate your data onto a summary sheet. I've got a similar workbook with queries and ODBC, and it works great other than it's a little slow to refresh the data. You could also use an automated screen scrape tool that emails a pdf of…

On second thought I don't think this will work, a button won't trigger a field change. You've got hard coded scripting built into the button. All that scripting should go into a function that gets called from the button action, and then add your alerts to the function.

NS has functions that would work for removing the KG out of the field and changing to a number, try these SUBSTR(char, position [, substring_length ]) REPLACE(char, search_string [, replacement_string ]) TO_NUMBER()

Are you emailing from NS? If so, you can use the built in messages record that contains a date field.

Hi Cloud - you have too many { and not enough }. Also, what is 'field'? I think your code should be something like this, but a better solution is probably an alert via emailed saved search, that alerts the current user and anyone else that you want cc'd. function FieldChanged(type, name) { if (name ==…

I would try the whole thing thru a saved search, with email alert on changes.

One way would be to have the custom field be a formula, equal to the built in field.

Thanks for the tip!

I think you need to add "when" CASE when {custitemcustitem_item_weight} <= '50' THEN '£3.50' ELSE '£35.00' END

Hey Sam - Jeff is on the right track for starting a project like this. Create a saved, scheduled search that looks for sales orders with a renewal date of 1 month from today. Have it email the results to the proper person (maybe the sales rep on the sales order record). This doesn't automatically create the new…

Just a thought... you could you set up a very simple preferred form: only the customer field on the form. Then the form changes based on script, to either standard form or special form. No chance of loosing data, you have to enter the customer first.

One thing I've found in formulas is that blanks or nulls can cause it to crash. You might try something like CASE when {custitem_bb1_reservedavailable} is null THEN 0 ELSE {custitem_bb1_reservedavailable} END + CASE when {quantityavailable} is null THEN 0 ELSE {quantityavailable} END