Public form/record editing
Hello, I'm building an application in ZoHo creator. Now in the application someone can make an assignment for a supplier. After making an assignment the application sends an e-mail to the supplier with a link which opens the record in editing mode. The supplier should put his comment and whether he aggrees with the assignment in this record. He only has to fill in two fields. The supplier will not get his own login (user). The problem is when I open a public record in editing mode, I can change every
speed application
Hello, I'm making a functional design for building an application in Zoho. Now I'm wondering if the following effects the speed of the application: Amount of databases Amount of scripts Amount of records I really need to know this because if these do effect the speed of Zoho Creator I have to think about combining some databases. This is not something I prefer. I've asked this question serveral times on the support desk and I tried to contact the support center by telephone, but I doen't get any
Stateless Form Not Updating Correct Record
I have a simple test application where I click on my custom action button displayed for each record. This custom action lunches a stateless form that contains a drop down menu to make a selection. Upon clicking submit on the stateless form a new record is created instead of updating the record that was selected from the custom action button. It looks like the custom action is not being properly being tied to the record where the custom action was selected. Can someone offer some assistance? - Thank
How to aggregate or concatenate text field content in multiple records
Review of Book A , Book B etc with a varying number of reveiwers. Records are grouped under Book A, Book B etc Reviewer 1 enters a record with a Review Field and submits: "A very good description". Reviewer 2 enters a record and submits "I enjoyed the plot analysis" Review 3 enters a record and submits " Yes it was suspenseful" How can i combine all the comments into a single review commentary of Book A so that it reads: A very good description I enjoyed the plot analysis Yes it was suspenseful
Creator with Google Analytics Web Tracking
Can we use Google Analytics Web Tracking in Zoho Creator? We would like to measure how users interact with our content and marketing initiatives in Zoho Creator. Thanks.
Number Formatting
Is there no support for spaces for thousands units in regular number fields? It's quite basic...
How delete a row from another form
I need to delete a row for one of my tables but i do in other form whit de id
Error execute Post URL
Hi Helpper. I have one problem with method PostURL of Zoho, please help me soon. This is my issue. This is my code: ================================================================ string = "{\"listObject\":["; for each form in forms { // Set make profile date == current date form.make_date = zoho.currentdate; // Create string to send to MyAPP string = string + "{"; string = string + "\"fileContents\":\"" + form.file_upload + "\","; string
How to add a message on Note/ Rich Text field
Hi, What I am looking for is that I would like to add a message on Note/Rich Text field. So user will have idea what information he should put in the field. You can see below screenshot what I am looking in the Note field where it is the multiselect field in creator.Here you can see there is a message "Select multiple Values". I would like to have the same in the Note filed but different message. Thanks for your help. Arfater.
Update successive lookup fields based on previous input.
HI, I have a form which has several fields.But there are two lookup fields which are looked up from same field Fips code like Fips-01 and Fips-02. you can see below screenshot . What I am looking for that I want to update the Fips-02 field on User input of Fips-01 . Say if user enters the value - 1001 in Fips-01 then this value should not appear in the Fips-02 . So finally in the Fips-02 should have only 1003,1005,1007 . It is possible to do that in creator ? Arfater.
How to update lookup field when using the api?
I'm trying to upload data using rest/json api and having trouble getting linking between forms with a lookup field. It is my understanding that I need to have the ID of the parent record to put into the lookup field. Can someone please elaborate on this? I think I may have misunderstood something. Any help appreciated. Thanks!
Order Management App rounding prices
I have started using the order management app that is provided by Zoho. I have made some minor changes to field names, but nothing major. I noticed that it is excluding my .99 from all of my pricing that I have entered for products. So the products are entered as 34.99 and it shows that correctly. But the add products field of an order entry brings in the price as 35 It comes in from the Product Subform but I cant find anything that is telling it to round up.
Connecting Zoho Creator with Zendesk
Hello! I'm in the process of testing itduzzit with one of my Zoho Creator apps and a Zendesk account I have. Basically, I will update a ticket in Zendesk when a record is created in the Zoho Creator app form and update the ticket in Zendesk when a record is updated in the Zoho Creator app form. I did some searching on itduzzit and I found some questions posted on this subject but no answers. I'm stuck trying to create an itduzzit connection to my Zoho Creator account. When I follow the steps
Limit the Aggregate in grouped records
AddressABC Record 1 $20 Record 2 $30 Record 3 $20 AddressXYZ Record 1 $40 Record 2 $10 Record 3 $20 Using the Aggregate criteria in script builder how do I return the aggregate of a specific address. For example the aggregate for Address xyz as $70. When I try to limit the records by the ID = ID i am still getting $140 The report is from a form where Address is a lookup field pointing to the Address Table.
Can't see more option to file upload
Hi, can anyone please tell me why I can't see more upload option like Zoho Docs into my Upload fields properties. as mentioned here https://www.zoho.com/creator/help/fields/uploading-files-and-images.html#Upload_Files Screenshot of my option:
How to import into a table in ZCreator from an external REST API source
Would be VERY glad if anyone could share a simple deluge script (.ds file) with an example of how to import data and put it in a table in ZCreator. The data are picked up from an external source with a REST API. In my case I want to import data from from Zoho Books, so if anyone have an example of how this is set up, it would be even greater. I know the REST API works, tested with curl, but need an .ds example to be able to get this into ZCreator. Thank you.
Error execute Post URL
Hi Helpper. I have one problem with method PostURL of Zoho, please help me soon. This is my issue. This is my code: ================================================================ string = "{\"listObject\":["; for each form in forms { // Set make profile date == current date form.make_date = zoho.currentdate; // Create string to send to MyAPP string = string + "{"; string = string + "\"fileContents\":\"" + form.file_upload + "\","; string
Customer Portal - Application Submission
Hi, I have an employee application program that is divided between seven forms (application part one, application part two, etc.). I need a customer (applicant) to log in and fill out each form sequentially. Each form goes to the next form upon submission of the preceding form. The applicants will login through the customer portal. I attempted to modify the permissions of the customer to restrict tab access, but I quickly figured out that it restricted access to all of the forms and defeated the
Hiding Fields on Embedded Forms
Hello, I have a service order form on which several fields are hidden, since only employees should make changes to them, not the customer who submits the request. Hiding the fields works fine in the application, but I also need these fields to be hidden when the form is embedded in an external website. Is there any way to do this? Thanks in advance.
Execute Custom Function on Selected Record
Hi, Is it possible to execute a custom function only selected records as like as below screenshot.I would like to select the specific records first and then execute a custom function to all selected records. Thanks Arfater.
Removing permissions
I have compiled a system for our web site and it works well except I would like to remove from the readers the option to do anything to the record (add, edit, print, delete etc). I cannot find a way of disabling them. This is the report that I would like to use https://creator.zoho.com/woodyham/group-leaders-report#Page:Reports1 Kevin Wallace
Import all data from MS Access (table,form,query,report)
Hi Guys, This website is good. How to import all data in Ms Access? Including Table, Query, Form, Report to Zoho? Thanks Adhie1973
Version history?
I accidentally overrided a function Ive created. When checking version history I can only see the changes made today, I need to retrieve the function as it was yesterday, is it possible ?? Thanks Walter
get Profile and Role in Deluge Script
Hi, Is there a way to get the role and profile of users using Deluge script ? Many thanks!
For each loop to Update a Field
Hi, I have a Report which have about 6,000 rows of data. Today I have added a new drop down field ( "Yes", "No") . So Now I want to update all records to "Yes". I know I can use Bulk edit to update the field. But I would like to create a custom function that will update in a single click. Below script I was trying but it is not working . void Test.AprovedToYes() { for each rec in MVPD_Subscriber_Calculation { rec.MD_Approved = "Yes"; } } Can anyone please help me Arfater.
ZOHO UI Is User friendly or not
i saw all your webapps that was cool stuffs but your UI is not user friendly ,and lots of stuff you are dumping on 1 page is there is any reason behind your UI or you will develop Rich UI,
Can forms in html page be placed side by side?
Here is the code for my html page: htmlpage THIS_WEEK_Timesheets_and_SMSs() displayname = "THIS WEEK Timesheets and SMSs" content <%{%> <table width="1200" border="0" align="center" cellpadding="1" cellspacing="1"> <tbody> <tr> <td> <div elname="zc-component" viewlinkname="THIS_WEEKs_Time_Sheets" parameters here </div> <div elname="zc-component" viewlinkname="TimeSheetTexts_Report" parameters here </div> <div elName='zc-component' formLinkName='Paid_Holiday_Amounts'
Not showing the form when editing from views
If the report has a criteria like this: " Added_User == zoho.loginuser" p ointing and clicking a record should open the form to enable users editing, but it only shows the "close" option. If I drop the criteria (ie selecting "all records") the form is opened.
No login required for dynamically generated html page
I'm creating an application that generates contracts. The admin can set parameters that determine what is displayed on a html page using the record ID. This is very similar to the Order Management "Generate Invoice" function. My issue concerns the link to view the contract page that is included in the sendmail function. I have the sendmail functioning correctly and assigning the record ID to the URL (https://creator.zoho.com/<appuser>/<appname>/#View:Generate_Contract?orderRecId=XXXXXXXXXXXXXXX)
Search across all fields (or more than 1 field but with logical OR) and display Summary Record
I can't seem to figure out one thing: a) When I access one of my reports all fields of the database are shown there. I can search within certain fields by clicking on 'search' next to 'add': now above every field/column the search field is shown and I can enter a search in one or more fields (logical AND). Then I can view the summary record of each result by using the context menu in the first column at the very left. That's fine. However, I would like to: b) search one term across all fields and
Thumbnail
Hi, want to use the thumbail function explained elsewhere in the forum. When I write this expression in the formula field "<img src='http://creator.zoho.com/DownloadFile.do?filepath=/" + <UploadFiledname> + "&sharedBy=<Username>' title='" + "' alt='" + "' width='64' height='75'/>" save and then reopen the formula field editing window, the expression was cut to: "<img src='http://creator.zoho.com/DownloadFile.do?filepath=/" the rest of the expression was completely deleted and therefore the thumnail
Splitting a lengthy form into multiple forms (Problem with linking forms together)
I'm developing a registration form for our company and it has too many fields; I'm thinking of splitting the form into three separate forms (i.e. Contact Details, Skills and Services). I tried to link these forms together by pointing to a unique user_id field/variable in the first form however I need this linking to be done automatically and without the need for the user to select anything.The Skills and Services forms are stateless and would not store any data.Could you please advise what is the
Radio Lookup Field Shows as Dropdown
I am migrating a field called "Group" from a dropdown field to a radio lookup field. When creating this new field ("Group1"), even though I select the field type as Radio, it is created as a Dropdown (picklist). Even the form definition says it is a radio field.... Group1 ( displayname = "Group" type = radiobuttons values = data_profiler.Group[(Group.contains("Web") || Group.contains("Data"))].ID displayformat = [ Group ]
Signature in email notification
Hi, When I submit my form, I would like to send an email notification which would include the Signature image. Is that possible ? If I add the Signature field in the email (or in the view template), I get the name of the image file. Many thanks for your help.
How to send email from a new 'From' email ID in zoho creator?
Team, Zoho creator uses the admin email ID to send trigger mails. How can I use a different mail ID to trigger email in one of the application? Please guide!
how to do this
I am wanting to create a database to show the following: top 100 sales consultants, top 100 in points, show stats of order history, each level completed and moved to the next one, active or not active depending on criteria, Total commission earnings. Do I need to setup the forms according to the info on the webpages? Then it will pull the data from their when connected? As for the product displayed on the website, do I need to create a form that lists all the products according to how they are
Employee Database with Skills
Maybe someone can give me an advice here :) I would like to know what is the best way is to do this. I am creating an employee database with forms: One form has all the employee basic data (name, birthday, join date, ...). In addition every employee has certain skills: java, c++, Windows, Linux, ... Each skill should have a different rating for each employee with 1-5 (1 = poor knowledge, 5 = excellent knowledge). Example: Employe 1: java 2 Windows 4 Linux 5 Important is: Finally there will be so
create relation between 2 forms on existing fields
Hi, I imported two forms from excel (table1 and table2). Now I need to link the two tables using existing fields but I do not understand how to do. The table1 and table 2 has field "id" to be linked. I've read this, but don't run: https://help.creator.zoho.com/Creating-relationship.html#Creating_relationship_from_existing_relations Can you help me?
input text to search box
Hi, I am trying to create a URL link so when user click on the link it will open a specific page and input the respective field entry to the search box of the page automatically. Here is the details what I am looking for - - In the above screenshot you can see "FCC MVPD" link which redirect the user to the below link https://apps.fcc.gov/coals/forms/search/cableSearchNf.cfm So in the above link you can see several search criteria where I just want to enter the MVPD name ( here comcast) in the
Lookup field returning strange values
Hi there, I have a lookup field drop down, pulling values from another form which are displaying simply as 1, 2, 3 etc. I want to use a deluge script to do certain things based on the value of the lookup field. However, when I get the value of the lookup field in a script, I'm not getting the visible value of the field (1,2, 3, etc) but getting another strange number eg. 1365899000000572499. Can someone advise how I can get the displayed value of the lookup field rather than this strange number?
Next Page