Can't find the error...
Here is my code following a tutorial on the forums about mapping variables. I have followed line through line of the code and am getting an error with the "void" function. In the script editor, the error reads: "Encountered "void" at line 17, column 1., Was expecting one of:"if" ..."for" ..."delete" ..."insert" ... "inserthtml" ..."share" ..."unshare" ..."%>" ... fields=getFieldNames(); form_map=map(); for each field in fields { value=getFieldValue(field); form_map.put(field,value); } void
ZC Mobile - HTML view
Hi guys, Am new to ZC. Is it possible to set 'native' views and forms to be visible to mobile only, while the desktop user will see only HTML views? Appreciate your prompt comments, Gidday Idan
combining string records
I have two string records, "first name" and "last name", and I want to group them together to make a single "full name" string. How can I do this? I've tried assigning variable, but it doesn't seem to work.
Over Limit notification for Developer
Two of my clients had problems with their applications last month because they had gone over limits. One hit the limits of records in their account. The other had executed more than the allotted schedules. I assume an email was sent to the application owner when they neared their limits. Can you also send a notification to the email address listed as the developer on the Applications Settings page? Herb Wexler
Summing days to a date field
Hi, how I want to send a email if the present day is due 10 days from the "Data_de_Registo" when the form was inserted, the problem is I can´t define the 10 days here, as it gives me the next error. The Left expression is of type TIMESTAMP and the right expression is of type BIGINT and the operator + is not valid here if( Estado == "Avaliação") { if( zoho.currentdate >= (Data_de_Registo + 10:00:00)) . How can I develop this? { sendmail [ from:zoho.adminuserid to:"xxxxxxx@xxx.pt"
Deleting record from lookup fails to save selection
I'm trying to use uses a form "choice_remaining" to present users with a list of items (Say a list of cakes for a pot luck) I've setup a form called sign_up that lets them write their name and using a lookup field pick an item from the list. As each submit record makes a selection, I want to remove their choice from the list of possibilites. Eventually the lookup would be empty. All this works well except the selection from the lookup field (input.Selection) is never saved in the sign_up
Select/Deselect use
If I understand correctly, Select/Deselect of multiselect fields (including linked multiselect) can only be used in the script section of the OnLoad and OnEdit of the form. If that is true, how can a record be modified via script from a custom action button, for example? If that is not true, what is the syntax for its use? Can anyone provide a sample code?
Corrupt form?
Dear Zoho Team I have only one form in one of my applications. When I open an existing record, the onLoad script does not fire. When I add a new one it does. Furthermore, if I add a Notes field to the form, it is only visible when adding new records but not when opening existing ones. Please advise. Regards, Filip PS: the app in question is dsm; edit access is granted
dialer
additional assistance requested Hi, You can create a formula field and place the call link of the Phone as "<a href='callto://" + input.Phone + "'>" + input.Phone + "</a>" Ruben Zoho Creator Support 0 Best answer Comment gorlando5 Re: dialer 1 day ago thanks ruben, i just created a form and view and it does create the call to but nothing happens when i click on it. how to link up to dialer? thanks
Edit records using Stateless Forms
Could someone point me to where I can find out how I can use a stateless form to edit a record? I feel that this must be such common requirement in most applications that there will already be some documentation on line, but I haven't spotted it yet. What I envisage is that once the form is open there would be a way to launch a script (a button On Click?) that will fetch data from a record and populate the stateless form. And then, of course, when you 'Submit' it needs to update the existng
If then script
Hello. I am trying to figure out the Deluge Script in Zoho Creator. The result I am trying to generate is this: Through inputting, these variables are defined. vs (this is a percentage) Week_Gross (this is a decimal generated through a formula by adding several previously inputted numbers) Guarantee (this is an integer) In plain speak, the result I want is If vs * Week_Gross is greater than Guarantee, then output vs * Week_Gross, otherwise output Guarantee. I have generated the following
Setting Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. Does anyone know how I can
Creator added auto-filter on pre-existing applications automatically
As of yesterday I went back to check some pre-existing applications and noticed that auto-filters were applied randomly (and automatically with-out my input) to my various applications. On top of that some of the views will not show up and I get the following error [ServletException in:/jsp/edit/view/viewedit.jsp] null' Please look into this problem and get back to me Thanks
Styles for Embedded Forms: IE issue with blockquote CSS
In Internet Explorer, the blockquote shown below is white. In Chrome, it takes the color of the form. Can this be fixed? I'm using style url attributes to control the appearance of these i-framed forms (ref). Cheers, John Whitney
Popup window reported a bug
Hello Zoho Support team and Developers, I am added a problem here which i am encounter in my application, i am add many clickable icons or links in my HTML view and all of them are opened in popup window. now the popup window encountered a problem. when i am click on the clickable link i am see a popup window appear now i am close the popup window by click on cross icon on the popup window. as i click on the cross icon of popup window the popup window is disappeared, now when i am again click on
Add Data by Email Issues
Shared to support https://creator.zoho.com/buzzap/form/209/edit/ I have a custom gmail account authorized to forward email to the form linked above. It worked a couple times but now it's not. Cheers, John Whitney
convert xml response (from ZohoCRM) to simple “key=value” pairs (for SurveyGizmo) using php or Zoho Creator
Hi there, This deals with exchanging data between CRM & Gizmo. I'd like to Creator (or php) to convert the response. SurveyGizmo posts (insert) data to ZohoCRM. After insert, Zoho responds with xml that includes an ID of the inserted record. Gizmo needs that ID for subsequent updates. The problem is, Gizmo will only accept a response in a simple "key1=value1,key2=value2" format.I'd like to have ZohoCreator receive Gizmo's post, pass it through to ZohoCRM, receive the xml response from ZohoCRM,
Add row to subform in other application
Hello! I'm new in ZC. I have Application 1 and Application 2 with subform. In Application 1 i have Lookup field wich show name of records from Appl. 2. I need to add new row in Appl.2 subform, when i chose data in Lookup field of Appl. 1 and save it. Row in Appl.2 subform contain some data from Appl.1 Can you show me example how to do this? I try to use bedirectional relationship in Lookup field wich add to Appl. 2 subform, but it not add new row to subform when i chose data in new record Appl.1,
Is there a good way to create random passwords
I'm trying to create random passwords for users, but there is no random function. Yes I can use input.var = zoho.currenttime.toLong() 00; to generate something similar based on time, but try running this serveral times rapidly to choose characters in a list and you'll get similar numbers. Just as a test I tried: random1 = (zoho.currenttime.toLong() % 1000); random2 = (zoho.currenttime.toLong() % 1000); random3 = (zoho.currenttime.toLong() % 1000); random4 = (zoho.currenttime.toLong()
database restructure help
Hi I'm at the stage now where I need to restructure my database as I've decided on a solution which will meet my requirement to avoid duplicate rows. My issue is this - I have two core tables of 'organisations' and 'stations' as well as a table linking them to manage ownership relationships. Historically I have linked owners to the stations through a lookup on the 'station' table but this has left it impossible to sensibly manage joint owned stations. What I want to do is copy all the
on import (excel file)
Hello, I have three fields in a form I created (serial number, module type, is used(checkbox yes) On the import the user will select from the excel file just the serial number. I want the checkbox to be automatically set to false ( I imagine since it is not considered checked it is false, but I think it is actually Null instead) and I want the module type to be 0. Is there a way on import on each field imported the two other fields get their default values? Thank you.
Help on viewing a related record field captured using aggregate records function
I wonder if anyone can help me please? I'm relatively new to Creator and i'm struggling to find a way to do the following: Using the syntax below, I can capture the appropriate value for the "Date_Worked_1" field, but i'm stuck when it comes to returning the value from another field in the same record that this returns. Suggested_Date = jobs[Allocation == "AVAILABLE"].minimum(Date_Worked_1) ; What i'm aiming for it to return the value for a field called "Hours_Worked_1" from the same record that
Want to include a Linking icon in Form View?
Hello developers and Support team. I have any application and in this application there are many forms and different views. i want to palace a icon like help icon to all forms views, where when user click on that icon they will automatically redirect to an another address. please see below picture for more clarification: If it is not possible to add icon to the form header then also provide me an alternative for where i can use it? Cheers
Common script
Hi, I've created a form that has a number of look-up fields. When the look-up values are selected, it changes various numeric fields, I therfore need to re-calulate all field upon update. I've copied the required script in each field. As the code is common, is there an easier way to call a script to re-calculate. This way I only need to maintain a common script? Thanks, Martyn
Can I submit once to multiple tables?
I need to have a single form that contains fields associated with different tables. When the "submit" or "save" button is pressed it saves the field data to the appropriate table. An example would be: Data entered into the "part description" field would save to the "Parts" table. Data entered into the "List Price" field would save to the "Pricing" table, and so on. Is this possible? Thanks for looking at this.
User Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. UPDATE: I have created a duplicate
Wrong entry populates form when submitted.... Argh!
I'll try to make this brief..... I have an application that has 2 forms (Buy and Customer) and two views (Buy and Customer), and one HTML page. Form "Buy" is filled out and then submitted, which then generates the HTML page from which I can send straight to a printer. Problem is when I have 2 entries that are similar (these are names - Last_Name and First_Name), the wrong entry often gets put on the HTML page. So if there is, say, a "Thompson, Darryl" in my database, and also a "Thompson, Matthew",
New UI seems to adversely affect two column Forms that contain CSS and HTML in notes fields
Hi Zoho Team! I have been using Notes fields to display dynamic data in my Forms using a combination of deluge script, HTML and CSS. Immediately upon trying the new UI for views yesterday I noticed that a number of my forms were displaying their content differently. On forms that used the two column layout (as opposed to the single column layout), Notes fields were dramatically changing the widths of the columns. These columns have always been locked into a 50/50 split of the width...in other words
One or more fields were dynamically changed
Getting the message "One or more fields were dynamically changed. Please resubmit the form." What could be causing this? I have neither On Update nor On Success scripts in my form.
Fetch and Update records from sub form
I have a parent for in which have a sub form with several values in each record. how can I fetch and update the sub form in the parent form
Cascade deleting on Parent-Child Relationships
I've built my app to be able to hold parent and child relationships. I want to be able to select the parent record and delete it. Once I do that, I want all the child records that belong to this parent to be deleted as well. I was thinking of using a script to delete the child records when before the parent record gets deleted but I'm not sure how I can identify all the child records. Anyone have ideas how I can do this? Thanks!
OAuth/REST/JSON interaction with other services
G'day all I'm considering Zoho Creator as a data management option for a mobile app service that I'm developing. The data is delivered to mobile app by Stackmob.com & that works well. StackMob use a REST/JSON API with OAuth & any data management solution I use must be able to interact with that API. Can anyone tell me if I should be able to do that with Zoho Creator & if so point me to the relevant docmentation? Cheers & TIA, Pedro :)
Fetch and Update and then perform actions on success
I have two forms: Add_Products Notify Add_Products holds my stock availability information. Notify contains a list of customers that are signed up to receive an email when the item is back in stock. Both of them share a common field which is Product_Code_SKU. I have the following script in my Add_Products (On Edit->On Success) form: if (input.User_Product_Availability == "In stock") { for each OOSItem in Notify [Product_Code_SKU == input.Output_Product_Code_SKU] { OOSItem.Status
Misbehaving 'Close' button in html view popup
I use custom 'View' buttons to open records in my views (with ... href=\ \"#View:myView?zc_LoadIn=dialog&recID=... in a Formula Field). This has been working nicely for a long time. Since fairly recently, the 'Close' button/link is suddenly outside the popup (in the "dark" area surrounding the popup) and is displayed in plain black text. I really have to search for it... Any help appreciated. Regards, Filip PS to Zoho Team: App in question: bmpm; Edit access is granted.
Searching through dropdown inputs
Im searching for a particular customer to create a Work Order. The dropdown is a lookup of Customer_Name from another form. Lets say I want to find a customer named "Fletcher's Jewelers (Colonial Heights)". If I start typing in the Dropdown Search field, the text "fletcher's", all of my accounts begenning with "Fletcher's" appear in a list. If I then type "fletcher's j", all of my "Fletcher's Jewelers" customers disappear. Why is that? It doesnt seem right. I have a Ton of customers that start
Can log in data be sent with the URL?
Can a URL be constructed that includes the Zoho log in data so the user is automatically logged in to the application just by clicking on the URL?
why is an embeded from in my website showing "hidden fields to others"?
When I try to embed a form into my website all the form fields are shown. How can I embed a form without it showing the supposedly hidden fields? This is without using a user login as well. thanks, brian
Importing Data from TEXT FILE
I have information in a TEXT (actually .dvc but can be viewed in notepad) file I'd like to be able to import into ZOHO creator. Every line of text I'd like to be a different entry of data in a form. This is the example of the file I'd like to import: // DVC VERSION 2 // "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/producerpromos11.m2t" 00:01:29.880 SU --/--/-- --:28:30 *.dcmd PS "/media/hd0/media/producerpromos11.m2t" // "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/communityboardslides43a.m2t"
How can i add Emails under Contacts through Creator
Dear Respected Zoho Programmers and Support team I have an application in CRM, which adds Contacts at the Zoho CRM. now i create an another form which used to sent emails in Creator to CRM Contacts. So after sent a mail that email should be listed automatically at the Zoho CRM under the particular contact, in which the Contact mail is sent. i am follows following post: https://kbase.creator.zoho.com/crm/create-crm-lead-and-add-note with the help of above post i do following at my form >> add >>
Fetch a score
Hello, I am working on retrieving a score based on a chioce that a user makes from a drop down. I have the following forms: Policy Write-Up (Database) - This is where I have a database of all the possible policy violations and a point number attached to each. The fields are: Policy Number Policy Violation Policy Rule Points Write-Up Data - This is a formula that combines Policy Number + Policy Violation + Policy Rule Write-Up - This is where I want the user to be able to enter in an employee
Next Page