Is it possible to add 2 sums from 2 apps?
I am converting from an old app to a new app. I have a report which currently pulls information from the new app and the old app and then I just have a "+" sign in the middle. Is there a way to make Zoho do the math from 2 separate apps? The code is listed
Display selected subform records on HTML view
Hello, I'm having trouble on importing data from a subform to a HTML view. I want to display each row of the current subform into an HTML view. On sucess I pass the ID of the current subform this way ReciboID = input.ID.toString(); openUrl("https://creator.zoho.com/29david.montero29/gestion-escuela/#View:Prueba_3?IDactual=" + ReciboID + "", "Same window"); Then I fetch the record.... <%{ IDnum = input.IDactual.toLong(); Recibo = Escuela [ID == IDnum];%> Inside Escuela is the subform LINEAS_ESCUELA.
How to add image to the forms to have better visual design?
Hello, I need it is very important to add some icons or photo in the forms when we add fields. I couldn't find that option. the image field is only for uploading to database not for visual design. thanks TRANSLATE with x English Arabic Hebrew Polish
Subform : Recall existing data into subform - not create new data
My use case is that I have a multi-select field where I want users to be able to choose locations that already exist and bring them into a subform to edit. The subform is linked - not an inline one. The multi-select field and the subform are the "locations"
Run Creator Custom Function in Flow?
Is it possible to run a custom creator function from Zoho Flow?
Basic Budget Application
I am trying to determine if Creator will work for a basic budgeting application that I am wanting to put together. I would like to have a form that I can use simular to a check registry, a form where I can create a monthly budget with categories, and some views that show actual versus budgeted totals. I can not figure out two things: 1. How to have a running balance for the form that I want to use like a check registry. For example: Date Payee Amount Balance Category 11/21/06 Wal-Mart 25.00 100.00
Zoho Creator Lookup field wrong data type
Hi I'm trying to get to grips with fetching records in creator and have created 2 forms: Visitors (Name, Email) Appointments (Date, Visitor, Email) The Visitior field in Appointments is a lookup field related to the visitors form. I've tried to define an action in script builder to take the name displayed from the lookup and fetch the email address of that visitor. The problem is that the name field in Visitors is a single-line text field whereas the Visitor lookup field is being shown as numeric.
How to push image URL in Image field of Zoho Creator using custom function/deluge script or creator API?
Hi, I want to add an image to Image field in Zoho Creator by giving URL of image into Image field using custom function or deluge script. I tried to give URL of an image in Image field in Zoho Creator's record using the following code: insert into Testing [ Added_User = zoho.loginuser Name = "Test Record" Email = "MyEmailAddress" Image = "http://cdn.wonderfulengineering.com/wp-content/uploads/2016/01/nature-wallpapers-38-798x350.jpg" ] But it is not adding image to Image field.
Custom Button in Quick View of Report should be Available for Mobile View
Hi @Zoho Team, I believe having a button available on quick view of report for Mobile app is very important. I understand that having it inside Detailed view or adding into action buttons does solve the problem but from the user journey point of view
Zoho Creator Should have Folder Management Capability
Hi @Zoho Team I think once of the major things that Zoho creator lacks is the Folder management capability as all major ERPs and CRMs do come with resource management section but there is no specific resource management section in creator which I believe
"Convert" a blank subform into a regular (sub) form
Other than manually exporting, importing, and linking, is there a faster and easier way to "convert" a blank subform to a regular form (to be used as a subform)?
Unconditional transition is not working
Hi, I have a new transition called Merchant cancelled In my dev environment I have 3 records in Merchant terminated stage 2 of them were moved to this stage before that new transition was configured, one after and only for that one record it is possible
Please Fix Error Message Locators for 'IF' statements
As you can see from my screenshot attached, the error message says there is an "Error at line number: 1". This is incorrect. The error ACTUALLY exists on line 82. I've noticed this miscommunication often occurs when there are 'IF' statements involved. Whenever
How to set variable for Name field of zoho form
I want to set variable for Name filed of zoho form. Unable to set that getting a problem .Please give solution for this. Its urgent.
Only show report records using search
Hi, I have a singular report and a page that I have built. On the page I have a search field. I have set this up so I create a unique passcode field in my users form and then in the search on my page you use that code and it open the singular report and
Finding duplicate entries
Hi, I'd like to know if there is a simple way to identify duplicate entries in a table or database. I looked through the scripts help page but didn't see anything. I'm basically going to be compiling an email list and want to be able to quickly check the list for duplicates. Thank you for your help Love your service!
Subform export not filtering to selected fields
Hi, My subform xls export shows all of the fields in the subform instead of the values I selected to display. How can I show only the fields I selected?
How to get import option
I am a shared user, how can i get the import option, for uploading the data. Regards Ankur
Change currency type of currency textbox dynamically
Hello group I have a dropdown box on a form populated with country names from another form. When the user selects a country, I would like to change the currency type of a another currency textbox to show the corresponding currency type associated with the country. Is this possible? Appreciate if you could you give me an example of how to do this! Regards Martin
Change subform name on Creator export report
Hi. Is it possible to change the name of the subform tab? Ex. standard ZC_SUBFORM_90_Report to ZC_SUBFORM_Hotels_Report.
combine 2 fields into 1
Hello, Is there a way to combine/merge 2 different fileds into 1 ? example: 1 field - first name: John 2 field - Last name: Lennon I want to get 3 field automatically : John Lennon what is the formula i should use? Thanks, Itai B.
Creator new user no access
Hello, We created a new user with a completely new created e-mail. Impossible to give access for Creator use. even after an invitation its an error. How is that possible if we didn't reach our limit of paid accounts per month ???? See attachment. There
Report - Grouping and Sum
I have two columns, one is product and another is sum. I want to group product (show one row each product) and sum on other other column. Right now it will still have all rows but grouped by header.
The email cannot be added as a Customer because it needs to be added as a User
Hi, We are experiencing issues with adding another portal user. The portal user has the same domain as 22 other users but we cannot seem to add anymore portal users with the same domain. "The email cannot be added as a Customer because it needs to be added as a User. Please contact support@zohocreator.com for further assistance."
Can not filter List View via ID
@ZOHO Creator Support Team: While doing some experiments, I found that while I can do this ... http://creator.zoho.com/scriptedlogic/myApp/#View:myListView?Country=Kenya ... and get ZOHO Creator to display the View with just the record with matching Country field value ... I can not do ... http://creator.zoho.com/scriptedlogic/myApp/#View:myListView?ID=xxxx9000000123yyyy ... xxxx and yyy have been redacted here for privacy reasons ... ZOHO Creator returns ALL records in myView. Was this always so
URL invoke Error
Hi there, I need help. I'm getting an error. "Given index 0 is greater than the list size Line:(18)" Essentially I'm trying to Get a user, and then update the same user. The list is to iterate through a list of users I have. Help appreciated! payload
Learn Try Catch
Hi, I am just starting learning Script Deluge. I am taking the course "Learn Deluge" and i got stock here. can somebody help me?
Possible Use Case for Zoho Creator: eBook App / Offline Website?
Hi Zoho Creator Team, Please confirm if you have any resources describing how Zoho Creator could be used to create a book app / offline website? We have a book website (www.agribook.co.za) which we would like farmers to be able to access while offline,
Zoho Creator lookup field data transfered to Zoho Forms form
Hi guys, Struggling with this but I have a form in Zoho creator with a lookup to the ID which works great within the app. Trouble is I need my form to be a bit more child friendly and Zoho Forms offers this in the picture options that it has. I have now
Amount Display
Hi, Is it possible format amount display like "1,123,123.00" rather "1123123.00". It is hard to recognize Long number. Thanks for your great work. Ming zhumingca
Can you format Formula field results at all?
I have a formula field that divides one number by another and produces a percentage. Except it displays as a decimal i.e. 0.666 instead of 66%. Is it possible to apply formatting to the result to make it display as a percentage? I have seen an old post
Form as PopUp Box
I am having a difficult time successfully displaying a Form in a popup window. Deluge Script - On load: thisapp.PopUpForms.PopUpAddEvent(); Function: void PopUpForms.PopUpAddEvent() { openUrl("#Form:Add_Event","popup window","height=600,width=1200"); } Problems/Issues: The purpose here is to allow our Users to submit an "Add Event" form while on another page/form/etc. The popup displays with the code above, however the background/main window also changes to the "Add Event" form and the popup
Autonumber subform rows through deluge script
Hi all, Ive been trying to create a numbering system for each new subform row added. The problem ive come to is on add row, it doesnt show show the value Im trying to display Here is the code ive tried: on Add row: linecount = 1; for each item in Items_Ordered { //This will autonumber each new line added in items ordered items.Line_Number = linecount; linecount = (linecount + 1); } The output I'm looking for is to have each new row added contain a row number, starting at 1 and increasing
Is it best practice to use the exact same if statement in two different places?
I'm using the following if statement: // Display Writer Rate field if Position contains "Writer" and Type is "Freelancer"; hide otherwise. hide Writer_Rate; if ((input.Type == "Freelancer") && input.Position_s.contains("Writer")) { show Writer_Rate; } I've included this statement within the On User Input section of two different fields: Position and Type. Is that best practice? It feels messy to me (e.g. if you wanted to amend the if statement, you'd need to remember to do it in the two different
How to hide/show a section in Zoho creator 5?
Ho can I hide/show an entire section in Zoho creator 5. I searched for the solution but every says go to Application Settings<Sections. But I don't find sections page in settings. Here's how my section page looks.
Possible to Filter a Zoho CRM Lookup Field
Is it possible to filter a CRM lookup field onload? If not possible, is their a good workaround? I'm basically trying to pull all cases with status of "New" from the CRM so a user can select one for updating. We have about 5000 cases but only ever have
How to update conditional dropdown in a deluge script?
I have a conditional dropdown in my forms (Single select drop down buttons configured as described here: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html) and need to be able select their values in a script. Script is called
Facing issue on file upload using Creator api v2
When I'm trying to upload a file using creator api that time I'm getting authentication error, but when I have tried to create new records within creator using api that time record creating successfully and the authentication error is not showing. Please
Form to search a lookup and then open another form
Hi all, Coming from an Access background here so a few kinks to iron out. I have an application with Form 1 that is: Initials (Autocapitalise) Postcode (Checks details are correct) UniqueID (Initials+Postcode) updated on form submission I then have Form
Comments on records
1. Can a user write and view comments on records on mobile app ? 2. When writing new comments is there a way to use them and send email notifications ? 3. Can someone atach file in comments ?
Next Page