Welcome to Portal

?Unknown\pull-down

Welcome to Zoho Cares

Bienvenido a Soporte de Zoho

Search our knowledge base, ask the community or submit a request.


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?

1 user has this question.
9 Replies
Reply

Anyone that can help?

  • Zoho MVP
  • 10 days ago

I think we need more info.

Do you mean Form rather than a view?
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.

  • Zoho MVP
  • 10 days ago

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);

for each record in records
{
    info record;
}

  • Zoho MVP
  • 10 days ago

No you should be good

  • Zoho MVP
  • 9 days ago

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

Yeah I just want to use the button on the dash board to trigger the fetching of the records
This is what I have put but its not working, I know there is one record that should show up.


  • Zoho MVP
  • 9 days ago

Try remove the semi-colon after the "null".

Reply to peter.fraserA
/* */
  • 12
  • Insert
  • Plain text
Add Comment
(Up to 20 MB )