Are you able to add ASAP widget into a Zoho Creator Application?
I am creating a custom application in Zoho Creator. I thought it would be really cool if I could add an ASAP widget into that application so I am able to create articles on how to use the custom application. More so, it would be cool to the ASAP add-on to other Zoho applications so I am able to provide training documentation for my company in a separate internal application using a separate help center. Doesn't appear possible at the moment but I thought that would be a cool integration when Creator
Integration
Hello, Can we Integrate Zoho forms and Zoho Creator?
Weird border when printing HTML pages?
Hi all I'm sure there's an easy solution here. Whenever I print a Page, a grey border appears around the body (see attached). Strangely, I have a couple of Pages that do not have this issue, yet I don't think there's anything different between them, at least in the script builder. Anyone come across this? Thanks!
Grid View no longer working properly
Hi there, We're having issues with Grid View on Zoho Creator. We have an attendance register that has a dropdown for each field to select the register code. This has now stopped working and doesn't show the drop down menus. Can someone please help. Occasionally if you mis-click you sometime see the dropdown. Have tried different browsers, screen sizes etc. But the problem remains. PS We're using the old version of Zoho Creator and cannot see a way of upgrading it and whether it will work with our
Creating Multiple Records (tasks) from Form Submission
We have a community event where we offer services. Customers come to our booth to purchase the service. The event is about a week-long so when they come to see us they typically purchase more than one service. I'm new to Creator but my current set up is: Attendance List List of attendees, contact info and site location of where they're located on the grounds (we obtain this form the organizers) Service Request Lookup field showing "First Last - Site" 8 Checkboxes, one for each service day. Formula
purchase system
Hello there, I'm working on a system of purchase Below the form i'm using. Everything works well and i receive the orders like this: I was wondering how to get stats of how many of each item were ordered by month ? Any way to do it ? Thanks for your help.
getTime function not working
I'm using the 'getTime' function in a Creator app but when I save it I get the error "Not able to find getTime function". I'm trying to use it as a function instead of a method. The latest documentation here states that I can use it as a function. As shown in the code snippet. <variable>=<dateTimeValue>.getTime([<format>], [<show_seconds>]); (OR) <variable>=getTime(<dateTimeValue>,[<format>],[<show_seconds>]); Do you know why it might not be working?
Error - WebhookCallWarn
What does this error mean? I cannot find anything on the internet about this. It's a very unhelpful error message. This is the code that it refers to the line has been marked: folders_res_0 = invokeurl [ <this line> url :"" + base_egnyte_url + "/v1/fs/Shared/BKNG-" + input.Auto_Gen_Booking_ID_Number + folder_name + "" type :POST parameters:parameters_for_folders_map.toString() headers:headers_map ]; It came after I created a function that did a call to an api. I don't know why it'd
Can you add files for download on your app?
Hi there! Just want to say what great customer service ZOHO has, I had an issue yesterday and within an hour it was fixed! Great service and friendly employees! My question is, can you add a page where clients could go to view and download PDF files? I have monthly files for each of my clients and would like them to enter the app go to a page let's call “files’ for now and be able to download the current months file and see past monthly files? I feel this may need some code which I’m not to clued
Custom actions in report header - get selected records
I have created a custom action for a report with a. Display Type - Show action in report header b. Execution Type - Execute action for collection of records. I want to write a custom function to take some action on selected records in the report. For eg. to send a mass sms with the selected to records in a single call. I would like to know how to get the selected records. Is this possible? Any example?
hotel booking/reservation template
Please create a template for handling reservations and bookings please! thank you! Dennis ddaniels
I have a long form and want to break it up in creator
I have a 300 question form I need as a customer input form in an app I want to build in Creator. Obviously, I want to break up the long form into a series of shorter forms. I am told the way to do this is with stateless forms and a master form but I cannot find any information on how to do this. Please can someone point me in the right direction to manage this? Thank you!
Display only one Value in a table
Right now, I have a table that gets updated daily. There are separate postage amounts that get put in, and I want to only display the total of all the postage, not each individual postage import. <body> <div class="divTableHeading1">Section A: Costs / Expenses</div> <div class="divTable"> <div class="divTableBody"> <div class="divTableRow1"> <div class="divTableCellB">Invoice Number</div> <div class="divTableCellB">Date</div> <div class="divTableCellB">Description</div> <div class="divTableCellB">Status</div>
Zoho Filedownloader error
When entering my credentials, it responds that my username or password is incorrect, please help
Count # of "NEEDS ATTENTION" for sections?
Hi all, I was trying to script a workflow for counting the # of "NEEDS ATTENTION" radio buttons I have for each section I have in this form. Is it possible to count the # in a section(field) or no? Also, what's the easiest way to script counting these "NEEDS ATTENTION" radio buttons? I have posted 2 pictures below for reference.
Portal Form - DOWN
Hi all, anyone experiencing issues with any forms loading on a customer portal. As you can see its not a case of hidden fields as there are no buttons to submit or reset. also when clicking to edit an existing record the loading page is just continuously loading
How do I fetch data from a subform?
Here is the scenario: Form 1: Submit_issue Fields: WorkOrder (autonumber) Issue (multiline) Notes (subform - form 2) Form 2: Notes Fields: Date Time User Note Form 3: Open_Issues Fields : This_work_order (lookup field -> from work order on Form 1) Notes (note field where I output data) Submit_issue form has a subform called Notes. So within the subform you can submit as many notes a you like as it pertains to the main form (Submit_issue). I am trying to
Create a text document that is dynamic based on data inputted into creator by the user.
I'm using Zoho creator to create an Application which analyzes data thats given to it and creates a custom "text report" based on it. My plan was to have several pre determined documents that have dynamic variables within them. Do I also need to use Zoho writer to do this? Or would this be possible with deluge scripts alone? I'm new to Zoho as a whole and deluge. Thanks
Restrict report access by customer (NOT user) ZC5
I want to restrict access to records in reports by customer. I will have multiple customer portals on my db and when a user accesses a report they need to be able to see ALL records for their customer, irrespective of which user added that record. I have created a deluge script that add a unique Customer ID to each record based on the user logged in. I want to restrict access to reports based on Customer ID that belongs to the user logged in. Can I do this?
Need to create a callback URL to get incoming SMS messages from API
Hi, I need to get all incoming SMS notifications from a site I use for my application. I created a callback on the site I use for this task. https://smsgateway.me/sms-api-documentation/callbacks Can anyone help me how to accomplish this? I'm not a developer but I was able to create everything I need for my app by myself until I hit this stumbling block. This post seems to answer my questions but I can't access the links. https://help.zoho.com/portal/en/community/topic/api-and-url-callbacks Any
HTTP PUT/DELETE for Constant Contact API integration
Hello, I am trying to do some integration with Constant Contact. Some of their API requests require the use of the HTTP PUT or DELETE requests (https://constantcontact.mashery.com/io-docs), but it looks like Zoho only has GET and POST implemented (https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-url.html). Is there a workaround for this?
Update Record in another forms Report
Hello, I am trying Update status of few records in "Purchase Order" form from "Inventory" form when i tried to code that it said this type of updation is not supported. Records in Purchase Order form are in Subform is there any other way to do it?
Hide Submit Button
Hi ! I have the necessity to Hide or Disable the Submit Button in my form ! there are any system to do this ? Thank You
One Customer Login for Multiple Applications
Hello, I am wondering if it is possible for a customer to sign into multiple applications using one login? so rather than the customer making a new login for several apps if they would access multiple apps with the same login information based on the different links. Thanks for the help!
simple (I hope) Deluge script requests from a newbie
Hey, Complete newbie here - wondering if you good folks can assist with a script request (or two) and general Qs? I have a form with a single field that requires a QR code input (a mobile phone scan) How can I introduce a delay (in seconds) to prevent the same user from re-submitting a form (after their successful initial submission)? In reality, this will prevent repeated back-to-back scans of the same QR code. I also wish to show an error message (e.g. please try again in X seconds) I need a
API and URL callbacks
Hi, I am new to Zoho creator and need some advice. I am creating an application that involves sends sms's. Sending the SMS is not a problem and I have got going thus far. I want to receive sms reports so that the status of a message is sent is set to delivered. I have a form that records all the details of the sms and have included a colums that has 1.message status(Pending,Delivered,Failed) 2.Message ID (Which will grab the message ide from the HTTP callback from the service provider) 3.Status
Calculate Age
All post on this are 10 years old or so (at least what I can find). I gotta be missing something like YearDiff(Date1, Date2). I found this: (((zoho.currentdate - input.DOB)) / (1000 * 60 * 60 * 24 * 365)).round(0) it does not work correctly. How would I calculate a person's age?
Radio Buttons with Images !
I was pleased to find, with a bit of experimenting, that I could use an image <img> as a choice in a radio button field : And this delivers a much better user experience when users are making simple selections, such as status, stop/go, approve/decline etc..... And the results render very well on the GUI : But when I use this form as a SUB-FORM, because Radio Buttons are converted to a DROPDOWN, I loose the feature to display the images.... So 2 questions : (A) Why do the very similair fields of RADIO
Page
Hello, I have created Report Page using page parameter, so my question is can we mail the page report?
Update/Transfer Field Value in Creator form
I originally made a mistake many years ago and setup my database to use a text filed for phone numbers. Now I added a actual Phone Number field. How can I copy the contains from each records "Mobile" field to the "New_Mobile" field? I have limited experience and could use some simplified assistance. Thank you!
Need direction to create a map report
Hello. I'm trying to allow volunteers to quickly create a map of deliveries by putting in the names of the recipients they've been assigned for the day. I've already created a form to input all of the potential recipients. I want a volunteer to be able to use a very basic form to put in his or her name and the date of deliveries and then select the people he or she has been assigned from the list of possible recipients. Next, I want Creator to look up the addresses of the recipients the volunteer
How do I pre-fill some fields?
I need to create a form to allow people to enter data for multiple workshop events. I now have a form which allows a user to select their name, city and state date, time, location from dropdown menus. This works great if someone is entering a single event, but if they need to enter multiple workshops, they have to repeatedly select their name, city and state. Since this information will be the same for each event and since only the time. location and date will differ, how can I have those specific
Div / iframe
I've been having a few problems with embedding my reports in pages and Zoho has suggested two fixes using HTML snippets. One using div and one using iframe. I'm not an experienced coder so I wondered if anyone could explain the difference between divs and iframes so I could think about the implications. Many thanks!
Link a Creator Form to a Zoho Forms form
Hi, I'm wondering if it's possible to auto populate a Zoho Forms form on submit of a Creator form? The end goal is to create a document in Writer using 'Merge on Form Submission', which as far as i can tell, can only be done from a Forms form and not from Creator. Any answers/ideas/hints would be helpful. Thanks.
Trouble with Un/Share function
I am using the function from this article: https://www.zoho.com/creator/help/share/sharing.html I want to share a form with my users once they complete a separate form. Once the user submits the form, I have added the code: share form("Form_Name",zoho.loginuserid); However, after completing, the form is still not shared.
Calendar Report: Freeze header and left time intervals
The header and the left time intervals on the Calendar Report are not freezed, so if the user scrolls up-down or left-right they dissapear causing the user to do not know to where the events belong to. Here an example: Before scrolling: After scrolling:
Search app for large number of records
Hello, i have a large number of records, 50000. I want to filter the records but I don't want to do it in a report because it will be really slow to show the 50000 records everytime. I would like to have a gui that I create my filters and then click apply to only see the records I want. Is it possible?
Filter
Hello, I have "Purchase Order" form i would like to have a status field where it would filter whether the Ordered product is in stock or went for cutting product wise and it should update on every update in Stock. And the product details is in the subform. Is this possible? If yes, please help me how do i do it?
Creator Customer Portal - Lookup Portal User ID by Email Address
I created a form which creates a Portal User via Email Address and assigns a user profile based on selected radio button (this part works great). I'm using the record of this as my own "User Profile". I've added a "Users" field but I can't get that field to auto populate. I assume it needs the ID of the portal user, but I am unsure of any deluge code which allows me to lookup the userid by email address.
Lookup field / linking forms by ID?
What would be the best practice to link multiple forms to one. Here some explanation in detail: My application is for people to add their details and upload personal files, like a sort of personal CV. Main form: Personal Details form 2: Section Add documents form 3: Section Add files form 4: Section... etc And a Page: to view all sections together and links/buttons to each section to add or update those. Would be working with customer portal. Each user can login and should see only their file(s).
Next Page