SMS function - International numbers
Hi, I'm from South Africa and our international code on contact numbers is (+27 or 0027). If, I want to use the Zoho default sms function, does my number field have to have the contact number in the international format or any format would do? For example, here in South Africa, mobile numbers start with a "zero". If the international format is required how can I configure my field or script so that what ever "number" is entered into my contact number field has the "+27" international code for South
Sync between Creator & Reports
We use Creator extensively. W e now need to reduce our record count which means deleting older records before a certain date. We need to keep these records somewhere though, so we are planning to export them to Reports. The power of Reports in visualizing/manipulating data looks fantastic, so I am wondering whether I could use Reports to sync with Creator ( as I've seen is possible) so that we have all sales data, both older and recent, in Reports to manipulate/ visualize. However, I still need to
Apostrophe in URL has stopped working
Hi I've had an application for years that loads a variable through the URL with an apostrophe using %27 ie - http://[URL]/Add_Performances?Venue=King%27s%20Theatre%20Glasgow but it has now stopped working. All non-apostrophe variables are fine. Any ideas? Robert
Can someone help with this code?
I'm trying to setup a function to email certain people based on the zip code entered into a form and I'm getting an error with the following code. It's telling me there's an error at line number 1, which is the whole zip code or statements. if ( (input.Zip_Code == "92807") || (input.Zip_Code == "92808") || (input.Zip_Code == "92823") || (input.Zip_Code == "92870") || (input.Zip_Code == "92886") || (input.Zip_Code == "92887") ) { sendmail [ from:zoho.adminuserid to:"jason@lean-labs.com"
Link to form in emails to external users
Hi, I am developing an application which under certain circumstances will send emails to external users with a link to a form for them to enter/update data. there are 2 types of links - link to a form to allow external users to create a new record - the link will contain parameters which will prepopulate certain fields on the form. - link to a stateless form to allow external users to update a record - the link will contain parameters which will prepopulate certain fields on the form. When the submit
Formatting Number Fields
Is there any way to format a stnd number field as x,xxx?
Exporting a Creator File to CRM
How do I export a Creator file into CRM? Is there a YouTube video? Thanks, GPL
"Merging" 2 Imported Fields Into 1 Displayed Field
Is there a way I can Import 2 fields (1st, and last name) from an Input app in Creator into a field that displays as 1 field on the Report app in Creator? Thanks, GPL
Establishing a LookUp Field
How do I establish a LookUp field for a field that's already established?
Merging a 2nd Spreadsheet Into Master Creator file
I have 2 files that have mostly dups, but a few unique records, that I want to import into my Master Creator file. Is this possible, or do I have to simply take those unique records and copy them to new records into the Master 1 by 1?
How can I determine the number of records I am using at this time in all my applications?
How can I determine the number of records I am using at this time in all my applications?
Ipad not displaying forms
My applications work perfectly with a pc, iphone or ipod touch, but not the ipad. The window using applications displays, but whenever I try to open a form, it starts to display the form, but closes and ends up in the ipad window showing the standard ipad start window with all the apple apps displayed. Update: I found that it is Ios 8.2 that is causing the problem. I bought a new ipad mini just today, and when I tested it with Ios 8.1, it worked fine, but when I upgraded to 8.2, the same thing happened.
Commas in decimal field causes problems
I have an application for our contractors time and expenses. The expenses are entered as line items in a subform. This application adjusts the total each time the date, amount, quantity, or currency type is selected or changed. When users enter commas in the decimal field for the Amount, it causes an error that stops the script from continuing so it if there was already a total calculated, and someone changes the Amount, and adds a comma, it won't calculate the total, which is fine, but if there
How do I calculate (today) - (date)?
I'm trying to create a formula which tells me how long I have items on-hand. I think I've gotten close, but I can't get it to work. When I use ( zoho.currentdate - input.MFR_DELIVERED) I get a long version of time. I can't seem to figure out the rest to get the short for of the time. For example, instead of just "9" (for days on hand), I get 777600000. And, I can get this " /(1000*60*60*24)" to work in excel, I just don't know Zoho language to make it work here.
Publish/transfer an app to another client's app
Can you create an app in your own account and then publish/transfer directly to a client's app? Don't see instructions on how to do it. Joe
How can I set report critera depending on information related to the current user?
Hi, I couldn't set report criteria depending on information related to the current user. For instance, if I want to show record from a specific table, I have another table that relates each email with a country, and I want to show only the records that the "country" field is filled with the same country as the current user. something like this: "country == User (email==zoho.loginuser).country" I also tried with user defined functions but reports doesn’t like them cheers! Javier
Add New Entry link not showing in lookup field
The link does not show for users that are not administrators when the lookup form (the form that supply the records to be looked up) are in another application. Is there a workaround for that? Thanks
Hyperlink text wont import into creator?
Is there a way to import the hyperlinked text in my csv file into creator? when I import it it strips out the hyperlink and just leaves the text.
Add notes field does not accept <style> tags
Dear All, In an Add note field if I add the <style> tag like the image and click the Insert then if I go again to the add note to edit something then the box is empty...I tried to click all the buttons (insert-edit HTML etc.) but nothing. Why this happens? If I want to have a style for example in a Add Note field (with <style> tags) then everytime I must delete the add note field and add a new one with the new style?
How to Add Custom Styles Zoho
Hi, I am trying to replicate an existing form I am using, I need to be able to apply custom css to the form that I am currently using and also use a custom image for the submit button. How do I do this? I wasnt able to find any documentation and also when applying my styles in the stylesheet they don't show up Thanks
Share - Make Public option is not displayed
Hi Zoho, I like to share a particular form publicly, so anyone can fill in the particular form. I am following your instruction https://www.zoho.com/creator/help/application/application-sharing.html#Make_Public_to_all_visitors_over_the_web, but I don't see the option "make public..." displayed. I can only share with individual users or groups. How do I enable the "share publicly" feature? Thank you, Ivo
User Defined Variables
With "Script Builder" when I edit, for instance, an "if condition", a dialog pops-up to allow me to compose the statement. For the "criteria" I can choose to use a "User Defined Variable", but the list is always empty. Which is the way to create User Defined Variables?
Auto Welcome Email to those that register off our form.
I'm looking to create a welcome email back to those that register for our events after they fill out the form and submit it. I'm looking for this to be automated so as someone registers, it will kick out and email back to them of all the details for the event and a thank you for registering. Can anyone help me with this, I think I can do it but might need some guidance. Thanks - Mike Olivera
Set null to all fields in the form
Hi, I am trying to write a script on user input of a specific field so when user select the null (something like -Select-- ) then the rest of the fields will automatically set null values. I can try by below code but since there are lots of field so I am looking for short way to do that so I don't have to write all fields individually. Can anybody please help me . Code : if (input.Update_TVStation = null) { input.field01 = null; input.field02 = null; input.field03= null; input.field04 =
Zoho Creator form Integrated into Custom Module
I am using the Zoho Creator to develop forms that speak to the Zoho CRM. I am able to have a form create an entry on submit for the standard modules, however it stops working when I try to apply it to a custom module. For example, in one of my forms I have the following script to run when the submit button reaches "on success": myFieldMap = map(); myFieldMap.put("Product Name", input.Product_Name); myFieldMap.put("Product Description", input.Product_Description); //function to push data to CRM response
If Statement in a Function
Unsure if this is possible or just bad code. void OffHold(int ID) if (On_Hold_Date == "null"); { alert "Sorry, You can not take Off Hold that is not On Hold"; cancel submit; } else { rec = On_Hold_Test_App [ID == input.ID]; rec.Off_Hold_Date = zoho.currentdate; rec.Due_Date = zoho.currentdate.addBusinessday(2); } I'm receiving the following error message: Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Help with Date Function
I'm working on a weekly inspection application. The function I need will reset a date field based on the current date. But rather than resetting the next inspection date by one week, I need it to reset the date to whatever next Monday is. Example: Today is Wednesday 24-SEP-14. On-submit should reset the next date to Monday 29-SEP-14, not 01-OCT-14. Cheers, John Whitney
Page HTML not working
Hi, I'm trying to build a home page using the "insert HTML" feature on script builder. When I drag and drop, the screen turns to a transparent greyish/black (similar to when loading) but stays like that forever. I've tried using two different computers that but problem persists. Please assist. Siya
Linking CRM contact to creator
Creator does liink to CRM. I built a time and billing app in Creator. What I would like is the ability to start at a contact in the CRM and open up the app and have it carry over the contact info. Then have it display in the contact as well the time and billing amount that I entered. Any suggestions on how this can be done?
Restrict user access to certain records in reports
I have multiple users from multiple facilities accessing the database. I don't want all users to see all records from all facilities. How can I restrict the records in a report to one or more facilities, depending on the user trying to view the report? For example, John creates records for the Middletown Facility. Debbie creates records for the Milwaukee facility. Jane creates records for the Denver facility. Sara supervises John and Debbie but not Jane. Sara shouldn't be able to view Jane's
How to fetch data and show in textbox
I am trying to create a textbox that will show work # related to employees under their time cards. Is there a way for me to retrieve work # from one form that they fill out (which they are assign to and have to clock into) and show in the time card under the employee? I like to keep track of the work # they do each day. Could someone give me example on this please. Thanks in advance.
urgent: cannot load form from view
as well, when adding a record I receive message "Unabble to load data" I made some changes to field lengths (appearance and max length) as well as deleting some unused fields. please help. what field or script is causing the error?
Set submitted ID record as default in a lookup field
Dear All, I have two forms Test1, Test2. In the submit button of the Test1 form I have an openurl which redirects to the Test2 form. Now, Test2 form has a lookup field with the IDs of the Test1 form. My question is: When I click the submit button of Test1 I would like the submitted ID of the form to be the default value in the lookup field (in Test2 form). In general I want when I click the submit button then the ID of the submitted form to be the default value in the lookup field (which keeps the
insert a specific value from picklist to another field
Hi, I have a pick list -- Status -- field and which contains several values like -- Duplicate, Review and No Need . What I am trying to do is insert 'No Need" value from the lookup field Status to CD_Status field of Chanel_Database form. Can you please help me to fix . Below is my code if (input.Update_primarychannel != null) { insert into Chanel_Database [ Added_User = zoho.loginuser CD_ChannelType = "0.1" CD_market_id = input.Update_MarketID CD_Network
How do you do the same native form refresh on page with report and form view?
I've been reading the forums regarding refreshing portions of the page. I've tried the iframe method with no avail. My application is a simple inventory tracker, and I'm currently working on the inventory checkin workflow. I have a page that has an inventory checkin form at the top of the page, and a list view of the recently created records at the bottom. I'm not using the native form submit, as there will be instances where I want to scan in one UPC and then attach several serial numbers to it
When creating a record with script, how can I create a checkbox field 'checked'?
I've tried setting the field as true, I've also tried passing in the value to be selected, but every time I create a record with the script I'm using, all the values are set, except the check box. Please help.
Interfacing Creator with SAP
We are looking for interfacing data from our SAP system. On completion of some event in SAP we can push the data out from SAP by any method which ZOHO creator can receive. We would like to receive this data automatically uploaded/added as a new record into a ZOHO form. After an event completion in ZOHO creator we would like to push full or part of data to SAP for an update.I may like to push data from SAP in XML format to add/update a record in ZOHO creator and similarly expect ZOHO creator to push
Combined Reports issues
Hello, I need to combine two forms in a report, but I've been having problems because sometimes the report doesn't display the field data. I've tried this from the Zoho documentation: First: https://www.zoho.com/creator/help/forms/creating-relationship.html And then: https://www.zoho.com/creator/help/views/create-a-combined-report.html And it works but only with some fields, I don't understand why but sometimes some fields doesn't display any information in the report. For example, if I relate the
Error Duplicating records
Could you please tell me why I am getting an error whilst duplicating a record in mrcomputer/signedfast. I assume it is a scripting error but I don't know. Thanks
Application not working on iPhone
Has anyone had any success in getting applications created with Zoho Creator to work on smart phones, particularly via Safari on an iPhone? I can get the initial form to display, but when taps Continue to go to the next page, the next page never loads.
Next Page