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
from subform entry - link to mainform
hi! there is mainform (contacts) and subform (purchases) one contact has many purchases - in one mainform's entry there are many entries inside subform after adding entry to subform - we can view such entries in subform's report how from subform entry can view to which contact they correspond? example 1) open subform entry 2) click on link inside this entry 3) opens corresponding mainform's entry
how to add entry to subform (via CSV) and associate this entry with mainform?
hi! there is mainform with subform how to add entry to subform via import (CSV) and automatically associate this entry with mainform's entry ?
Auto-increment
Hi, I would like to assign a unique Alpha numerical value to each record. The "Alpha" would be the first letter of a field in the form. The Numerical will be increment + 1 Thanks for helping me out! Brian
Lookup with multiple fields
Is it possible to create a lookup that displays more than one field of information, For example if I had a table of jobs with a lookup to select a client, could the lookup display more than one field from the client table such as client_no, name, postcode. Thanks.
What is the fastest way to delete 17,000 records?
Deleting 17,000 records in groups of 200 is not working. Is there a faster way?
About Rebranding Again
Good afternoon. My question is: Is there any way to hide alerts, marketing messages , invitations to seminars etc. on applications made with ZOHO creator . I am a freelance programmer I'm starting to work with ZOHO seriously , I upgraded my account to enterprise , and I would like to offer my work without customers know what my methodology and what my economic gains , since it could easily deduce at your price list. Is there an alternative to further consider ZOHO creator as my work tool ? I have
Powershell REST API
Hi! I'm using Powershell to do REST operations with various online services, such as Dropbox etc and it works fine. Now I'm trying Zoho Creator but with no success. Does anybody have a general Powershell script that would for listing applications and return the result in json format? Preferably I would simply replace the token-code with mine to get the concept. Any input would be appreciated. I have looked at all the examples available and tested for several hours but I've run into a dead end...
Function to create multiple tests
Can I create multiple choice tests by using Zoho Creator or any Zoho utility? If yes, what modules can I use? Can you please give me detailed instructions? Thank you very much!
Confirm before deletion in subform
I just clicked the "X" in a subform row by mistake. Is it possible to ask "Really?" before it vanishes forever?
Sum of formulas (within subform)
Hi, I have a timesheet subform, with an "Hours worked" field, an "Overtime" field and a "Total" formula field that combines the two values. In the main form, I want to include a grand total field that would be the sum of the "Total" formula for each row. I've achieved this with "Hours worked" only, but not the sum of "Hours worked" and "Overtime". input.Total_Amount = input.Total_Amount + row.Hours_Worked; That works. (in Main Form>Subform>Hours_Worked>On User Input) input.Total_Amount = input.Total_Amount
Updating a lookup field issue
Hi All, I have a subform that has a single select lookup that needs to be replaced with a multiple select lookup. Both lookups exist now in the form and access the same source "Add_Labels > Labels_Description". Before deleting the single select lookup field, I need to copy the single select data to the multi-select lookup field so I've created a temporay form and script to process make this change - and this is where I'm stuck. I appreciate that the mult-select lookup requires the record ID so I've
Update Subform with field from Parent Form
I am looking for deluge script to update multiple subform entries with the date of the parent form. The purpose of this is to allow me to run more detailed pivot reports with the subform data.
Schedule export of data
Hello - Is there a way to schedule the export of the data from a Zoho Creator application to an external server? Thanks Anil
Next Page