Posting to a web service using JSON
Hi I have a job to do for someone and it's a new area for me. Can someone help, or take the job over please? Background: Source data in a simple table in a Creator database. Records added manually or via CSV import User wants a button on a View or on a Creator form that can post to a web service, using JSON We have the web service URL and it uses Basic authentication, for which we have the credentials The JSON format has 4 parameters: { "requestId":4, "cleardocsOrderId":1000000462, "status":"registered",
Shedules Settings Issue in Zoho Creator
I'm using Zoho Creator and want to add rules to trigger an email notification whenever one of these criteria is met: 1. It's 7th day after the date recorded in death_date field, which is Date-Time type field 2. The 40th day, respectively 3. And one year past after that date I want the system to send reminders in form of email notification 2 days before those specified dates. I've created some schedules (see screenshot): But the Form and Field fields are inactive, so I can't edit them. And here is
Message Box function
Please provide a function to display a message box, ideally of the CSS later type rather than JS. EDIT: oops, I meant the "CSS layer type".
Making Groups of 5
Hello folks, I just joined zoho and started a creator app in hopes that it can help my online gaming guild quickly and efficiently create groups for certain events we have. I created a form and report already. The report has 13 columns. The first 3 are just text fields that will rarely ever change once entered. Columns 4 through 12 are number fields. Column 13 is a total of 4-12. This total represents the total number of an in game item that the player has in their possession. The next part of
Problems importing data
Hi, I´ve been trying to import a csv file several time, trying different configurations in excel for the columns, with no succes. the file consists of several number and currency columns. the problem is that in the same column there are numbers correctly imported and wrong numbers, I have no Idea what could be wrong. I am trying to import numbers like this: $ 40.767 some of them import properly, but in many rows I get numbers like this: $ 4.076.666.667 Any help will be appreciated
Help to enter A picture!!
I want to upload an image to an html page but for them it must be housed somewhere but that's what we do not know how to do, I 'm driving this new platform , thanks
Zoho creator is fantastic, Zoho Support sucks. (took 20 days to fix a report data issue causing by wrong email format)
Although I appreciate zoho creator product very much and have been used it for years. I have to say I had terrible experience with Zoho support for this ticket 11000574. There was the data issue in the report causing my major reports not working. The issue was created May 15, it was not solved until June 3 when I bring it up to the Live Chat Support and asking for an update. The cause of the problem is simple, in one specific record: Email was entered as : xxxxhotmail@.com, which caused report
iFrame Embed Show/Hide Not Working
Hi all. I am embedding one of my Zoho Creator App forms into my GoodBarber App. I have published the app and when I embed the iFrame code, the fields that I had set to "Hide On Load" all show up. Any help figuring this out would be greatly appreciated.
how to add 2 form data in another form or pages?
I want to add the Lead and Account Data into Another form or Pages in ZOHO Creator. can anyone guide me how to achieve this.
Updating checkbox values on user input
Hi Zoho, I have a checkbox field with 5 items in my form. I'd like to add an "Import all" option. I've added a "Import all" item to the checkbox list, and added the following script to the "checkbox field -> on user input" on the form script: if checkbox_field.contains("Import All")=true { checkbox_field.add("element01"); checkbox_field.add("element02"); checkbox_field.add("element03"); checkbox_field.add("element04"); checkbox_field.add("element05"); } if checkbox_field.contains("Import
Change Customer Portal URL
I cannot change my Customer Portal URL? Can someone help me?
Failed to add data
I am entering data via my forms and am getting a failed to add data error Application: https://creator.zoho.com/essistmgmt/assets When I close the form and resubmit the same information, sometimes it saves successfully after 3 attempts. Other times it works straight away. The forms are not behaving consistently. Forms where I have seen the error https://creator.zoho.com/essistmgmt/assets/#Form:TELCO_SERVICE_ORDER https://creator.zoho.com/essistmgmt/assets/#Form:CONTACTS https://creator.zoho.com/essistmgmt/assets/#Form:ASSET
Question regarding Advanced Display Field
Hello there again, I am new to the software but I am enjoying playing around with it, I was wondering if there was a reason as to why I cannot delete one of the fields on this form. The error message is as follows; "This field is referred as display fields in the following places. Please remove them and then delete this field." "Advanced Display Fields" "1.Customer Contact List - Asset Manager - Sales Order No." I can't seem to find the relationship, if that is indeed the problem. Thanks in advance
Fetch and update
Hi everyone, I have the following code, but it only updates the first record of Cost in Costings. I need all price.Cost records to be updated. Can anyone help? //Fetch all records from Costings that match the Item Number and store them in a variable price. price = Costings [Material.Description == input.Description]; //This might be the problem or the previous line of code. Should find a solution in order to update all records. At the moment it only updates one of the records (the first one).
Self-referencing forms
I am setting up a form field as a lookup to refer to the same form. I found it not possible/allowed.... Several years ago there was an example but I can't download/copy the app: https://help.zoho.com/portal/en/community/topic/self-referencing-tables Can anyone help? Thanks.
Is Zoho compatible with windows 10 and firefox 46.0.1?
I have been developing website software in zoho which worked on everything. Then upgraded it to windows 10 - explorer works but when on fire fox (46.0.1)when I sign on to the web site. no response. What can I do? Is there a compatibility issue? What should I do? My client is really upset. Thanks, Regards, Geeta
filter lookup
Hi Zoho Fans! I have a subform that has a dropdown field with some options and I also have a lookup field to a code catalogue, I would like that when the user choose an option in the dropdown the codes in the lookup field are filtered acording to the previous election. How can I do this? any help will be appreciated.
OnClik Action does not show calculation results on field
Hi I've a stateless form to calculate prices. I've created a button to calculate the price after user data submission. The script only makes some simple fetching and a simple calculation like input.price=p1+p2+p3 I verify that through Debug Info all the steps are well done through all steps, but the field input.price does not show the result (it continues with zero). For stateless forms in On Click action, is there any function to refresh/show/update or something the on screen fields in order to
Html Page Print and Pdf True
Good day, I create a Html page and I set the print and pdf = true on the header (code), I save the script but when I open the html page there are no option of pdf or print, I return to the html code and this part of the script disappear. I have another html page that works great. Code htmlpage Generate_DataSheet(equipcode) displayname = "Generate DataSheet" print = true pdf = true Best Regards,
Trying to follow a tutorial
I'm a raw newbie and am trying to follow the tutorial, https://www.zoho.com/creator/help/tutorials/advanced-app-building.html#create-app-using-subforms When I get to entering the scripts in Workflow, the Tut doesn't specify whether its the Order Form or the Products Form. I assumed order and it gives the error "Value 'Product' is not defined". If I enter the script the Product form it gives the error "Vale 'row' not defined". It's frustrating because I just can't seem to get past this. Any help would
New To Creator doing a Timesheet
I know this should be easy for me but I'm just getting my feet wet. I work for a consulting firm so we all have multiple projects that we work on daily and have to log the hours spent per project. Right now they are using an excel spreadsheet. I've set up the form and included a radio button that says "do you need to enter more time for another project" Y/N How do I set it up so if they say yes the need fields pop up again. Thank you in advance for your help.
Record Audit for Users from Customer Portal
Does Zoho creator support record audit for users who are from the "Customer Portal" when they edit a record?
Combining multiple reports into 1
Is there a way to combine multiple reports into 1 that will maintain the information per form?
Aggregate function in formula field
Hi, Are aggregate functions like sum, average etc supports in formula fields? It doesn't look like it. My "Customer" form has a one-to-many look up relationship with the "Order" form. I want to create a formula field to do : sum(Orders.Order_Total) to show how much order the customer has placed. Thanks
Pivot Table & Chart Problem
why the Report always need to regenerated ? Before regenerated always provide the wrong data. We are corporate user, the report accurate is very important for us. can you please solve the problem?
Need example of creating a request in Zoho Support from Zoho Creator
Does anybody have a good, working example of script that creates a Request (ticket) in Zoho Support from Zoho Creator? The Zoho Creator help documentation is not useful and its example is incomplete and not well-explained.
Error 500 every time
Hi, I was trying to get access to Creator and test it in conjunction with Zoho CRM, while I have trial access. But every time I get to the Creator's home page, Error 500 pops up. Please find the screenshot attached. I would appreciate if you let me know how to solve the problem.
Calculating weight loss/gain
Hi Zoho, We have two forms, a Members form with the members details which includes a field with their starting weight and a Class Register form where we select a member from the Members form and add their current weight. I want to add a field to the Class Register form that will give me the difference (loss/gain) from the starting weight on the Members form to the current weight on the Class Register form, for that particular member. Can't seem to get my head around how to do this... is it possible?
How to use the "search" property correctly when embedding forms
Hello just a pretext I spent a few hours trying to get this thing to work properly and officially there still isn't a data entry in the deluge documentation resources on how to use it so I'm making this to supplement that till they fix it. I got an email from zoho customer support which was nice and I got it to work right after. So don't worry I was already helped, but its still is kind of a problem that the deluge documentation isn't being updated in a timely manner. Onto the main course, if you
Fetch other form fields with wilcard
Hi I need to populate a stateles form with a previous stored data or stores the form data if it does not yet exists. The test I've made that works fine is the following on the stateless form: (final_form is the form to store data, but not to be used by user) ON LOAD: // present on screen the data already stored in db rec = final_form [number == input.number]; input.a = rec.aa; input.b = rec.bb; ON CLICK: rec = final_form [number == input.number]; if (rec.ID == null) { // if the record
Reading múltiple info from single input(csv)
Im working on a little project. Im reading a qrcode with this formar "name:your-name,age:99". The idea is take that values and pase to a variable so i can work with them, like calculate age of birth and send it too. Im reading that map can be usefull but dont know how read until the "," and the assign next value.
Look up fields
We use look up fields to multi-select Rooms from a Locations table and are filtered based upon a Site look up field in the same form. This works fine on first edit of the form but when we go back in to the form, we have to delete the Site value and re-select the Site (which deletes the Room data). What are we missing?
Is it possible for a contact to add colleagues in the Portal?
Hi all, My clients wishes to enrich his database to add more Contacts to his Accounts, Should we create a Customer Portal where the main Contact of the Account could create new contact persons? Or is there an easier way?. My question is whether this is supported in ZOHO Customer Portal? Can a Portal enabled contact manipulate (add) contacts for his own Account?
Customer Portal Invite Email lowercase name?
When signing up on our new customer portal all goes well. The issue we are experiencing is if I sign up as Firstname Lastname the invite emails sends Hello firstnamelastname, how would we modify this behavior to read Hello Firstname Lastname this is the editable line. Hello ${User.FULL_NAME}, Thanks
Form generating out of order?
Hi All, So I've got a form that, even though it is lined up how it needs to be while editing it in the form builder, it tends to be vastly mixed up once I actually go to view the application. It's done this a few times now, and I've tried cutting down on the amount of fields as well as moving the order around. It's also randomly shifting around the fields occasionally in the field builder. Any idea how to get around this/ what could be causing it?
openurl command should url encode passed url content ...
Hi: I have this command in the on Click section of my (test) Form ... thisURL = "#View:Test_HTML_View?name=" + input.Name + "&time=" + input.Time; openUrl(thisURL, "same window");When I run it with alphanumeric values entered in the Name and Time fields, everything goes according to plan ... the (test) HTML View is displayed ... and the correct values are passed to it. It even works when I enter a number of special characters ... like spaces < > ? . * @ ! " ; { } [ ] = ^ / ~ However, ZOHO Creator
update on duplicate
Hi. I am playing with a way to send reminders to my customers based on them choosing a number of days between them on a form. I have put a form on our website with compulsory name, email and days between reminders. My question is that the email is probably going to be the unique identifier and if they want to go back and change the days i would either end up with two entries. My question what is the best way of dealing with this. I would like them to just update existing info.
Insert record from form and then show Auto Number of new record in form
Hello, I want to create a new record (Stock1) On Success ( form form Orders) (I know how to do this), then return the Auto Number of the new record created (Stock1) and record it in the form (Orders). This does not have to be On Success, it could be On User Input from another field. How do I do this?
Feedback regardin fixing a user account glitch
Hello everyone, Just wanted to share the experience I had (and still have as there is no immediate fix) with Zoho Creator. I've trial the platform for about a year just to see in what way I can integrate it into our business. It was a long process and finally found some areas where this platform is more than the perfect fit. Everything worked fine and have completed an application demo to present to the business. Everything worked fine. Management was impressed on how fast the development was done
report criteria n days before?
I'm trying to set up a report that shows records where a Date field is before 14 days ago. I'm using Criteria: (Date Field)...Day - n days ago...14 but it's not working. Am I doing something wrong?
Next Page