Unable to download files.
Hi Guys, I am unable to download the file from the below link https://www.zoho.com/creator/help/script/for-each-record-in-form.html (.ds file) can anyone help me to download this file. Regards Prashanth K
What is Add record in Deluge Task?
Hi Guys.. Can any one tell me, what is "Add Record / Delete Record" -- Deluge Task ? Any real time example... I am newbie , trying to learn these concepts.. Kindly help please Regards Prashanth K
[Solved] Auto Complete <datalist> vs zoho
After searching forum topics for related posts, I still feel i need to start a new topic, especially with HTML5 existing now. I'm working on creating my first couple apps with Creator. Prior to that i just have a couple prototype forms custom made via the Sites app. Since discovering how cool autocomplete within input fields via <datalist> (I use Google Chrome), I just have to have an autocomplete feature for some single line input fields. It definitely seems like I would rather go the route of having
CUSTOM ACTIONS
Hi, Is it able to send mail with record summary ,while clicking custom action button?
Custom Action
I created a custom function called Sign_Up. This function will appear will appear whenever I click on an event on the calendar report. When clicked on the Sign_Up button, it will bring the user to the Events_Sign_Up page for users to register for an event. How can I program such that when the user is brought to the Event_Sign_Up page, the Event_field_name is automatically selected based on the event the user clicked on at the calendar report?
Date & Time Picker - NOW() button
I populate my date and time field with the last date and time from the last record. When the date/time picker shows up I would be nice to be able to click a button that will set it to right now() Kind of like the NOW() function in databases. It could be placed above the time selection fields. Just a suggestion.
Restore the last date the user selected.
I have a form that adds log records. When the form is first opened up I want the date field to default to TODAYS DATE, But if the user changes that date and saves a record I want the date field to default to the LAST DATE they selected. I seem to only be able to do it one way or the other. I can write the code if I knew the form was the first time ONLOAD or after a record was added and its the second time ONLOAD. If that makes sense. Thanks Andy
Passing multiple ID's through a URL to a Lookup Field
I am trying to send a message from the a text field to many custID's. When selecting many users (after applying a filter on a view) I have a custom action that has the following code. void SMS.sendsms(Setup_Customer_Contacts VCustomer) { querystring = ""; for each cust in VCustomer { querystring = querystring + "custID=" + cust.ID + "&"; } openUrl("#Form:SMS_Content?" + querystring, "popup window", "height=200,width=400"); } For the popup window, on "submit" I have the
Returned value of a Function in a Custom Action
Hi! I built a function that performs a calculation on all records of one form and put it in the report header as a custom action. It returns a number from the calculations. Is there any way to display this returned value? Alert cannot be used in viewing a report, so is there any other way to show this value when the custom action is clicked? Or do I have to create a page and put the returned variable there?
How do I verify an email address to be used as the "sender" address in a form?
I´ve seen a previous post which tell me to select "add email address" when in the "from" field....however this option doesn´t seem to be available anymore, please help me!
fetch issue on reports , stuck with my customers and partner.
We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com i'm wait answer from support and 3 days without a solution and 0 communications for paid customer as me is a mesh.. uk number is an infinite loop and chat also is hard to get prompt answer please reply.
Restrict viability by profile
Hi Zoho, It would be great if you can add an option to restrict report visibility by profile and not just by users and roles.
Archiving records
Hi all, Here is the business logic i want to achieve: when an Order Status== Archive, I want to prevent everyone from modifying any field in the record unless the user is a certain Role or Profile. I know i can write the code in OnEdit and OnAdd to disable each and every field. But this becomes a maintenance burden in the long run because I need to remember to update them when I add a new field. I have Enterprise edition, so Role and Profiel are available to me. Is it possible to achieve what I
Remove chat bar from all applications
For account sigroup, this chat bar is on every app. Please remove it as we already have a corporate chat solution. Cheers, John Whitney
Sharing needed for submit by email
When submitting by email what sharing is needed? Does the form need to be shared to the email address submitting the data. Is there a public option allowing any sender to submit data? Does the associated report also need to be shared? Can it be shared with a Customer Portal account? Is the sharing done by Application Settings->Share or are there other settings needed?
Lookup filter not refreshing on submit
Hi As part of my training management software I've created, I use a form to complete Active courses. The form contains a lookup for all courses that have 'Active = true'. The form works fine until I click submit and the course is then set to 'Active = false'. The form clears/resets but when I select the lookup, it still contains the record that I've just completed. If I refresh the page, the lookup then works properly and this record no longer appears. Is this a flaw with the system or am I doing
zoho creator sync to on premise sql server
I am sure the answer is in here somewhere.... I just turned on zoho for the first time, as we are looking for a tool to display some subsets of data from our ERP system (sql back end, on premise). Is there a tool in Zoho to allow sync'ing to on premise databases? I am the finance guy, not the programming guy so something wizard based is more beneficial for me. Thank you Ken
Summary View Help
Hello again, I'm looking for some help creating a summary view. I know how to do it, I just can't get my head around the table and how to display the data that I require. My ultimate aim is to have a list of employees and when I click on one, it shows a summary of all training sessions that that person has attended. I have two tables: Employee & Training Course When a training course is 'booked' it chooses an employee from a lookup in the form. The tables are therefore linked. When i create a
Simple Function for Custom Action request
I'm trying to improve the workflow for my company by limiting clicks to update records. I'd like to have a simple Custom Action button that updates one of the fields of the specific records. The goal is that when in the report view to click a custom action button labeled "closed" to change the "status" field from "open" or "scheduled" to "closed" inside of that record. I'm sure I'm missing something silly, but I appreciate any help.
Filter a lookup in a subform with a field in the main form
Hello, i have a Main Form with a Text field. Under i have a subform with a lookup on another form. How can i create a filter on the lookup with MyLookup.MysubField CONTAINS Mainform.TextField ? is it possible ? thanks you
How to show only hours and minutes of a date-time field in an alert box
Hello, I have a form with a date-time field. When I click the 'Preview Mode' (see the image), an alert box loads a preview mode of a submit view As you can see when I have in the time field the format 'hh:mm:ss' it works fine But when I change it to "hh:mm" then it shows me "00:00:00" Image 2 The deluge which I am using in order to load this value is input.Date_Time.toTime() Is there any way to solve this issue?
Trying to "Open in new tab" the "Edit this application" button gets to error
Hi Zoho, After the last update, when I right- click on the "Edit this application" icon on page, and choose "Open in new tab", the new tab open to "about:blank" instead of the Zoho Creator system... Thanks! Ravid
Form validation for a lookup field
I'm trying to write deluge validation to check a multi-select lookup field for selections made by the user before the record is added or edited. I've wrote scripts for the On Add and On Edit form actions of the Submit button, but I'm not having success and get an error mentioning the mismatch in my expression (field type is BIGINTLIST on left, but String on right). I guess I'm using the incorrect operator ==. I also tried doing a count of the list, but wasn't successful there either. The number of
sub table
Can this be achieved with Zoho Creator? One table inside another, each one are different parameters.
Users relationship between Creator and AppCreator
I have an application I'm building for a client, there is a back-office administration web application built in Creator and then a mobile app built in AppCreator where field agents collect & view data stored in Creator. I want to store the user who added the record in Creator but the field agents won't have access to the backoffice application. Both Creator and AppCreator have the option to invite users but do I have to invite from both? I'm concerned about the logisitics of having to invite users
AppCreator Subforum? Form changes in ZC propagate to AC?
Will changes in forms in ZC automatically propagate to AC or how will this be handled? Does conditional formatting created for ZC reports work in AC?app Can you create subforum for AC?
How can I set report criteria for each login user?
Hi, We have multiple contractors and we want to show report data related for them only and don't want them to see other contractors rows. Some contractors have multiple users so we can't use criteria something like [userid == zoho.loginuserid]. I need to fetch company name from user table. Getting company info from userid is easy with a function like get_companyid(zoho.loginuserid). But I got error when I try to use function in report criteria like [company_id = get_companyid(zoho.loginuserid)]
Dashboard: code reuse doesn't work?
I tried to reuse the HTML code of the "Sales Management" application in my own application. I'm particularly interested in the style that you use to create the little tiles in the dashboard, e.g. "My This Months' Sales". Can you help?
Paypal Transaction Cancelled
I have observed if you cancel a paypal transaction, form data still appears in my view. How do you verify if a paypal transaction is canceled? I tried to use input.ZC_Payment.payment_id = null in form validation, but that does not work. Cheers, John Whitney
Getting Form Reports / Submissions into Box.com?
OK so I need to collect many forms for various reasons - so each ZC form submission equals one form for me. I need to store these documents in Box.com. Box allows upload of files via URL or email attachment in addition to manual uploads. If I create forms in ZC - what is the easiest way to have these files uploaded to Box? Can the notification email on submission include a pdf file that gets emailed to Box? Can I bulk export multiple form entries to separate PDFs for upload to Box? Any marketplace
Html checkbox sync with embeded from?
Hi Zoho, I have an html page with a long table, based on a one form (1 row = 1 entry). I'd like to have the option to make several rows, and than edit multiple entries together. ~~ I cannot embed a report in the html, due to several reasons ~~ I thought about creating a checkbox for each row, than sending the list of IDs based on the rows checked to a form embeded in the html page, and sending the form will update the entries based on the ID. Since I only started to code with Zoho, I need help with
query expression question
Hi all, How can I get all Orders which have been modified in the last 3 months? I tried the following but got the error "Not able to find monthsBetween function". for each o in New_Order [(Grand_Total != 0.0) && monthsBetween(Modified_Time, now) < 3]
Zoho button to create new auto-populated form
So in my application dashboard, I have created 2 Forms. One is a Quote Sheet and the other is a Customer Sheet. I want to be able to configure the submit button on the Quote sheet so that "On Edit" it will be a "Make New Customer". I want the action to pull up the Customer Sheet and auto-populate from certain fields of the Quote Sheet. Is this possible in Zoho and if so, how can go about doing this?
Populate Lookup Field
I have a form which is filled out by email - it is a Twilio SMS response. I would like to link the form's From field (single line text or number; either works) with a lookup field which contains a list of mobile phone numbers from my Worker Information form. The phone number from the From field will not be an exact match as Twilio responds with "+1 NPA NXX xxxx and I only store NPA NXX xxxx. The goal is to ultimately fill in other fields based on the Worker Information Lookup so I can generate further
what is the field type for "Drop down Box
Hi...Guys.. By using "Drop down Box" field and the values in the field are "Numbers" , then Is it possible to perform "Calculation - Task" or If I put it another way , what is the field type for "Drop down Box" ?? Here, Scenario, Live Form Window is Guest Book - Room Booking. So, when user select the Guest Name ---> Booking type ----->> Rooms Available ---->> No.of Persons. Base on the --->> No. of Persons, Rate should be shown Then Room Charges , Calculation Task has to be Perform. Instead
Set up a record summary as a live template?
How do you set up a record summary as a live template? The Status field seems to have disappeared. I want to make sure when I print a record that it uses a particular record summary.
I hate the auto indent feature
Hi Zoho, just letting you know I think the auto-indent feature sucks:P It keeps on moving braces around and mucking up my indentation. Could you provide an option to turn off auto-indent? cheers, Jeremy
Restrict Visibility on a Report
I know you can restrict visibility on a report for your users. However, when restrict certain actions like "Eport, Import etc., the actions still appear when I access the application. Is this because the user does not see what I see when the application opened? If so, is there a way to see exactly what the user sees? Thanks
Dynamic Lookup Field
Hi I am trying to overcome a mismatch of field type error with a dynamic lookup field I have an organisation and a people form. The organisation name field in the organisation form is a strong type. In the people form I have a lookup to the organisation name field. This is what determines which people are employees of different organisations. This lookup field in Bigint. In the organisation form I have a mulilookup field to look up and record people that are employees of organisations. The set filter
Fields from related forms displayed as "no value" in pivot table
Form A has a multi-lookup field to Form B. Report X needs to list records in Form A that includes fields from Form B (ideally as additional rows) Creator shows "-No Value-" for any/all of the fields coming from Form B. I'm assuming this is because reports support forms related by a multi-lookup, ie 1-to-many relationship ? In the example image uploaded the fields System, Sub system and components are on Form A while Mitigation Task Type and Summary come from the looked up Form B. Hoping I've missed
Next Page