Error 500 when selecting settings
Error 500 when selecting settings, I can't select settings. app is shared.
problem in ical feed implemetation
I have problem with ical Feed, When we replace the ical field DTSTART with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page.
Ical feed not working in goole calender
I have problem with ical Feed, When we replace the ical field DTSTART value with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page.
how can i Create a list with uploaded file
Hello, i worked in zoho creator, and need create a page, to show some data from a report (zohocreator). I can show all the information, but when show a upload file, just show me a plaint text with the name, but i want show the link to download the file.. how can i do this? This is the code: htmlpage test(numso) <%{%> <table width="100%" cellspacing="1" cellpadding="1" border="1"> <caption>Facturas</caption> <tbody><%for each r in Ordenes_a_Facturar {%> <tr> <td><%=r.Numero_de_So%> </td>
Insert record function stopped working and cant access usage limits
Out of no where we are unable to insert records using functions and it seems we cant see our usage limits section any more. It just loads but will not show any date. Im thinking maybe we have gone over our record limit and so we cant insert any more records. I have added another 10k records but still cant insert records or see how many records we have used in the add-ons usage limit section of setup. Please help, the error message i get when inserting records does not say much but here it is...
append data to URL
Hi there, I had a function with an URL in a variable that appended some data to pre-populate fields: link = "https://creator.zoho.com/zoho_mikis/rangitane-beneficiary-database/#Form:Registrant_survey?Registrant_Email=" + recSurv.ID + "&Registered_with=" + recSurv.I_wish_to_register_with; That worked well, however it's Public that needs to access this form, so I published the form, which gives me the URL with the long public code. I added the same fields to it, but that does not seem te be
Creating multiple records
Hello, I have another question. I have the following forms: Form 1: In this form you have to make a rule and fill give them 3 labels: Label_1 Label_2 Label_3 Description Form 2: In this form you have to make a selection based on Label_1, Label_2 and Label_3. After selection the submit button it has to do: Create new records in Form 3 based on all the rules in form 1 from the selected Label_1, Label_2 and Label_3 in Form 2. So all the labels which are equal on the select Labels in Form 2. I have do
Admin fields visible and editable by user?
I am a little confused how user permissions work. I have several Admin fields, but my users cannot see those. I want to hide certain fields when forms etc are published (as they do now), but my users for this app need to see and edit those fields. Can I give a user permission to see the admin fields?
Does not in years work?
Hi, This saves: rec = Form_Name[!Date_Field in last 18 years]; But does not work, I can't find any mention of whether it should work or not, can you clarify? Thanks, Damien Cregan Hire an Expert
proble in ical feed implemetation
I have problem with ical Feed, When we replace the ical field DTSTART with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page. This is my ical url ' https://creatorexport.zoho.com/tantawy/pipeline-management-and-metrics-tracking/ical/New_Appointment_Form_View/DTSTART=Appt_Date_Time_Original&DTEND=Appt_Date_Time&ORGANIZER=Practic '.
Conditional formatting on upload field.
This is working just fine for standard fields. How can I test for blank upload fields, ie where a file has not been uploaded I want the report to show "red".
How to Send XML API String to crm
I am trying to convert a lead in zoho crm to a potential from Creator. I have followed the documentation here as best I can: https://www.zoho.com/crm/help/api/convertlead.html I have created the XML String but im not sure I know how to properly post this. I am using POST URL function and hopefully I have it formatted correct. I took all my values and put them into a map variable including my XML string. The process of stringing together values to make the XML string is pretty stupid. Maybe there
Will Zoho ever support the distribution of Modules?
Hi, We would like to use Zoho to create a custom module which we can distribute to clients. However, we have been informed by Zoho support that a module can only be installed once. Therefore we cannot distribute updates to our module. It also prevents us from migrating our changes from a test Zoho environment to a production Zoho environment. Is there a way of achieving this at the moment. If not, will it be available anytime soon? This limitation must be preventing a lot of people from using this
Page Title Variable
I would like to put a variable in a sentence in a Creator form that identifies the Wordpress page title that it is in. For instance, the sentence might say "To get a link to (variable) fill out the boxes below." The variable would be the title of the page that the browser is showing the form in. The page title might be "the brochure" or "the video". Alternatively, I could put a piece of code on each page that identifies it, so then the variable would be filled in by that piece of code. How would
New to ZoHo Creator and have a couple of questions
Ok firstly thanks for taking the time to read this. So my project i am working on is an Asset management tool, that will allow us to photograph assets (computer equipment) in our company and add relevant spec info. I have the forms working ok and am happy with that. What we will want to do though is sell some of the Asset's through ebay. Currently this is a very manual task and I would like to make some of it simpler. So what I would like to acheive is: 1) Create a list of all asset's not listed
Can't create a solution for this kind of loop...
I used to find solutions for loops in various situations, but now I am stuck... I need to automatically fill new database table (form) with multiple records. One record represent one calendar day. Records shall start from user-defined StartDate and finish with FinishDate. For instance, 07/12/2015 ... 08/12/2015 ... 09/12/2015 ... This will be used to calculate some statistics for each day, and to print a report / chart. Typically, I code similar loops through recurring function. Hope you've
Zoho Creator Application/Software Development Agreement Template
Hello, Do you guys (zoho creator) or any anyone else have a Zoho Creator "Application/Software Development Agreement Template" we, zoho creator users can use when creating apps for friends or businesses? Iram
Transfer Creator Application to Other User
Hello, I have a professional Zoho Creator account and I don't have a zoho creator developer certification or anything like that, just a regular user of zoho app user. I created an application and shared it with a friend. My friend has added a lot of data to the app including pictures in the picture fields. I would like to transfer the application and data with pictures completely to the same friend. I ran across the below zoho forum question that was posted 5 years ago. Do the instructions in the
CreatorAPI via Powershell
Hi! I have been struggling with the Creator REST API to get it work from Powershell. I have created an API token and I've been working with invoke-webrequest and invoke-restmethod without success. I'm using invoke-restmethod for accessing data on Dropbox via their REST API so I'm pretty familiar on how to do it but obviously not enough... Can someone provide me with a simple list-applications example or similar so that I can just replace the token with mine? Thanks in advance
Customer Portal Security Issue
When a portal user is signed in, his username is displayed at the sign out link. Please remove the user name. Cheers, John Whitney
Ip address of person submitting public creator form
Is there any way to get the ip address of users who are submitting a public zoho creator form on my website? It seems zoho.ipaddress only gets ip address of login in user which is not what I need. I need the ip address of anyone who submits one of our public zoho creator form. If zoho cant handle this directly does anyone know a service or some method that could be used for this?
can you enable or disable fields with an open url command?
I want to disable fields in a form that I open with open url commands. is this possible?
Is there an appointment book app?
Marketplace search isn't working for me. Before I try to reinvent the wheel, does anyone know if there is already an appointment book app available there? Thanks, Ted
Sub Form to deduct stock
Hi I could really do with some help with this, i have a large form we use to book in mobile phone repairs. I also have a basic inventory form to monitor parts in stock What I need to do is add a sub form into the book in form that will allow technicians to add a part that is used ( I can do this easily enough) what I can not do is get this to deduct the part from my inventory form. I have followed tutorials and I can indeed get an app created that will do the above from scratch but for some reason
is it possible to use a deluge statement to affect a field on a stateless form after clicking a button?
example I am inserting data into a from a stateless form. however, once i submit the record, i want to keep some data in some fields in the stateless form and reset other fields to null or empty. so i do not have to reload the entire form and reselect or enter the same information. Make sense?
difference between monthsBetween() Function and subMonth() Function
Hi, Using the monthsBetween() function if I set the start date for the 02-Jan-2016 and the end date for 01-Feb-2016 it will return 1. Is this the default behavior, should it not return 0? https://creator.zoho.com/appbuilder/andrewcorkery/springboard-billing/form/Desk_Reservation/workflow/edit Edit access is enabled. If I use subMonth(1) function on 01-Feb-2016 it returns 01-Jan-2016 as expected. Please fix this. Thanks, Damien Cregan Hire an Expert
Print 2 record summary with 1 function or another
Hello, how is it possible to print more that 1 record summary with 1 function or another. By example i want print the invoice and another record summary automaticlly ? thanks you
Freelance French-speaking zcreator dev in Belgium?
Hi, I am looking for a freelance French-speaking zcreator developer based in Belgium. A customer of mine needs 10-15h of zcreator onboarding/coaching/co-creation. Anybody out there? Merci d'avance! Olivier@egg3.be
Lookup on itself
I am trying to do a lookup on itself. The concept is that I have clients and some of those clients have sub-clients. Sometimes we work for the client and sometimes we work for the sub-client. I would ideally have a single table called clients and give the ability to have them optionally noted as a sub-client with the lookup relating back to its own record set. I know this is doable in Sharepoint. Help would be great.
Reference Data in separate application
Good Morning, I have several applications that could be improved if they could all reference the same "parts" "customer" etc.... type database.... So in the info below what would I need to add or change fir this script to get its info from a separate customer database in a different application? temp = Parts_Order_Form[ID = row.Part_Number]; row.Description=Parts[ID == row.Part_Number].Description; row.Manufacture=Parts[ID == row.Part_Number].Manufacture; row.Vendor=Parts[ID == row.Part_Number].Vendor;
Zoho Creator Import Excel file with the unique value generating in the form
I am trying to avoid the duplication of records imported from the Excel file. What I did: Created a field with "No Duplicate Values" which is generated by combining values from 3 different fields. input.Unique_Value = input.Patient_ID + input.DOS + input.Patient_Last_Name; This script was added to : Form - On Add -On Success, Form - On Edit - On Success, Field (Unique_Value) - On User Input and On Update. I guess, with the current implementation of the data import in Zoho Creator, it is not possible
Create map from a form
I need to create a map from a form, where I would like distinct records based on a field "Studente" and put as second value of map max value of field "Data"; example: Studente Data Mario 26/10/2015 Alberto 6/2/2015 Giovanni 13/12/2015 Mario 2/8/2015 Alberto 6/11/2015 Mario 19/9/2015 I would obtain: Studente Data Mario 26/10/2015 Giovanni 13/12/2015 Alberto 6/11/2015 Thanks
Update a CRM Sales Order product line from Creator
Hi, I have an app in Creator that on record-add creates a Sales Order in CRM with a defined product and defined quantity. As the quantity can be modified after the Sales Order creation, I would like that the updated quantity gets sent to the Sales Order updating the quantity for that product. My problem is that I don't exactly which is the key to be used for the product quantity. So far I tried this both "Quantity" and "Products.Quantity" without success. Here below the code: update_quantity_response
passing a variable from one Page html to a new Page html.
A- I have one html Page where I calculate a variable. B- Then I want to open a new html Page, and send the variable along. Using the code below ("TestVar" is the hardcoded variable for testing purpose): <a href="https://creator.zoho.com/zoho_lh/lhapp/view-perma/LHslett/Variabel='TestVar'", "same window"> <button>Paid</button> </a> C- In the new html Page I want to see/show the variable! Can this be done? Something like: htmlpage LHslett(Variable) <%{%> <p>Variable</p> <%}%> This not
for each index
Hello All I know I need to somehow reference which records in the index.. but and not have any success. contrec = zoho.crm.getRelatedRecords("Contacts",("Accounts"),accid,1,3); for each index ii in contrec { stremail = contrec.get("Email"); strfname = contrec.get("First Name"); strm = contrec.get("Mobile"); } This is the error that return.. Again I know I need to access the by index ....not sure how. Mismatch data type for function get at argument index 1 expected data type BIGINT found dataType
I would like to sort a returned list that I am displaying in a multi select box
I want to sort on the rec.EMPLOYEE.FULL_NAME field. is this possible? Thanks time = List(); for each rec in TIME [(PS_WORK_ORDER == input.WORK_ORDER_NUMBER && date_worked == input.DATE_WORKED)] { if (rec.ID != null) { time.add(rec.date_worked + "-" + rec.EMPLOYEE.FULL_NAME + "-" + (rec.regular_hours + rec.overtime_hours)); } } CURRENT_TRANSACTIONS:ui.add(time);
Zoho Creator Stateless Forms and Lookup fields
Is it possible to use in the Stateless forms Lookup fields? I was trying to use the same lookup field which is used in the base view and in the stateless form but it didn't work for me. If I use not lookup fields to find some matches in not lookup fields in the base view, it works, but in my case, I used lookup fields in the base view and need to find matches there. Even if I used in the Stateless form a regular Single Line field to find matches in the Lookup field in the base view it didn't work
List convert to "text"
I have this scrip On Load Form: tut_str = List(); tut_str = impianti.distinct(Struttura); Struttura:ui.add(impianti[Struttura = tut_str].Struttura); When I save script from another tab like On User Input, script became: tut_str = List(); tut_str = impianti.distinct(Struttura); Struttura:ui.add(impianti[Struttura = "tut_str" ].Struttura); tut_str -> " tut_str" Why? Thanks!
SOAP XML
Hello, I'm really green in this subject and don't really know who I could ask to help me. What I need is as followed: Supplier 1 has a system which confirms to a standard called STOSAG. Supplier 1 can put the data in a webservice (XML). I need to provide the webservice where he can put his data in. I need to automatticly download the data and put it into Zoho. My questions: 1. How do I make a webservice? 2. How can I automatticly download the data into Zoho? Hope someone can help me. Greatings,
viewing formula
Hello We’d like to get an automatic generation of our quotation number Our existing number system is as follow: AA-BBB-YY00-000 Where A is the Department (S-Sales, P-Projects, CS-Construction and Service) BBB is either the first letters of the company name or the first three letters of the company name e.g. Eg: Barbados Agricultural Management Company = BAMC, or Guysuco = GUY) YY = Year 00 = running count of quotes for the customer 000 = Runnin count of all quotes Therefore a quote number
Next Page