Invalid JSON String Format
Hello, We are trying to fill-in the pincode of a customer through an API call. The API returns the values in JSON format such as: {"query":"Delhi","pincode":"110001"} If the pincode cannot be found, the API returns with the values such as: {"query":"Searched Address","pincode":"","error":"Not found"} We get a "Invalid JSON string format" error when address fields are left blank on add customer record form. The code we are using to make the API calls is: if (input.Address_Line1 != null || input.Address_Line2
how to set admin permissions to notes?
hi! need document all fields by notes there are more than 50 fields how can i set for notes view permissions "Admin only"?
Add product detail in PurchaseOrders of CRM
Hello, i user ZCREATOR to create PurchaseOrders in ZCRM. I put only Product in a List as itemsList = List:Map(); ..... For each ligne in MyView..... { itemsList.add({ "Product Id" : ligne.ID_produit_ZCRM, "Unit Price" : MonProduit.get("Unit Price"), "Quantity" : newQty, "Total" : newTotal, "List Price" : ligne.Prix_achat, "Net Total" : newTotal }); } My ItemsList is full with product. responseCreate = zoho.crm.create("PurchaseOrders",{ "VENDORID" : idFournisseur, "Subject" : Subject, "PO Number"
can't able to imort app?
When i just trying to import app as a .ds extension it shows me Invalid Request
Dropdown field is showing "Other" option
We have a Creator application where we are tracking Customer's visit activity. Currently the Activity dropdown field has 4 options: Buy - Yes Buy - No Decision Pending Return/Exchange When adding a record, we get the desired 4 options. However, on the edit screen, Creator shows an additional option - "Other" as shown in the image. We suspect it has something to do with the On Load screen of that form but can't really figure out whats the issue. Any help would be appreciated. Thanks!
lost field in report!
hi! previously was made a report all works well few days ago lost 1 field "дата доставки" in field it is, but in report there it is not how to solve it?
What is wrong with this code?
I am new to Zoho Last_Purch_Price, Sup_Cost_Factor, & DPI_Cost are decimal fields, Units_in_Purch is a number field In the same form. I want to calculate the DPI_Cost, but only if there are valid values in the 3 fields needed for the calculation I tried to enter this code in the On User Input field action of the DPI_Cost field: if(input.Last_Purch_Price != null && input.Sup_Cost_Factor != null && input.Units_in_Purch != null) { input.DPI_Cost = ((input.Last_Purch_Price * input.Sup_Cost_Factor ) /
Searching in a lookup field
I am trying to set up a search page based on a lookup field (Child's Name). This generates the ID number. The search field (Search Child) is defined as a Bigint but in the HTML page the searchParam is defined as a string even though it is actually a number. This means the searchParam never matches the Child's Name field. I tried changing the searchParam to be defined as a number but it gave an error saying it was trying to update to a different data type. How can I adjust the code so the search
Child fields
Hi all, I am building a simple database and I would like to focus on 4 forms : Companies: legal company details Addresses: a list of addresses, zipcode, city, aloso defined by an "address name" Sites: association of a company and an address, because companies may share the same address. I have two lookup fields by company legal name (relation to Companies) and address name (relation to Addresses) People: all details for on person with a lookup field to Sites, so that each person is linked to a site,
Filtering Lookups
I am a newbe to Zoho I have three forms: Inventory (with among others 2 lookup Fields, Product_Class and Product_Sub_Class) ProdClass (with one field, Product_Class) containing all unique ProdClass in ProdSubClass ProdSubClass (with 2 fields, ProdClass and Product_SubClass) containing all valid ProdClass and Product_SubClass combinations The Product_Class lookup of ProdClass works fine. I want to filter the Product_Sub_Class lookup to only include records where ProdSubClass.ProdClass = Inventory.Product_Class
Fetch and Update
Hi, I have a form "Lesson Items" with the dropdown field "To_Do". I have a second form called "Plans" that has a lookup field to "Lesson Items", and (also) a dropdown field called "tasks". I already have it set up to pull in the values of the lookup items "To_Do" field and populate the "Tasks" field. That works fine. But what I want to do is make it so that when I update a "Lesson Items" form, it will update any "Plans" forms that have the same ID in the "Lessons Items" lookup field. I have tried:
Subform Record Delete Behavior
Hi, Can someone confirm for me that as soon as i click the "X" delete button on the subform, that record is deleted, regardless whether i Submit the main form or not. Is there any official documentation about this behavior? Is the subform On Delete script executed before or after the subform record is deleted? Again, can't find any documentation that addresses this.
how to extract email from muti-line text?
hi there is records which contain one email in mutli-line field how to extract such email from whole text of this field?
Form Timeout?
Hi all, Is there a way to implement a form timeout? Ideally, I'd like to be able to set a timeout on a form for a period of time where there has been no user interaction define an action when the timeout is reached (in this case load another form) I could try this by building a page with a timeout if I was using a browser, but my app is used within the Zoho Creator Mobile app so I specifically want it to load a form or view on timeout. Thanks in advance!
too long time - adding field to form
hi there is too long time when i add new field in big form https://creator.zoho.com/appbuilder/rfclient/ikeaserv-app/form/zayavki_form/edit was tried on firefox/chrome/safari, macos when i add in a little form - all works well
How can i make a two colum layout only for particular fields?
I just created a form consist of two columns. i arranged the fields. While arranging the subforms field i just want to display in the single column is it possible ? Please suggest me
zoho.currenttime
Hi Sorry of these are dumb questions .. just started using the system ... When I create a timestamps using zoho.currenttime it seems to include the date .. is there a way to only include the time .. Also is there a way in formula to work out the delta between two timestamps .. Example .. first record is (time) 15:00 and second record is 15:12 - so answer would be 12 Thanks Mark
open url
hi. can someone please help me i am trying to pass values from a report to a stateless form my reports url shows as: https://app.zohocreator.com/******/*******/#Report:Quotation?Fare_ID=3 and i wish to open a form using open url and assign fare id field in the form the value of reports fare id. i appreciate your help regards adeel haroon
Customer Portal
Hi, I have created an application and enabled customer portal thru application settings. Later I registered 2 users to this portal for testing purpose. I created a few records by logging in with user X. However when I logged in with user Y, then I am able to see the records created by X and vice-versa. Both the users have default customer profile. This should not happen as one user should not see the data (records) of other user. I am not sure why this is happening. Anyone please help ? Thanks, Milind
One app two CRM accounts
Hi, is there a way I can share an app from my account (A) to two users that are in two different accounts (B and C) and the app access the users corresponding CRM (A, B and C) ??
How to create a daily attendance sheet that automatically populates
Hello. I have this screen shot from an application from the Marketplace, but I can't find the app anymore. I would like to create something very similar to this in my app. After selecting an Instructor, the Enrolled Students section is displayed & populated. Does anyone know how I would achieve this format in a form?
How to unhide fields that have been hidden on load, when i choose an item from a visible dropdown? Then unhide another dropfield or fields on select from this now visible dropdown and so on???
Hide many fields with hide on load. Now when i make a selection on "Product types" want to unhide some hidden field / fields. Getting errors.. not sure about the script needed
creator customer portal permissions
I see in the user permissions for a zoho creator app that i can define field based permissions. I do not see a way to do that with the customer portal. How would I do this?
Form cannot submit
Hi, I created a form and tried to submit it. It just hangs. Could anyone help? https://app.zohocreator.com/zoho_zoho812/hbhd2016/#Form:Pendaftaran
how to send email from custom email address?
hi! there is email of application admin - "app-admin@email.com" and custom email - "custom-email@mail-xyz.com" how to make sending using internal "sendmail" of zoho creator so that 1) from address will be "custom-email@mail-xyz.com" 2) emails from zoho creator's email service will be not in spam because of SPF and DKIM settings of mail-xyz.com email service
Reorder Multi Select Values
Hi, I have a Multi Select Field and it is working good. Sometimes I need to rearrange the order of the Selected Values in the Multi Select Field for some reason for instance if three Values have been selected in the order Val-01, Val-02, Val-03 .. Then If I need to rearrange that order like Val-03, Val-02, Val-01. What I have to do is delete all selected Records first then again select those three entries in the order that I want to achieve -Val-03, Val-02, Val-01.--. What would be great if there
Subform only works in Mobile App
I have created a subform to sort data on the back end as we process orders. The subform has a status field with a drop down but when I try to edit that field in the report in order to sort submissions I receive an error stating "You can submit this form only through the Zoho Creator App" Is there any way to get around this?
Auto identify subform rows
I am just starting with Zoho Creator. T have a form Jobs with a Job_No field (year & job No). There is a subform Labor. I want to populate a field Job_No in Labor with the Jobs Job_No every time a row is added. Please Help alexscott@btl.net
Error Messages
I'm a complete beginner and am just trying to get to grips with zoho creator. However I'm finding it very frustrating as when I try to add coding which is identical to the examples given in the guide I get error messages e.g. adding an email notification to a schedule sendmail [ from: gillgannon12@gmail to: thegannons@eircom.net subject: "Birthday Alert" message: "Happy Birthday <br />" ] gives an error on line 2, improper statement, even though I used the 'send email' drag and drop! How can a bracket
Modified_Time is not updated in the case of bidirectional relationship lookup fields
"Enable bidirectional relationship" option in lookup fields is a great feature, but I think that there is still a problem related to it. Let me start with an example: I have a form named Participants and another one Workshops. In the Participants form I have a lookup field named ChooseWorkshop - which refer to a field WorkshopName in Workshops form. I enabled the bidirectional relation in the ChooseWorkshop field, so a lookup field WorkshopParticipants is created in Workshop form. The WorkshopParticipants
URGENT: Is sendmail working for other users?
sendmail stopped working this morning in our production code. I wrote this simple test function just to see if emails are being sent. They are NOT. I checked my account usage, I'm not over my email quota. void WalkIn.OM.Temp.Test() { sendmail ( To : "lex.shan@walkintour.com" From : zoho.loginuserid Subject : "zoho testing email subject" Message : "zoho testing email body" ) }
How can i show lookup field id
How can i show lookup field id inside any module
External plugins iframe not working
I tried to use iframe(a widget) from external website in my zoho page. But it is not working. Please let me know what is the problem ? Regards, Webber
OnValidate
Hello everyone. You can use alerts and cancel Submit in native modules (Leads, Accounts ...?, If it's possible, how it would be. I welcome your comments. Regards
how to autorefresh Date_Time in views of zoho creator reports?
hi! made report when i open entry - i can change Date_time field. This field depends on system current time. is it possible autorefresh this field in view without openning entry? example 1) i open this view and see list of entries 2) for each entry there is own Date_time setting 3) after 10 minutes in browser window i refresh this view 4) after refreshing - for each entry their settings of Date_time has increased at 10 minutes each
how to make search string - inside a form?
hi there is working form and there is database with about 1,500 records like "city - area" how can i in working form make a search string in which user enters first N characters of city name and below this search string appers a list with all cities which names correspond entered characters with ability to pick up city name see example from other website
Footer with paging numbers
I know that this question is quite old (as I find it in the forum the last years) but as an update, does anyone of you found a hack way to create paging footer? Something like 1/5, 2/5 etc in each page.. I know how to create sticky footer but what about paging?
"Sort by" in reports not working?
Hi Zoho, I'm trying to sort my Flags_n_Alerts report in my app, I try to sort the report by Added Date and by Recepient, the added date and time sorting is only sorting by the time (meaning 12:00 tomorrow will be higher ranked than 17:00 today) and the text sorting is not working at all.... Please fix Thanks Ravid
how do I make a subform show multiple records that were already added according to an action in the mainform?
Hi! I have an application with the following forms: Products Purchase Order Purchased Products Sales Orders The Purchase Order form has the "Purchased Products" as a subform. The "Purchased Products" form has lookup field from Products. So the user loads the form Purchase Order, clicks on Add New "Purchase Products", selects the product and add the purchasing price and quantity. Then other fields as Subtotal and Total are updated on the form "Purchase Order". So far so good. Now, my problem is on
iCal option for timezone?
When I add an iCal feed to an Outlook calendar it shows the event at GMT. In the Zoho app the time zone is set for EST (New York). Outlook shows the event time 4 hours later than in Zoho. Is there an iCal option to indicate the time zone offset? Here is an example of the feed https://creatorexport.zoho.com/zoho_admin3897/appowner/ical/appname/4PsSWBXKUx16BJK0dfQ0G6h8OOakkyBztZwg8ewY0JHD44B3XKSVsHZsfbMWdGFwQpFSpx7n3m0HeuR68sF8y7ZPayJC72s2F9Rv/DTSTART=Next_Contact_Date_Time&DTEND=Next_Contact_Date_Time&SUMMARY=iCal_Display&Record_Owner_Company_Link.Email=bryan@domain.com
Next Page