PLS - profile

PLS · Mar 25, 2024

I'm new, so apologies for any blatant errors. I'm trying to create a SKU in the table primary field using the SWITCH function based on other fields in the table. My initial try included a lengthy list of colors (all unique) and the 5-letter results (...

PLS · Mar 28, 2024

Thanks for this info. I'll definitely use it for future questions. I appreciate everyone's help!

PLS · Mar 28, 2024

It worked!!! Thank you! I assumed I needed a field reference for Autonumber just like the others. Any idea why it isn't required when the others are?

PLS · Mar 26, 2024

It does sound strange, I admit. It's actually a table for blank apparel and items we sublimate designs onto for sale (mostly t-shirts), and the 17 characters are brand (4 letters) and model number (5 letters/numbers), type of apparel or item (3 lette...

PLS · Mar 26, 2024

Thank you for the responses. I tried the Color Code lookup suggestion, no joy. No, Product type isn't a lookup, it's a link to the primary key field of another table, as are several of the other references. Only Color Code is a lookup field (with the...

PLS · Mar 25, 2024

I should have also said, the formula originally worked without the Color reference, so I think that must be the problem area, although I now get an error even when I delete the Color section. Hence, my complete confusion.

User Statistics

User Activity

Help! SWITCH formula not working

Re: Help! SWITCH formula not working

Re: Help! SWITCH formula not working

Re: Help! SWITCH formula not working

Re: Help! SWITCH formula not working

Re: Help! SWITCH formula not working