Add Record to Form using another Stateless Form
I am trying to add a record to my form entitled Task, using a stateless form entitle Web Task. I understand I need to use a deluge script. I have found the script builder and the add record function, but I don't know what the next step is. The fields that I want to populate from Web Task to Task are Task name, Property, Location, Suite, Type of Problem and Notes. All of those fields are lookups to other their own forms, except Task Name and Notes. I have found various examples and such, but
created a new view from a view, but it shows in the Forms tab
I was displaying a view and created a new one, but it turned up in the Forms tab along with all the forms I have. I suppose it should have turned up in the Views tab. Can anyone help ? Thanks
Once Form has been completed...send to printer?
For the current application when a Form A is completed, I need an option to send to Print, and/or PDF, or a Que?Any ideas on how to accomplish this? Thanks in Advance! Paul
Is it just me or does the images not match the tutorial on this doc?
I have read and re read this tutorial.... ....For example, we add the Deluge statement Info to display a given number. Select Save Script to save the function.... Yet the image says---> Info "hello" + input.name; (Not to mention you have to zoom 4 times just to see the image) This is very frustrating when self teaching... https://www.zoho.com/creator/newhelp/script/defining-a-function.html
statement if else not working
I´ve done some tests, but couldn´t find out why, in the if-else statement below, the contents "123456789" get stuck in the field "MatrAgente" and cannot be changed on the form. Follows the code (it is on the "on user input" action for the "MatrAgente" field) if ( ((input.MatrAgente != "") && input.MatrAgente.matches("[0-9]{9}")) ) { MatrAgente = "123456789" ; } else { alert "else"; }
Limit access top view
I have a view/report that I would like either the Added_User to have access to it OR a special group of users (they can be developers) to have access to it. In the criteria I'm able to set the first condition (Added_User = zoho.loginuser), but how can I include the second "OR" condition? Any ideas? is there a way to do it without creating two different views and use the Share method. Thank you
Tasks List Table with Link to Forms and Records
I am trying out Creator and I want to create a task list for employees that has a field which links to a form and pulls up a specific record for the employee to update. How can I do that? Example Table: Project Step Task Name Form Link (with new record or dynamic new record) Status Next Step Approved Next Step Rejected Thanks in advance for your help. Employee
how to move cursor after Alert message is displayed
I thought, after an Alert message was displayed, that the cursor would stay in the field associated with the Alert. However, it doesn´t seem to go anywhere. My question is: Is it possible to control the cursor´s position on the screen on a form ? Thanks
Error occured please contact application owner
Hi Zoho, When I submit request to my form and show me this error ; "Error occured please contact application owner" Actually, click submit request then mail come to us, but this error not coming mail to us. I try to new user form sharing. But, doesn't help me. What we can do about it? Regards, Utku.
Error in execution
Dear all, Can anybody help me what is the meaning of this error? Error in executing For Each Record task Error in executing Set Variable task. Unable to update template variable total1 Error Evaluating NUMERIC expression: unable to perform the operation + over the operand 14,865,500 and null. the code worked before, and now it is not working. Please help. thank you. michael
Only the OLDEST record is being updated.
All, When running the script below the only record that is updated is the oldest record in the DB.What have I done wrong? if(input.Returned_to_ATC == "YES") { list = MWD_Eye_Calibration_Testing[Serial_Number == input.Serial_Number]; list.Returned_to_ATC="YES"; } Screen cap of unchanged data. Jason Rapp
Can I Duplicate a Project Complete With Milestones, Tasks etc. in Project Manager PLUS?
Hi everyone. Let's say I sell real estate properties and I want to use Project Manager PLUS to create a project for each property I'm selling. Can I create a sort of template or use an existing project as a template rather than having to create a project from scratch and manually adding all of the milestones, tasks and tasklists each time I'm selling a new property? I see the 'duplicate' and 'clone' functions inside of the program but neither seems to allow me to duplicate an existing project with
Reports: how to get rows for a multi-select field?
How may I get my Pivot report to accept my "Checkbox (multi-value)" field? The Report editor omits this field from the choices. I need the report to show a row for each of the values checked in this field. Thanks.
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
java.net.ConnectException: Connection refused error
This error is occurring after the creator cloud went offline. You can't given log a support call through the website because the same error occurs!!!!!!!!!!!
java.net.ConnectException: Connection refused error
This error is occurring after the creator cloud went offline. You can't given log a support call through the website because the same error occurs!!!!!!!!!!!
java.net.ConnectException: Connection refused error
This error is occurring after the creator cloud went offline. You can't given log a support call through the website because the same error occurs!!!!!!!!!!!
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
Create pivot table report based on two different forms .
Ok I have one app my employees work out of . They have a punch clock that they use to punch in and out of daily inside this app . I create a report daily showing the number of hours they worked . Time clock is based on "zoho.loginuserid" which is stored in All Employees View - Each employee add records daily to a different application - every time they add a new record there name is added via of lookup field related to same lookup as the time clock - I would like to create a single report that combines
links to demo don't work, and seems this help file is outdated
https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html when trying to report that its not helpful, the form itself cannot be submitted
Can not change the order of the form
I move the order in Edit Application but when I go input data the form is in a different order that I am unable to change
How to fetch a record from a different application?
Hello, I would like to fetch records from a separate application. Here is an example: ApplicationA: "Form1" has fields: Name1, Email1, Department1 ApplicationB: "Form2" has fields: Name2 and Email2 --> Name2 is my lookup field. --> When I lookup a name, I want Email2 to automatically populate from Application A field Email1. How do I do this? Please give me an example. I have gone through the forums and do not understand the explanations. Thank you.
Select Field for Cursor
It would be nice for data entry to be able to set where the cursor is (what field) when the form box opens.
How to list Forms in Application in a private application as a shared user through API?
Hi guys , I have a zoho account shared a application , i read [Zoho Creator REST API- List Forms in Application] and follow it ,but get error response below <?xml version="1.0" encoding="UTF-8" ?> <response><errorlist><error><code>2892</code><message>Specified application name is not valid.Provide a correct one.</message></error></errorlist></response> I use shared application name is link name,no display name. need your help!
input masks to fields
Is it possible to define input masks to fields ? For example, I have a field in my app that receives data like this: 99/999.999-8. Can I have the characters "/", "." and "-" shown on the field at the moment data will be typed ? Thanks.
Back up restore failed
I attempted to restore my assets application(https://creator.zoho.com/essistmgmt/assets/#) as dev_assets_test but The restore failed and I currently see this error message com.adventnet.appcreator.parser.schedulecustom.ParseException: Encountered " "}" "} "" at line 3, column 13. Was expecting one of: "to" ... "every" ... Can you please investigate?
Autoview created not by myself
Hi, When I view the ASSETS form at https://creator.zoho.com/essistmgmt/form/1650/edit/ and hover the mouse over the related views, I see Autoview_1373401184830_ASSET which I did not create. When I click on the view, I see the following message There is no such view in Zoho Creator How did the autoview get created in the first place and why is the link broken? Can you please investigate?
Convert number to alphanumeric
Hi, I have written my own custom function to convert a number to an alphanumeric code but am having some difficulty since my brackets keep moving and when I call my function, it does not always produce the intended result but the first time I ran it, it was fine. Does anyone know the best way to convert an number to base 36? eg 1=> 1 11 =>A 2000 => 1JK
Error occurred while saving the view
I am trying to save my viewhttps://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View and am getting the following error I got the error when I tried to set the INITIAL SERVICE AGREEMENT to not empty and then clicked on Save Changes. Can you please investigate?
Simulate "Convert" option
Greetings, zoho experts, I had automated the "convert to account, contact" option in zoho crm, because i am copying the information in two additional custom modules. The thing is i want to simulate all the actions in the convert button. I am talking about the "convert" button in the Leads module. When you click it it convert it to account and contact but also the lead module is disabled. How can i disabled the Lead module after I had copied the information? It's Urgent please help me! Best Regards,
user to only access to their own entries?
hello, I'm creating a database of leads from reps in different territories. I would like the database to contain leads for all reps but only allow each rep to see the leads they've entered (own). Do I do this with filters of some sort based on the user? many thanks!
Data Re-populate on another Form
I am new to deluge script and conditional statements as a whole. I am getting there but seem to be hung up a bit. (I have been working on this for 4+ hours) I want to populate the "client" data from Form_A into Form_B. I have set the "look up field as Client First Name, Client Last Name, Client Middle Initial." (as it relates to Form_A) Once selected I want address, services, and other data from Form_A to be pulled into Form_B. So I am attempting to build this with the scripting portion of Creator.
Max file size upload
What is the máximum file upload size for a paid account?? I can't upload a 6 MB file, and I need to upload some others 20 MB files. I thought that the restriction was only for free plans!!! I have a standard account. Regards, Luis
Returning BIGINTLIST from a function
I have a field in table A that is a multi-select lookup to table Y I want to convert the values in that field to a multi-select lookup to table Z and put them into a field in table B. Because this need happens several times, I'm trying to write a function to do this. I've written the function to return the result of the conversion. The function returns a value of type list. But when I try to assign the value returned by the function to the field in table B, the compiler says I need to have a value
Schedule in the database
Hello, Is it possible to add scheduling or aka email notification in Zoho Creator. Example if I wanted to create a database with action dates. When a date in the database is today send out an email automatically without having to log into zoho creator. Basically I need reminder emails when certain records with certain dates come up. Thanks. Iram
Unable to download files - pls help!!
Since yesterday customers are unable to download files that they have not uploaded even if the views are public/shared I am a paid customer and your support phones do not work - that s crazy! I have submitted tickets but no one answers - you are damaging my business Same link, same views but in some cases customers can download files and in others, they cant. What is happening? This was working til yesterday!!
Strange performance of one field in a form...
The application referred to consist several forms and several fields in them. All forms/ fields are all working normally, except this one - List of Schools (LS) This LS is linked (look-up) by a List View named "View Updates" with several linked other data source forms. The LS hold listing of school names, ex: Yesterday School Future Academy When I added data to the View Updates from the LS, it is automatically added with ...dash.. before the school name. Example: - Yesterday School . Other data are
Not displaying properly
The single text areas are not sizing as set in the form editor and the radio buttons are being displayed as dropdown lists. Both are being displayed properly in the editor but when the for is viewed normally in a web page or when the application is accessed from the editor it is all wrong.
Next Page