Save Script button missing in Free-Flowing Script
Save Script button is not available in Free-Flowing Script. Even the shortcut Ctrl+S is not working. Please see attached screenshot.
Deluge for embedded custom report filtering using multi-select criteria
I need to create a custom report, that I can embed on an html page. The scenario is this: Table 1 (generated by form 1) has a few multi-select fields. Table 2 (generated by form 2) has individual fields with the same choices of values available in the multi-select fields in Table 1 I'd like to generate a filtered report of Table 2 based on the criteria present in the multi-select field(s) of Table 1. For example: Table 1 has a multi select field with potential values of A, B, C (in any combination)
Scheduled backup
Hi I miss a feature in your backup procedure. I need a way to schedule my backups. It is okay if the old version is overwritten by the new one. I would like the automatic backup to start every day at 17.00 CET. BR Skouboe
Select records with field value matching any one value in multi-select field?
Is it possible to create a many-to-one query? Value of multi-select field for record 1 is (TEST1, TEST2) Value of multi-select field in record 2 = (TEST1) Value of multi-select field in record 3 = (TEST2) Can I query the table to select record 2 and record 3 as matches for record 1, based on having one shared value rather than an exact match for both values?
Error at on submit script
Im having this error on my application even i do not have any problem on my script. please see images below:
String value assignment spanning multiple lines of input - similar to PHP's HEREDOC syntax or "Concatenation Operator" (Which is a period -> '.')
I've searched for quite a while now and have not found this question asked anywhere else. Does Zoho Creator support syntax similar to the HEREDOC syntax in PHP or some kind of concatenation operator?
Remove Text from a string.
I was wondering if there was anyway to display a certain part of a string that appears before a dash. Example: Report: - Item Record: R0000-00 Form: - Display: R0000
HTML formatting and editing lost in Creator 5 - workaround?
Previous version of Creator used to allow for inserting HTML on a page, and evoking a rich text editor to apply WYSIWYG type formatting. This functionality appears to now be gone in Creator 5 when using HTML snippets. Worse than that, HTML that IS formatted and displays correctly when using another HTML editor does not honor the text formatting (such as the /strong attribute). Previous pages migrated from old Creator have lost all of the text formatting. So none of the old Pages with HTML now look
"onaddrow in subform" Event in Form - only first row is executed
i want to pass data from a Parent form to a field in a subform and use the "on add row in subform" in the parent form. However this event seems to be triggered only for the FIRST row i add in the subform field When adding a second or third row - the script is not executed and the values are not passed to the subform :-( Any ideas?
Lookup
i have 1 dropdown and 2 textbox. i want to lookup ColumnB and ColumnC in a 2 single line textbox after i selected the ColumnA. example: if i select Jake in a dropdown list, the Department column must automatically lookup "Admin" and the Position column must lookup "IT" is that possible for zoho creator?
Formula to calculate weight lost/gained
I would like to build a formula for a page I'm building that subtracts the weight field from the last record entered (the current WeighIn) from the previous record entered (last weeks WeighIn), in order to see how much weight was lost or gained. I was told to use the for each record command to iterate and return the values, but I can't seem to figure this out. I have this variable formula which returns the 3 test records I've inputted. currentWeight = (Weigh_In[ID != 0].Weight sort by Date_field
Select City Form
I have seen threads on how to auto-populate city, state, county, and country via Google API but I am wondering how to incorporate a "select city" form for when there are multiple "postcode_localities" returned. i.e. zip 33708 returns; "postcode_localities" : [
"Madeira Beach",
"N REDNGTN BCH",
"North Redington Beach",
"Redington Beach",
"Redington Shores",
"Saint Petersburg"
] Which then those six entities will go into
Ask the Expert 4: Live Q&A: Find out all about using Execute Xpath builder to fetch data from third-party services.
Hi everyone, As you might already know, every application that you create on Zoho Creator can be connected with other services — be it a Zoho product or a third-party service like QuickBooks, Zapier, or PayPal. In this way, you can ensure there is a constant flow of data between all your productivity apps. Also, Zoho Creator provides you with an option to fetch data from any third-party service in general web data transfer format (either XML or JSON format) and parse it using our Execute Xpath builder.
how to add an option to upload a file in zoho app creator
Plz help
Form Name will not rename in sidebar display
I have a form which contains a number of subforms. I added a subform and the name of the form itself changed to the subform I selected. I deleted the subform I added. But the form name stayed the same as the subform. I have used form properties to rename the form and it works in the display but it still shows the subform name in the sidebar menu. I cannot get it to rename. I really don't want to recreate the entire form just so I can get the name correct in the sidebar. Any ideas? TIA
Report Filters Using Zoho.Loginuserid
I'm building an app for client tasks. I've got one form to track company information and another to track company contacts. The contacts form contains a multi-select lookup field of companies. If a company is in that field, the user should be able to see its information when they're logged into the portal. Initially, I thought Great! I can place filters on reports so users only see information/tasks they've been granted access to using lookup fields and zoho.loginuserid! So I created a Client Dashboard
Dynamic default entries in sub form
Is it possible to set the default entries in a sub form dynamically through script?
Customer Portal - "This application is not accessible." during
user approval
Hi, I am setting up a customer portal for my application. I want my customers to register their accounts rather than be invited so that their 'username' is defined by them, which I have done and is working fine. I also want to approve the registrations in order to control how many accounts are created and who has access to them. This is working fine, however how can I be notified when the customer has signed up and is awaiting approval? My main question: When the customer is awaiting approval they
Scheduled execution under 1 day
Hello, is it possible tu run scheduled scripts under 1 day recurrence, like every hour? Thanks A.
Next Task is Null
i have a section that was built by someone else. when the emails go out, the Next_Task_Template Record displays as a null value. I believe it is due to a line "Found_Current = "No" If "Found_Current" is just a variable with a boolean, and with in the next loop "Found Current"="Yes", then why does the inner loop not run? All this script is doing, is checking to see if when changes are made, the next task email gets sent to the next person. When I use the "Info" is states records are empty. any suggestions
How to upload an image by script
Is it possible create a workflow that would upload an image file? Pictures are shared on a network drive that is mapped on my computer. I know the file name and directory path, but I can't figure the code to upload the file to a field in a record. Is there any way to do this?
Creating bi-directional relationship through lookup
Hi, We are building our inventory module. We currently have a challenge. Will be helpful if some one suggest a fix. Overview of the process. 1. An order for an item gets booked. Here order booking is form, and list of items booked are through a form embedded as a subform. 2. List of items to be ordered is a lookup field from inventory master form. 3. When list of items to be ordered is booked by customer, each part ordered quantity is to be updated in the inventory master forms field Order
Iterate over Leads
I am trying to write a script which will need to find a particular lead OR contact (by email). My current approach is to get all leads, then iterate over the collection until the appropriate one is found. Here is my code: //get the appropriate category loc = zoho.crm.getRecords("Leads"); //leads or contacts if (wasContact) { loc = zoho.crm.getRecords("Contacts"); } //find by email oldItem = null; for each assoc item in loc { if (item.email == old.doctorEmail && item.pr_account == true) { oldItem
Pick the topic for the next Ask the Expert Session.
Hi folks, We hope you enjoy our monthly Ask the Expert sessions! We're eager to host our next ATE session, that will be held at the end of this month. Below are a few topics that you'll find useful. Which one would you like us to cover next? Go ahead and pick one!
How to configure Zoho Creator and CRM
I am trying lot of time to integration of zoho CRM and Creator but it is not successd result. Already reported to team and emailed but not positive response. Please help me.
Values from dropdown menu multiplying with numbers
I need some help. In a form I have made a Lookup. This Lookup refers to a VAT dropdown menu. I can choose different VAT rates (6.0, 8.0, 10.0 etc.). Now I want to multiply the chosen VAT rate with a Value field. I do this with the Formula button. The outcome however is a very long number -> 358930000000120350.00 What am I doing wrong? Kind regards, Arthur
Can not see live chat support and can not add developer.
Hi, I am using Zoho Creator Premium plan but I don't see the live chat system and I cannot add the developer to my application. Please see the attcahed file.
How to create schedule for every 30 minutes
Hi guys, I need to execute task for every 30 minutes. How can i achieve this? Regards, Termcon
Adding Customer Information to Form
I am trying to create a check in form and use the serial number of a piece of equipment we have received as a way of automatically adding customer information to the form. We work with the same customers and equipment over and over and thought using the serial number would be the quickest way possible to identify the customer rather than typing it in every time. I assume it will be a lookup field, maybe a sub form? I have a customer list that has the serial number on it. Any help would be appreciated!
Creating a Workflow with a multi-select field
Question 1: Who was involved in the incident. To achieve this I have a lookup field (Names) being displayed as a multi-select field. Question 2: For each of the people involved, were they properly licensed. There is not a definite number of names that will be selected each time. I would like to have a workflow set up where I have a response option for question 2 for each of the names selected in question 2. For example: Who was involved in the incident: Jill Bob Fred Was/Is Jill properly licensed?
Problem with iframe alignment
Hello - I have a page with 2 iframes. The problem I have is that I cannot seem to get the two iframes to align the content the same way. The first iframe is correctly aligning content to the top, but the second iframe is aligning content to middle (the content being displayed inside the iframe has a smaller height than the first iframe, but the two iframes themselves are set to the same height attribute). I have tried using height:xx% instead of pixels, but this doesn't alter how the content is displayed.
Sort SubForms
PLEASE allow records that display in a subform to be sorted by the field of our choosing. There are numerous reasons this should be allowed: e.g. sort by item #, date, alphabetically etc. Thank you!!
Adjust label width in Detail Record View, 2-column layout.
When I add additional fields to the Detailed Record View and select the 2-column layout, I seem to be stuck with the label extending half-way across the screen. This isn’t very useful as the labels are usually very short but the field content can be long. Can the label width be variable? Or provide an additional template with the labels only extending 1/4 way across?
Relationship scenario
Form LR is used to capture details from the user. Now we have to create an invoice for this LR so we created 2 forms: Invoice & Invoice LR. One invoice can have multiple LR associated with it. And while creating the Invoice we have to choose multiple existing LR that's why we created another form Invoice LR which has lookup field to LR. Check "Invoice Creation" file attached. Now upon successful submission of Invoice, we are linking the selected LR and Invoice with deluge script (not found any configurational
ZOHO TAKES FOREVER TO HELP!!!
We have been having sandbox issues for days, we have also had multiple issues in the past and ZOHO never gets back to us. They also say there "technical team is working on it" "its in the que" "its a trouble shooting ticket" Its becoming ridiculous that we aren't getting any help considering we are paying so much money to use there service. I wish someone would help us.
How to update Joomla Website through Creator
Dear All, Our Main website is Joomla based and I was thinking if there is any way to connect Zoho Creator with this website. The main idea is to connect some of our Joomla pages with a Zoho Creator application and when we update something in Creator then automatically the Joomla page will be updated. I know that it is a very general question, if you have any idea or example to show me would be fine.
Built-In Function Prefix
Good day, I am facing the strange behavior of Zoho. I do have two almost similar scripts that run on different forms, but on the same subforms. At first both script were working fine, but later it just stopped and was giving errors. I opened the script and see that strange prefix(APPNAME) for built-in functions such as isBlank and isNull. I guess it started treating them as custom functions, but still couldn't find the bug. And every time I rewrite and save the script, functions get prefixes.
Things that used to work no longer do
I suppose I am just venting, but I am furious and need to blow off some steam. I spend several months last spring developing an app for the next school year. Debugged it and it all worked fine last May. Now that the school year is starting I have found three things that used to work fine that no longer do. They are Zoho bugs, not my code. - A from is configured to redirect to another form when done. Works fine in a web browser. iPad app says can't open url. This used to work just fine. Why
MY CHARGEDESK Deleuge Code to integrate with zoho application
Dear Folks, i build for my application a function that make the basic api request of chargedesk a powerfull tool for handling payment ( like braintree) . I build the code for my purpose but give an idea exact to how to make the calls (POST/GET) and how to proper parser the JSON response , i'll attach the response from my test https://chargedesk.com/api-docs Please ignore all reference to my application and focus on how to parse JSON few thing to remind: 1) in the basic auth chargdesk release one
extract data from a lookup field
Good afternoon, I have a problem, we currently have a quote form that has a field lookup that shows in a multiselect way the form data called Accessories, we want to know how we can extract the data from a field lookup the price to add it? Regards
Next Page