Passing a variable value in a Permalink to a Form
I want to send a user a customized permalink to take him to a form. When he click on the link, I want to pass his username or ID to the form so that the Form can show only information relevant to him. For example, when a call desk captures a new "fault" based on a telephone call received from a client, I want to send an email to the client with a permalink that includes his TicketNumber. If the client clicks on the link, he will be able to seen progress on that specific fault and he would not
Select a value provided by the user into an "Add new" looked up value
I have a Main form called "Progress". Within "Progress" I have a lookup value that refers to a value in the form "Expected Outputs". This lookup value has the add new action enabled. In the "Progress" form, the user selects a project from a drop-down list. I would like that this input.Project could be automatically selected when the user adds a new "Expected Output" from the looked up value. I have been trying but I cannot find the way.
Creator 5 Migration Experiences w/ Portal and Paypal??
I have a large app that I am thinking of migrating to Creator 5. However, given past experiences with Zoho upgrades and the rather nebulous Zoho list of "degraded functionality" in Creator 5, I am nervous about changing anything. I would appreciate hearing other users' experiences in migrating to Creator 5. I am particularly interested in the following functionality that is used heavily in my app: 1. We have over 1,000 active Portal users, with a steady stream of new adds (about 200 a year) 2.
Redirect Customer Portal to external domain
Hi, I posted another question but perhaps this a better explanation. I have a domain say https://www.mydomain.com . I want customers that go to that domain will be redirected to my Zoho Customer Portal. I verified the domain that works but this just seems to concern mail. I really want a redirect, My hostingcompany asks for ipadres and such for a dns redirection. Where do i find this ? Please help i'm on a deadline and dns resolves will take long. Thanks !!!
Append code to Sign-up handler (insert into) not working
I added/appended this (default) code to the Helper on signup handler, but it doesn't seem to work when I test on a newly created Stage account. Is is extremely simple code. Any ideas on why this is not working? LIST_avdelning is a Form TXT_avdelning is a text field void signup(string customerEmail, map customerInfo) { insert into LIST_avdelning [ TXT_Avdelningsnamn="Ekonomi avd" Added_User=zoho.loginuser ] }
Print out a report page ?
Hello, In Creator I build a page with multiple panel and reports. I'm asked to have a PDF version of it, or at least the information. How can I acheive this ? There is apparently no way to print this page. Thanks
Unable to access production environment
I'm using custom solutions, and just in the last hour I've been unable to access Production. I have customers in there so is mission critical for my business. I have tried 2 different prod environments and 2 different browsers. Is anyone else have issues? Does anyone know where I can look to find the 'health' status of the environment in general so I can check without bothering technical support.
Email embedded link for non-user
I'm looking for a way for a non-user (not logged in or a Zoho User) can view a report record (Summary) sent via a link in an email and be able to click a decision box or other check box to reply (in the form). I need this record to be separate and independent from other records (views). After the non-user "checked-the-record" that record would then become unavailable for view again. Can this be done?
Delete Subform record when row deleted in parent form
I have a Parent form with a subform (which is an actual form, not created from Blank). The Parent form is "Parent Companies", while the subform is "Locations". Each parent company may have multiple locations. If I delete a "Location" (row from subform) while editing a record in the parent form, the data still remains in the subform. I would like to also delete the data in the subform form. Is there a way to accomplish this?
Circumvent "Get input before the form is displayed" field
For our mobile users, we have: a single-line field with QR and barcode scanner enabled, and "Get input before the form is displayed" enabled. This works as expected when users enter the form "the normal way". Now, I'd like to enter the form with a URL parameter that's passed to this QR/barcode/"Get input..." field and bypass the scanner, but this isn't happening. Basically, "Get input before the form is displayed" trumps "on Load". My "on Load" scripts fire when I enter the form (I tested this with
Only returning ID. How to get the field values?
I am populating choices for a radio button. Problem is that it only returns the ID of the row, while I want the actual value for the field (size_groups). How do I extract this so it list the actuall values, rather than the ID? My code: avail_size = f_sizes [ID>0] ; clear input.f_size; input.f_size:UI.add(avail_size.size_groups.getall(size_groups));
Dynamically add subform recorda on Form A to Lookup on Form B
Hi, I have tried the following script to dynamically populate a Lookup on Form B with subform records on Form A. I see the IDs are fetched bu the ui.add does not work here: sob = FormA[ID == fet.ID.toString()].subForm; input.FormBLookup:ui.add(sob.ID.getall()); Could you please help with the script that can fetch records from a Subform on Form A and dynamically add those records to a Lookup on Form B? Thank you
Functionality issue in Zoho Creator - Unicode in mail message
Namaskaram Zoho Creator team, we have tried to use the unicode symbols within the message of send mail. It shows the error and after showing that error message, the code has been deleted automatically. Please fix this as soon as possible. Refer following images. Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho Authorised Partner | 8+ Yrs | 200+ Projects | 100+ Customers
Why is the Zoho Creator team such a joke?
Over 23 days now and the Zoho Creator team refuses to give me any information as to why Twilio and Clockwork SMS Integrations don't work at all. I've been patient for over 3 weeks and they refuse to give me any information at all. No timeline, no nothing. Very unprofessional to treat a paying customer like this. Really sick of the terrible support here at Zoho. Did you know that we paid for premium support in full last week to only be told yesterday that we don't have a premium support account? The
Development Work during Lock-Down
Good day I have been developing our own internal apps for a non-profit for the past 4 years, for no income. Now, with the worldwide pandemic I suddenly find myself in lock-down, with no options of income for at least the next month. I am not yet a certified developer, but I would appreciate it if there is any development work available and if someone would be willing to give me a chance. This is my only hope at this stage. Please contact me at hendrikfsmit[at]gmail[dot]com
Hide / unhide custom action button with conditional statement
I have a custom action (to call a function) on a view. Is there a way to hide / unhide or enable / disable the custom action button based on a conditional statement (ex. IF statement)?
Zoho Creator - Unable to include form as SubForm
I'm currently using Zoho Creator trial and trying to include a form as a Subform in another form. However when I drag the subform item into the form there is no option to use an existing form. Instead I can only add new fields. Is it possible to link an existing form as a subform?
Drop down field for State and District in Zoho Creator
Namaskaram Zoho Creator Team, As of now, there is no possibility for changing District and State field from Single line to Drop down. It will be a good feature if the users can able to choose their Country followed by State and followed by district automatically using Drop down. When a user choose a Country based on the Country name the State field must be sorted with values related to that chosen Country. Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho Authorised
Zoho Creator
how can i seperate my consultants emails those are not submitted timesheets before 5th of the every month??
Customer Portal and Optional Login
Hi, Zoho Creator looks like amazing product in many ways, with clear and properly written guides and tutorials, well done! However, I have studied the eBooks, looked into this community, watched YouTube videos and browsed the Internet, but unfortunately I didn't find a solution for my need. I would like to create Event Management portal, where customers could browse the events and also create them. Browsing events and buying tickets should be possible without signing-up, because if sign-up is required,
Add a record in another form based on result of conditional If in a subform
I'm trying to add a record to another form based on what the user chooses from a multi-select in a subform. I am using on Success. Before I created without a variable (var1) and it inserted a record, but every time. Completely ignoring the conditional If. Now it's doing nothing at all. I've tried adding a Success message by adding an 'else' parameter, but nothing happens. Any pointers, help appreciated. I've been battling with this 2 days now. CHILD_Steg5 is the subform MLT_kansliga_data is the multiselect
Cross Application Reporting
Hi all can i get some assistance, have created a system which relies heavily on multiple applications. There is a separate application for each entity. I set it up this was as the request was that there needed to be separation between entities for security , reporting etc. But there is an administrator who needs to administer certain actions across all the entities. Each entity for example takes application forms and they need to assign them to different people. But there may be 20 entities running
Issue in Zoho Creator - field link name suggestion not perfectly showing
Namaskaram Zoho Creator team, Usually the field link name suggestion showing while writing deluge script. But sometime it is not showing properly. Please have a look into the following image. In above image, the suggestion is shown. Now look into the below image. In the above image, the suggestion has gone. Now, again it is visible after entering the third letter. Please resolve this as soon as possible. Crafted with ❤️ Zoho Gurus | Zoho Creator Practice Team @ CubeYogi Zoho Authorised Partner
How do I remove a creator app that was shared with me
Hi, Someone shared an app with me but I do not have access to it. They are no longer around and I have no way of contacing the person. How do I remove an app I have never seen or used from our account? Thanks
Image voting / uploading app
I need an app "Image votin contest" - user can vote for best image + upload new images thumbnail listview of images - user can vote for image (1-5 starts) - Sort View by Most Votes, upload date etc - Upload new images to participate in a contest "Zoho Share" looks like it has a look and feel of what I need Is there a source code of "Zoho Share" I can use?
CRM lookup fields in creator show some bugs while searching
I have a lookup field in creator that integrates with contacts module. When I'm searching for certain names of contacts, it doesn't find these contacts by their full name. If I search only for some words of the last name i can find them, but not always. It also seems to be random, some contacts I can search by their full names, others I can't. And they are saved in CRM just like those I can't find. Seems like a bug to me. How can I get this fixed?
Why is the word "script" suddenly reserved for variable names, input parameters and form fields?
Ok so I wake up and find that all my Deluge scripts are no longer working. As usual you get the "Improper Statement – Error might be due to a missing ';' at the end of a line" nonsense error prompt. Then after hours of debugging you find out that the word "script" has all of a sudden been reserved and may no longer be used as variable name, input parameter name or form field. Of course there is absolutely no information about this breaking change and no documentation as to which words are reserved.
Overview
Hello All, I am creating management application where everything is managed by Order Nos. I would like to create an Overview wherein i ask the user to enter Order No. and everything is displayed on the page with every data related to that Order No. Thanks & Regards
Functionality Issue in Zoho Creator - Deluge inbuilt function "hoursBetween"
Namaskaram Zoho Creator team, The deluge inbuilt function "hoursBetween()" takes two dates as parameters and return the number of hours between those two dates. But it fails in following scenario. Let us assume the start date is 08-Mar-2020 00:00:00 and end date is 10-Mar-2020 00:00:00. It should returns 47 hours instead of 48 hours. This problem happens, only if the start date is less than 10 and end date is greater than or equal to 10 and if both dates are set for 12 am. This is very
Picklist for District/State when using Address Field
Is there any possible way to do this? I know how to make this work if I use individual fields for an address, but how about when using the Address field type. I tried modifying the code in the IDE which kicked back a generic error.
Subform as a pop up box
My subform contains too many fields for the width of the screen. It looks terrible and is hard to use. Is there any way to have the subform come up in a popup box with the fields stacked vertically instead of horizontally, when one click on "add new" in the parent form? See pic. ?
Grouping Data in Charts
Hi - I have a stacked chart in Zoho Creator that contains data counts for categories A, B, and C. Is there any way to group the data so that the chart shows A and B+C together as a group? Thanks!
Sign in to databases
It seems I never know if I will be required to sign in to my Creator databases, or not. Some times I don't, but lately most all the times I am required to sign in. Cookies are enabled. No one touches the databases but myself, and I'd prefer to not have to sign in every time I open one for changes.
Unleash your Zoho Creator HTML Views using "ZCML"
What is ZCML? ZCML is HTML with a Zoho Creator twist. ZCML let's you write HTML on your website or web application very much the same way you do in a Zoho Creator HTML View. You get the benefits of the same embedded variable syntax without the need to use the ZC REST API. This is not iframing. ZCML is HTML native to the website or web application it's being rendered on. Please watch the video. Why use it? It's Fast Zoho Creator HTML Views can be very slow to render depending on the number of statements
Zoho Creator Functionality issue - Workflow triggering on Stateless form
Namaskaram Zoho Creator team, When we tried to create a workflow based on a stateless form, there are two options are available for triggering that workflow. One is 'Button click' and another one is 'Created'. Initially 'Created' has selected. When I click on the 'Button click', the 'Choose button' option has started to visible. After that, If I select 'Created' then the 'Choose button' option should be hidden. But it is being visible after selecting the 'Created' Option. Please have a look
Problem with Report Filter in Zoho Creator
Namaskaram Zoho Creator team, we have found a problem with Report Filter in Zoho Creator. We can't set a filter based on an image field from 'edit' mode of the application. But we can do the same from 'live' mode of the application. After setting it from 'live' mode, we have tried to edit the filter of the same report from 'edit' mode. Then we saw an error in that filter editing window that is the filter what we set from live mode based on the image field has been cleared automatically. Please
hyperlink
Hi, I wanted to insert website addresses in zoho creator. How to just insert a name, and then add link to instead of writing the full hyperlink address. Thanks Budcare
Line numbering / background toggle in PDF template
Hi, I'm currently building a Print & PDF template for one Report. The related form has a subform I'm inserting in the PDF. Customizing the page is quite difficult as I try to customize the HTML code. Customizing the subform field is even more limited it seems, and not html can't be changed as it's rewritten each time. My goal is to either add line numbering to each record, or display a gray background every 2 lines. Is there a way to customize this field and how ? Also, how can I write my own column
Error with newrecord/oldrecord and On Delete On Success deluge.
I have a report that is an executive summary of the maintenance we perform on our vehicles. It shows the last completed record of several types of services. I have the code below in the on success of create and edit and it works as intended. I also want it in the on success of Delete and it works fine until all records are deleted and I get hit with the error message in the attached screenshot. Can anyone provide a answer on how to avoid that error? for each oldRecord in Maintenance_History_Form[Unit_Number
Live Asset Tracking
I have read a little on the possibility of setting up a google maps API to view assets in real time in creator. Has anyone implemented this or have any insight on the best way to set it up? I have a trucking app and would like to be able to see where my vehicle are in real time to allow for customers to see where their shipments are at and to be able to better route and schedule drivers to loads based on loaction.
Next Page