How can I see in a field lookup part of the records?
Good afternoon, How can I see in a field lookup part of the records? In the form there are some previous fields that indicate a specific customer. In the table "Clients" I have a subform of the table "Addresses" What I intend is that in the lookup only appear the addresses that belong to the client previously selected in another lookup. Thank you.
XML post api for sending sms?
Hi, I'm beginner of deluge script. I need simple connection between sms service and zoho, In my app telephone number and message will be written and with the send button push, relevant infos must send with post api parameters. Here is the sample xml tree: <SMS> <server> <user>[username]</user> <password>[password]</password> </server> <message> <subject>SUBJECT</subject> <text>SMS MESSAGE</text> <numbers>1238970875</numbers> <date>YYYY-MM-DD HH:MM:SS</date> </message> <blacklist>true</blacklist>
Conditionally Send Email
Hi, I want to be able to send an email automatically based on the status of a dropdown. If the user chooses 'Request' from the dropdown it sends an email (and sets the status of the dropdown to 'Awaiting' however I haven't got to that stage yet) if(REF_Status == "Request") { sendmail [ from: me@me.com to: you@you.com subject: This is an email message: Hello ] } I keep getting an error when trying to put the sendmail function in the if statement? What am I doing wrong?
Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder)
We developing a application like Inventory Management using creator from this we have an issue Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder). we have to choose the field type=Submit , then only we write the code on submit button onclick action. so please give us a solution to solve this issue.
Deleting entries in lookup form
If an entry in a form is used in another form as a lookup field, I can still delete the original entry in the original form. This is counter-intuitive or is a bug.... How can something that's used in another form be deleted itself? Then this invalidates the reference. Someone shed some light on this? Thanks.
Is it possible to pass an unsubmitted form to a function for processing?
I am in the process of streamlining code in an app I'm enhancing by creating functions for large sections with repeated code. I wondered if it is possible to send an un-submitted form to a function for doing validation, setting field values and using actions.
how to send the current form as parameter to a function
Hi there, I have a form where several fields need to be recalculated everytime several other fields are changed. Thus I would like to have a function that will take the current form as a parameter and gather input data, recalculate and re-populate fields with new result. However I cant figure out how to send the current form as a parameter - I can send the datatable so I can get access to the input fields, but I cannot change the value of existing fields through the function ?! Can anyone point me
Event Production Management Application
I am working on an application for an event production management company, and am trying to figure out a solution for being able to select a project and have all report views change to the current project. I was hoping I would be able to set up a criteria function in each Report that would filter fields based on a current project variable, but haven't had success. I found the Global Variables Sample Application, but am not seeing how it would be possible for reports to call for functions. Does
creating interface search in details
every thing in zoho u can learn it by reading or videos except Search Interface it is so complex even the support page for search interface is more difficult to understand it , please dose any one have step by step videos or articles explain that in details ??
Purpose of "On Update" in field actions
Hi, Good Morning.In Zoho Creator, For every field we have two field actions such as On User Input and On Update. When I changed any field value in edit mode,The script in on user input had worked. Could you please explain the purpose of On Update in field actions. Thank you. Have a great day!
Unable to Save due to (Data Access operations are not supported for stateless form)
Hi I'm Kishore Kumar as Developer in Sixty One Steps Advertising Private Limited. We developing a application like Inventory Management using creator from this we have an issue under workflow -> Form Actions -> Submit -> On Click. we unable to save the code , getting this error (Data Access operations are not supported for stateless form), so please give us a solution to solve this issue.
How do I make a text statement that users must accept before the form can be submitted e.g. a disclaimer for liability?
Hi I'm making a form that can be filled in by my clients to record their information. In my line of work, my industry regulator requires that clients be informed about costs, and the nature and limits of the work that can be undertaken. The text is about 500 words and they must read it and agree to the terms before I can start work for them. How do I create a text statement that is coupled with an accept or decline button.
Offline data entry
Hi everyone! Does Zoho Creator have an offline mobile data entry app? Android or IOS? If yes, how effective is it? Does it have skip logic (dependent questions)? Any major complaints? Thanks in advance for your responses.
Simulate "submit"
Hi I need to simulate "submit" for all entries in a form. How can this be done with deluge script? Some fields only populate on "edit success" so it's tedious to do them one by one manually.
Any way to know where all a certain deluge field us used?
Is there any way to know in creator where all a certain Deluge field is reffered to? e.g. I've a field "Target_Dispatch_Date_from_Factory" This was a date entry field but I am planning to change it to an autocalculated formula based on another field. But before I do this I want to make sure if changing this is going to break anything else (e.g. forms/ reports) that access this field. Any way to do this?
HTML Page - Display values from Subforms (product sales for each product)
Hi there, I have a sales_Form. Inside sales_Form I have a sub_Form where I have a product_Lookup_Field and product_subTotal. I need to display a table with "Product Name" and "sub total" for a specific period. I have tried different ways to solve it but obviously its not enough...! This is the best I've got so far...(I am changing the names to make it easy for you to understand). This solutions gives me the product name on a new td but the sum displays the sum of all products in this specific subform.
Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder)
We developing a application like Inventory Management using creator from this we have an issue Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder). we have to choose the field type=Submit , then only we write the code on submit button onclick action. so please give us a solution to solve this issue.
My Automation Section has vanished?!
The automation section of several of my forms has just vanished?!? Help please!! This is 20+ hours of work that is just gone?!
Can't Cancel Edit After Functionality Based URL
I have been exploring this issue with support, but they do not have a solution. Using HTML, I have turned an entry in my Report into a functionality based URL to open a specific record for editing. Clicking on Submit does what is expected, but the Cancel button does not work. Has anyone encountered this and come up with a solution?
eMAIL on Add
Whenever I add an entry into a form, two emails got sent. One is from the "on add" script/event, and the other? Where is that from? I think I configured it myself but forgot where to turn it off. Thanks.
Update Field on Other app ?
Hi, I have 2 apps one is QAQI App and other is Sales App in QAQI app i have form which is EMS form in that i have field Account which is lookup from Account form which is from sales app i want when in ems form i select account field and if any value added in Call dispatcher name field then it should update in Account form field call dispatcher name which is on other app in sales app . Let me know any function ,script. Thanks
Customer Portal Customization
Hi Zoho, Please - add an option to edit the customer portal. Fonts, colors, making it responsive... It's 99$ per month - please develop the options available there. Thanks Ravid
Zoho creator offline in UK
Hi, I'm getting a 500 'Something's not right...' page when selecting apps and zoho creator since approx. 15:00 GMT. Has anyone else got this problem? Thanks
Show/Hide Fields
Hi, I'm trying to show/hide fields based on the status of a dropdown. I've created a test form with the following fields.... Dropdown Items 1 Items 2 Items 3 Field 1a Field 1b Field 1c Field 2a Field 2b Field 2c Field 3a Field 3b Field 3c I'm trying to use a workflow to only show fields 1a,b,c when Items 1 is selected, fields 2a,b,c when items 2 is selected and fields 3a,b,c when items 3 is selected but I can't seem to get it to work. Ideally I will be using this
FILTER LOOKUP
HOW CAN I FILTER THE RECORDS OF A LOOKUP BASED ON THE RESULT OF ANOTHER LOOKUP OF THE FORM?
Support Traditional Chinese?
Hi, dear Zoho Creator developers Will you support Traditional Chinese in the near future? I noticed that Simplified Chinese has been supported for a while, but Traditional Chinese is still not supported now. If you plan to support Traditional Chinese, and just can't find someone to do that for you, I will be very happy if I can help. Best Regards, Traditional Chinese user Pegasus Roe
SOLVED: Three forms, tryign to auto populate third form using values of first form
I have three forms Parent Process, Process and Process Task Parent Process Form Field: Title Type: Single line of text Process Form Field: Title Type: Single line of text Field: Parent Process Type: Multi Select Lookup based on Parent Process Title Process Task Form Field: Title Type: Single line of text Field: Process Type: Single Select Lookup based on Process Title Field: Parent Process Type: Multi-Line text. Values fetched based on the selection made in the Process field. The script to perform
Is it possible to display an image (siganature) from another form as an image in a form?
I am building a form where the user will collect information form a registered user in the app. I would like to have the user´s registered siganture shown in the form in order to compare with the signature collected at the time the form is filled.
problem with link
hi, what's wrong with this code? it says "link not found" if(input.Candidato != null) { //populate field input.plain = "<a href='https://app.zohocreator.com/" + zoho.appuri + "/#Form:Calendario_Form_Link_Name?recLinkID=" + input.Candidato + "&viewLinkName=Elenco_Contatti_View_Report_Link_Name&zc_LoadIn=dialog'>Open Record</a>"; show plain; } else { hide plain; }
postUrl issue. 8 days have passed.
Dear Zoho CRM Team, We've had enough with that. I reported a major issue with your postUrl() deluge script function. It doesn't work correctly because never sends "Content-length" header nowadays (but it must do that). ALL our workflows do not work due to this issue. We can't do ANYTHING. We lost money and users. 8 days have passed. I had chats with you every days, sometimes 3-4 times per day. In each chat you promised that i would be contacted soon. You NEVER did that. You call that "Enterprise"
Display a field list from all records to aid in data entry to prevent duplicates
I have an "Add new customer" form with a Single Line text input field to get the customer name but to prevent users from accidentally adding the same customer which existed already I want to show them a list of existing customers from the same form. What's a good way of doing that. I tried a formula but that only refers to the current customer. I want a list of all customers already in the db to be displayed maybe next to the entry field. Thoughts?
Can I highlight a field to indicate out of range numeric inputs?
I want to indicate an out of range numeric input on the form to the user by (say) putting a red box or highlighting it in some way. Is this possible in Zoho creator? e.g. say the form is a quality control form and if a parameter is greater than 10 I will flag it. Note, I know about alert and cancel submit. That's not what I want. The user should only be gently nudged not that the form entry should be prohibited.
Criteria involving Lookup List of BigInt
Hi, I have a form (Class_Rooms)with one of the lookup fields being a list of Students ID (BigInt). How does set a criteria for Class_Rooms where the list contains a particular student ID. This is what i wrote for each Class_Records in Class_Rooms [List_of_Students.contains(Student.iD)] { } But I've been getting the following error. Error at line number : -1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Script to edit all form names?
I have a collection of applications, each with several form names containing the string "easy": EasyPlus EasyBall etc... I'm wondering if there is some way (using a function or otherwise), to loop through all the form names in an application and replace part of the form name; in this case, each "easy" to "busy." So upon execute, the names of the forms above would change to: BusyPlus BusyBall etc... Thanks,
Using New ZOHO CURL REST APIs in Creator
Hello, this Post will show the way i use to PUSH, GET, UPDATE and so on, Data from the Creator Deluge Script to for example the New Zoho DESK API via PHP-Script. My Deluge code example to add a Ticket in Zoho Desk: urltwo = "http://YourURL.com/phpfile.php?value=60¶m=" + TicketID + "&string="; StringRec = "{ \"secondsSpent\" : \"0\", \"executedTime\" : \"" + thisapp.GetDataFromDesk.TimeStringForTimeEntry() + "\", \"customFields\" : { \"TaskID\" :
Error in deluge behaviour: Currency type
Hi guys! It seems there was an update in Zoho deluge scripting, and now we get a error with Currency type field: If I use Currency type field as a float type in expression, it works well. If I try to send it as a float parameter to function, the function get "null" value instead. Examples: Contract.Amount is a form field of Currency type y = Contract.Amount + 1000.00; - works well, and return the amount increased by 1000, as a float variable. Now, we define function with float argument: string
Filter Aggregate Records by Month?
I'm trying to use criteria to filter records by month, e.g.: Date_Field.getMonth() == zoho.currentdate.getMonth() or Date_Field.getMonth() == zoho.currentdate.subMonth(1).getMonth() However, it doesn't seem like I can use a function on the left side of this equation. If that's the case, how is it possible more me to aggregate all the records from a certain month? Thanks!:)
We need the application environment with our own logo both in android and IOS
Hi I'm Kishore Kumar.S as developer in Sixty One Steps Advertising Private Limited, we have been using the zoho products around 7 to 8 months as of now We developing web applications through Zoho creator for our clients and we want mobile application with our logo as both in android and IOS platform is it possible if, please let us know the steps. as already we know about zoho creator portal application (it is very simple and compare to mobile application in play store this is difficult) we want
Number of rows per page
I found that I need to have more than 200 rows to work with some times in a Zoho Creator Report. Can you guys increase the 200-lines limit? Thanks.
open a record from a form
hi, as you can see in this screeen, https://photos.app.goo.gl/qDVQPK4Dpblm0rqj1 in my form "nuovo compito" (that means new task) i have a "candidato" lookup field. this field take value from another form (applicants). may i find a way to open, maybe using the url field, the relative record of "applicants"? obviously setting the url after input of "candidato" field thx
Next Page