So the column is Date_received and I want to pull the all the ones that haven't had the date received added as =isnull. Is this right way of doing this or do I need add more to it?
What type of field is to hold the Products you have not received yet? How are you with deluge as I expect it will be a coded solution not a workflow action
This is for a button on the dashboard, and the bosses want it so if you click on it I will open the report and show all the items that haven't been ordered.
So you are opening a Report/View not a Form so chnage the button to open a Report not a form, choose the report you want to show and then add the query paramters.
Option: Build a report that is already queried on the not received products and just open that from the button then you do not need to add query parameters
So you are opening a Report/View not a Form so change the button to open a Report not a form, choose the report you want to show and then add the query parameter.
This what I was looking at doing, just wanted to know the query parameters was ok and I didn't need something like
// Fetch records where date_received is null
criteria = "date_received == null";
records = zoho.creator.getAllRecords("xxxxxxxx", "xxxxxxxxxx", criteria);
Just an FYI, you don't need to use the integration task in Creator to fetch records as we have direct access. Instead you can use the fetch records task for this which will allow you to use criteria to only fetch the desired record set, see: https://www.zoho.com/deluge/help/fetch-records/fetch-collection-records.html