Best way to convey that one search criterion depends on another (or doesn’t)

I am creating a very basic screen in a desktop app that shows a customer service representative a customer’s order history. As of now, there are 4 criteria by which you can search:

  1. By order No.
  2. By product No/product description
  3. By date
  4. By Order type (e.g., cancelled orders, dispatched orders, fully paid orders, etc)

A user can search by any number of these criteria at once.

So far, simple, but there are two things that are causing me a lot of trouble.

  1. If you choose to search by Order type, then, you must also choose a date range, as the system is unable to return all orders of a type, only orders of that type within a date range.

  2. If you choose to search by order no, then all of the other search fields should be ignored (if they have anything in them). I.e., the order no search field is independent of the others.

How can I convey this to the user?

So far, I have come up with this:

----------------------------Search---------------------------------- Order No[       ][Search!]       Product No [          ]                                  Order type [          ]                                  Date       [          ]                                          [Search!] 

To solve 2, I placed the order no field far away from the other fields to convey its independence of them. But this looks ugly, and I don’t even know if it conveys independence.

To solve 1, I auto-fill the date field if the user selects an option from the order type field. But I have doubts about this, as the user may not understand why the date field has suddenly been populated, and may get frustrated when they try to clear it but can’t.

I’ve been pulling my hair out for 2 days over this. I’m just a programmer who has been given the responsibility of designing and implementing every aspect of this new large application. I have no UX or UI experience or knowledge.

Including a specific ‘Home’ link when a sites ‘Home’ is equivalent to another function

I am designing a blog site where the Home page is a list of blog posts.

In this situation is there any research into the validity of using a Home navigation link which takes you to the list of blog posts and not including a Blog navigation item?

I think this would be acceptable as if the user is on the Home page they can see what it contains and if they have navigated to a post, they know Home will take them back to where they came from and hopefully have remembered that Home contains a list of posts. But keen to see if there is any contrary research.

Alternatives I’m considering are to not include a specific Home link and just use Blog (using a logo to return to Home) but I’d be concerned that this doesn’t indicate strongly enough how to go-home unless the logo looks stylistically like a button.

Steve Krug is keen to use the Site ID as a return to Home link, which is fair, but also recommends (but doesn’t insist) on having a Home link in the navigation. I see Facebook do include a home link on the main nav and this links to news feed on the left navigation. Amazon, don’t seem to include a home link anymore.

Or finally to include both a Home and Blog link, but I don’t like the duplication as I think it can cause confusion if a user from the Home page clicks Blog and see’s the same content. Also, I can only indicate one active page, so having two links seems the wrong approach.

Autofill a cell in a list if another cell in the same list contains a certain text value

I want a cell in a SP list to automatically populate/fill-in if a certain text value is present in a column in the same list. For example the list contains two columns named: Route of Flight and Spare Parts.

The Route of Flight column is filled in by the planner with a string of text, e.g. KOKC-KLIT-KDFW-KOKC. If the Route of Flight column contains KDFW then I want the Spare Parts column to auto-populate with “NEEDED”. If the route of flight does not contain KDFW then the Spare Parts column should auto-populate with “NOT NEEDED”.

Thanks.

Is it confusing to link to another section of a site for more info?

I want to create a portfolio site for my team. I have two goals: 1. Create a section to showcase our projects 2. Have a blog where we can provide updates and talk about the “behind the scenes” of our projects.

Here is my question:
If someone lands in the project section and sees a project, would it be confusing to also have articles in the blog talking about the same project? Is that redundant? Would a user expect to see ALL information for a project in one place?

Or…am I doing too much with the blog? Should blogs on sites like this be reserved for updates only?

Copy List Views to Another independent existing list SharePoint2013

I have a dozen Lists, each independent. Each houses the same columns, titles, etc. But, the data within each list is unique to that list; one list for apples. Another list for oranges, etc. I need to make a VIEW for EACH list that is identical in terms of the columns displayed in some given order. For example, the Apple list will always show Quantity, price, location, vendor, etc. Same columns as the Orange list will show on its page. Can I make a view in Apples that dictates what columns display in what order and just copy that view into my other lists? This is not a templating issue… the lists already exist with independent data.

Copy List Views to Another independent existing list SharePoint2013

I have a dozen Lists, each independent. Each houses the same columns, titles, etc. But, the data within each list is unique to that list; one list for apples. Another list for oranges, etc. I need to make a VIEW for EACH list that is identical in terms of the columns displayed in some given order. For example, the Apple list will always show Quantity, price, location, vendor, etc. Same columns as the Orange list will show on its page. Can I make a view in Apples that dictates what columns display in what order and just copy that view into my other lists? This is not a templating issue… the lists already exist with independent data.

Copy List Views to Another independent existing list SharePoint2013

I have a dozen Lists, each independent. Each houses the same columns, titles, etc. But, the data within each list is unique to that list; one list for apples. Another list for oranges, etc. I need to make a VIEW for EACH list that is identical in terms of the columns displayed in some given order. For example, the Apple list will always show Quantity, price, location, vendor, etc. Same columns as the Orange list will show on its page. Can I make a view in Apples that dictates what columns display in what order and just copy that view into my other lists? This is not a templating issue… the lists already exist with independent data.

Copy List Views to Another independent existing list SharePoint2013

I have a dozen Lists, each independent. Each houses the same columns, titles, etc. But, the data within each list is unique to that list; one list for apples. Another list for oranges, etc. I need to make a VIEW for EACH list that is identical in terms of the columns displayed in some given order. For example, the Apple list will always show Quantity, price, location, vendor, etc. Same columns as the Orange list will show on its page. Can I make a view in Apples that dictates what columns display in what order and just copy that view into my other lists? This is not a templating issue… the lists already exist with independent data.

Postgresql – search one array element with another

I have got tables

children_tab id name lastname  parent_tab id name lastname  children_parent_tab children_id parent_id 

There is also parent view that return in field children_ids elements from children_parent_tab

I have to search parents by children ids

Let’s say that parent contain

1|name1|lastname1|{1} 2|name2|lastname2|{5} 3|name3|lastname3|{3,7}  SELECT * FROM parent p WHERE ARRAY[1,2,3,4,5]::int[]  @> children_ids 

will return only parent with id 1 and 2 but without that one with id 3. How that query can be changed to return also parent with id 3 because I’m looking for parent of child with id 3?

Thanks for advice