Default value for related drop down
Hello, I have a related field that contains a list of employees and is displayed as a drop down in a form. I need to set a default value for this drop down, how can I do that? This value depends on the logged user, if this user is listed on that drop down I have to set it as the default value, how can I achieved this? Thanks!
Drop Down field looses it auto complete function when populated from a list.
I have a drop down field that i populate from a list. The list is created then sorted into alphabetical order and placed into the drop down field. Once I do this the list is correct, but the drop down field loosed its auto complete function. How can I maintain this feature as it is very useful to the end users.
Send entire form to external site
I want to submit my entire form to an external site to be processed. I see that there is a deluge function, post Url. When I try to set up the function, I don't see an option to send the entire form, only a single field. Is there a way to send entire form?
Retrieve the data from another form
Hi, I have a application in Zoho creator which consist of three form -- Market , TV Station , Census Market form has two field : Market Name ; Market_id ; Census form has three field below: Market Name ( look up from Market form) , Market_id ( lookup from Market form) Households Value . TV Station Form : This form has three fields below TV station Name Market (lookup from Market Form) Households What I need to do is when user select Market from drop down then a script will run and fill the
Field Filter not working after variable assignment script
I have a lookup field with a filter added. When I choose a value in a different field, deluge script assigns a value to the field that is indicated in the filter, but the filter does not execute. If I manually select the Value in the field, then the filter works. I also have a script that runs on user input to that same field in which the filter is dependent "GHS Co". and that script runs when GHS Co is autofilled. The filter is not added via script, it is added in the field settings.... so
All Zoho creator applications are missing.
For our Zoho account caluganda, all of our creator applications are missing. When we sign in with any of our user ids/passwords no applications show up. We created several applications and they are all gone. We need them restored as soon as possible and we need to know what the problem is. Why are they missing in the first place??? Jim K.
Add Button to a Page
I have a Page which pulls and summarises data. At the bottom of the page I would like a button which once the user is happy the summary is correct can click to load data into ZCRM. I have created the data load to ZCRM using a button on a stateless form but would like to do it from a Page. Is this possible? Thanks Gordon
<enter> key for "add new" in subform
Hi, I have a subform that records bin weights for harvested grapes for each of my growers. I can receive 30 to 50 bins at a time. I would like to use the <enter> key on my keyboard to add a new row instead of having to click on the "add new" button. I would be grateful for any advice on how to do this. Best regards, Jeff
Go to URL after form
From a list view, I have a custom action which leads to a form: void Company.AddCalendarEvents(int CoID) { openUrl("#Form:Calendar?Company=" + input.CoID + "", "same window"); } Once I enter values, and hit submit, the form re-loads, but it's not useful to me as the Company Value is not pre-loaded. I would like to either: - have the form reload with the same CoID value OR - re-direct to a different url what do I do?
Can you filter a subform based on a data in the main form?
Can you filter a subform based on a data in the main form? Example I have an employee Data Form and an Employee Time form (for time entry) Can I add the Employee Time as a subform to the employee Data form and only show the time records for that employee? does this make sense?
Creator form code to embed on webpage (not iframe)
Is there a way to get the html / java / whatever code of a creator form so I can put it on my webpage? The iframe embed code does not work for me as i need to be able to add my own css to the form. I need to be able to manipulate the way the form is displayed beyond what you can do in creator. If i could get the source like you can for a CRM form i should be ok. My main problem is i need to put the form at the bottom of the page and the drop down menu from the search form field appears below the
Using ZCStyles
Hi I found this application called ZCStyles (https://creator.zoho.com/public/showAppInfo?ownername=srhyne&callbackUrl=zcstyles) and tried using it. But, noticed that the <style type="text/css"> tags got wiped the next time I opened the note. Maybe that's a bug? Could you please guide a little how to use this application? Could you please guide on changing the theme of my application? I have my own theme and want to customize the application's look and feel.
Problem Setting the Field Permissions
I am a Zoho Creator Enterprise subscriber. For the last two days, I was not able to set or edit the filed permissions for all the profiles. Does anyone also has this problem?
Error while summing rows in subform
Hi, I have a subform called Bin_Weights. I am using the following code to calculate the total net weight: temptotalB = 0; for each record in Bin_Weights { record.Sub_Total = record.Net_Bin_Weight; temptotalB = (temptotalB + record.Sub_Total); } input.Total_Net_Weight = temptotalB; The script saves but has the following errors when I run it: Error details: Error in executing On Add Row script of Bin ID. Error. Error in executing For Each Record task. Error in executing Set Variable task.
All Requests report wrong HTML
As you can see from the attached picture the issue I'm experiencing has something to do with HTML escapes. It seems Zoho sends HTML link code (subject column) with < and > instead of < and >. This leads the code to be incorrectly interpreted by the web browser as plain text instead of HTML. Any advice to resolve this issue? Thanks, Marco
Best way to create Master-Detail Forms / Sub-Forms
What is the best way to create a master - detail form when a master has multiple sub-forms where each sub-form needs to be entered and maintained by a different role 1. Create a master form and then in the master form add sub-forms. Assign access rights for each sub-form based on roles. I guess in the form entry and the form report view this will show only those sub-forms assigned to a particular role when they are viewing it. Also in the Record View it lets you select the sub-forms to be added to
Accessing text of lookup field record rather than record ID
I've been working for several hours on trying to retrieve the String value of a record that I am accessing via a lookup field, but I cannot seem to figure out how to do it. Here is the script I'm using: RepresentativeItems = (Products1[Representative == input.Representative1.toString()].ID).getall(); Basically I want to be able to populate a subform with all of the product sales by a representative, which I will select from a drop-down list, as you can see in this photo: My problem is that when a
Published Report Permissions
Hi, When I set the criteria on my report to.. "Email" == zoho.loginuserid ..it works fine when I access the application, but when I publish the report and access that particular published URL, no records display. However, when I set criteria to.. "Email" == "me@myemail.com" ..all records with "me@myemail.com" are displayed. Why does publishing criteria work for a hard-coded values, but not work for system variables? This seems like a bug..
Error on add row script in subform
Hi, I am using a subform called Order_Details to enter the products and quantities on a Purchase Order form. In order to filter product availability by Supplier, I have written the following script which runs "on add row". itemlist = Winery_Supplies [Contacts == input.Contacts]; clear row.Product; row.Product:ui.append(itemlist.Winery_Product_Name.getall()); The script is filtering the products by supplier in the Product field but the following error appears when a row is added in the subform:
Permission Denied To Update Record(s).","code":2897
Using the REST API (I know where the documentation is : (https://www.zoho.com/creator/help/api/rest-api/rest-api-edit-records.html) to try to update a field on a record. Am getting a response with error 2897 - Permission Denied to Update Records. The view has edit permissions already. Here is the request url: https://creator.zoho.com/api/<owner>/json/student-record/view/myob_invoice_line/record/update/?scope=creatorapi&authtoken=<mytoken>&criteria=('ID = 1612333000001258123')&SYNCDATE=20140905Can
For a List type report is there a way to display/print only the totals rows?
For a report type of "list" you can group by certain fields. When you run the report it shows the grouping header row, detail rows and then a totals row. I want to display/print only the group heading and totals rows and not each detail row. Is there a way to hide the detail rows so that only the group header row and totals row displays/prints? For example we have a table that captures payments (receipts) from donors. This table (view) is linked to the donors table. On the donor summary by name
Can I randomly sort a view?
Hi there! I have a view / report listing potential penpals which is embedded on a website. People are more likely to choose the people listed on top of the list, which I think is based on how recently the record was added or modified. We would like every penpal on the list an equal opportunity to be selected, so we would like the ability to randomize the way the records are listed. Can this be done? Thank you! ~Reed
Zoho Creator - Zoho CRM Zapier link
I have a number of zoho creator forms. I have set up Zapier triggers to zap over the information to Zoho CRM. It works fine with a manual entry to the form. However, when I imported from a spreadsheet into one of the form databases, it failed to trigger the zap of data over to Zoho CRM. I have questioned Zapier and they can find no error on their end. They said "It appears that possibly the API does not support spreadsheet uploads". and suggested I contact Zoho support. I have not heard back from
Sort in For Each Statement
Hi All, I am using the Deluge "for each" statement in a script but I need to treat my records in a certain order. Do you know if I can use a "sort" statement within my "for each" ? It does not seem to exist. Any workaround ? Many thanks ! Guillaume
text field limit length
I have a form that gets filled out by a posttoUrl. Basic information , Name Address etc.. Recent changes in the data has my text field for zipcodes getting the zipcode +4 . I need to validate the text field is only 5 characters and eliminate anything after that
disabling a mandatory field
Hi, I have a form in which I am using the hide and show features to customize the form fields according to the selection made in a lookup field. This functionality is working fine, thanks to advice from the very helpful forum community. I have three fields in the form that are mandatory: -Vineyard -Grower -Lot Depending on the selection made in the lookup field that customizes the form fields through the hide/show feature, either: -Vineyard -Grower or -Lot is displayed in the form. For example,
Validate that file name of upload is not a duplicate file name? SOLVED
(FormName[File_upload == input.File_upload].count() > 0) doesn't seem to work. Neither did (FormName[File_upload.contains(input.File_upload) == true].count() > 0) Any suggestions? (And as usual any help will be greatly appreciated!) SOLVED IT: The problem with the above attempts was that ZC adds a unique string of digits prefix to the front of each File_upload field string to differentiate that file from files uploaded to other records which might have the same file name. The solution
Creator embeded form look up fields are transparent?
I want to use a zoho creator form on my webpage but i need a way to modify it's appearance. You can see my form on my webpage below. It is in the orange footer at bottom of page named (Boat Selection). http://precisionsails.mybigcommerce.com/ I cant seem to figure out why the drop down fields are transparent. I want them to have a white background, not transparent, how can i change this? These are lookup fields in my form. Also is there something i can do to have the menu that drops down appear up
hide command not hiding fields
Hi, I have a form named stage with the following field and data: -Stage -Grapes -Fermenting -Juice -MustI have another form named Analysis that contains fields that I would like to hide in function of the stage chosen. For example, if the user chooses "Grapes", I would like to hide all fields except Brix and pH. To test my syntax, I have only been trying to hide the "Lot" field. I have used the following to try to accomplish this: if(input.Stage.toString() == "Grapes") { hide Lot; disable Lot;
Empty Records?
Everytime I go into the zoho software creator, I generate a blank record. How can this be avoided? Thanks, Mike
Problem with Bulk Edit
In some of my reports, certain users are allowed to edit or bulk edit data. The single edit part works well by bringing up a window of my original form not displaying hidden fields (action completed using the hide/show feature). However, when the user selects bulk edit, ALL fields are listed for the user to edit. I also notice that the Edit Only Visible Fields option is no longer available on the reports in new application. Is this the reason all fields are being shown on bulk edit?
Set Filter Error
Hi, I have a form called block that contains: vineyard & block fields. I also have another form called analysis which contains vineyard and block look up fields. I am trying to filter the block lookup field data based on the vineyard selected in this form. I initially got a type mismatch error when I tried to do this: I then tried using .toString() function which eliminated the error but does not show any data in the block field when I run the app. If I use an actual name in the filter-i.e. "Rotta
Form cut off time? Select next business day.
How would you change a submit date field (input.Submitted_Date = zoho.currentdate;) to select the next business day if it is after 5:00pm central?
Alphanumeric Code
I want to create a code field for my application, and it should look like P100 P101 P102 and so on... i have no idea how to do this in deluge scripting...i am just a beginner....can anyone help me in this regard?? Thanks in advance!!!
Creating if then statements in Creator
I'm working on a Daily Report in creator and want to create full automation. For example I have a drop down on work types (In office or in field). If an employee is working in the field I want the "in office" fields to zero out for hours worked. I have been able to create rules that if an employee selects "in office" as the work type then the "in field" fields are removed. However, I want the "in field" inputs to automatically go to zero if the "in office" field is chosen. Thanks in advance.
From MM-DD-YYYY to MM-DD
I have a field that is a standard date-field (no type), for birthdates. I want to have a 2nd field that shows only Month and Date (eg, Dec 22); what field type should this be?
ZOHO CRM to Zoho Creator Criteria Issues
I am able to push data from Creator to Zoho CRM and create new records and edit records that have been added to Creator. I can also push data from Zoho CRM to Creator using webhooks to create a new record when a lead is added to the CRM. However, I can't get edits in the Zoho CRM to update records in Creator. I think the issue is in the webhook that calls the function. I don't know how to add the required criteria to the webhook.
Getting Data from two fields into a multi-line field
Hi, I am trying to combine 2 fields into 1 field automatically when the two fields are updated. Basically I have a "Start_Time" field and a "Start_Date" field that I need to combine into a "Start_Time_Date" field that will have both displayed in the one field. How can I pull the information automatically into the multi-line field with a soft return between the two fields. Any help would be appreciated. Thanks! Trish
Working with a table inside of a note field
I'm developing a inventory system for service tech's. As a tech places a manual order each part is displayed in a note field as they click on "add". With different part names it becomes messy very quickly. I've inserted a table inside of the note field. How do I place the ordered data inside of the table in a note field?
Huge problems using webhooks on Accounts
I created a Workflow rule to execute on CREATE using a webhook and followed the instructions https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html and had new account details copied over to my Zoho Creator app. I then disabled the CREATE workflow rule and created a new rule to execute on CREATE or EDIT and setup the webhook in the same way. This resulted in a new account being entered in the Zoho Creator app whenever a CRM record is changed. Initially I thought that EDIT would
Next Page