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,
zoho smtp used in prestashop
Hello, I'm creating my own site with Prestashop, I have my own server and dns and using Zoho for mail host. When I try to set Zoho smtp for the mailer deamon built in Prestashop and hit the test botton I get this message X error check your settings can anyone help me? thanks
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
Pricing
We resell instrumentation from different suppliers to our customers and have to import the items to Trinidad. Therefore I would get a list price in USD (I may have a discount factor to apply depending on the supplier), I have to the add various charges including S&H, Freight, Insurance, Transportation, Duties, etc and then add a markup to resell. Reselling is done in TTD or USD depending on the customer. I would therefore like to add these cost separately and also to view my estimated profit margin
how to deluge for negative dates
I'm trying to create a report that will filter to identify records with no activity over the past 5 weeks and feel like there is probably a deluge script that I'm just not finding. Any suggestions on how I tweak the following to also exclude records that have activity in past 5 weeks? show all rows from Accounts [(Activities.Activity_Date >= (zoho.currentdate - '5W:0D:0H:0M:0S')]
Approval before form data updated
Hello We want to publish a form from a Creator form. The form is used by external people to update their details. Is there a way to have an "approval" step - after they have submitted the form, but before it is updated on Creator? So that we can check for certain details before the old record is updated/
Export Master and Sub Forms to one spreadsheet
For my first Zoho application I have a master form and have used several sub forms in it. Is there a way to export all the views to one spreadsheet so that the records in the master form stay linked to their data in the sub forms? Thanks
Repeater in zoho??
Hi, I have a page in asp.net where i'm using repeater as input by the user. In a page i have a dropdown for departments, based on department i will get units. These units are placed in a repeater with two dropdown and textboxes and a check box too. in the bottom i have a submit button.. HOW CAN I DEVELOP THIS PAGE IN ZOHO. ACTUALLY HOW CAN I USE TYPE A REPEATER IN ZOHO. can any one please help me. Thanks MOHAMMED
Public record
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
Dynamic picklist based on a form with a deeper form.
Hello, I have 4 forms: 1. Form with single line named: Label 1 2. Form with single line named: Label 2 3. Form with single line named: Label 3 4. Form with three look-upfields based on forms with Label 1, Label 2 and Label 3 5. Form with three look-upfields based on form 1, 2 and 3. Now I want to make the lookupfields in form 5 dynamic. So if in form 5 label 1 is chosen it only has to show the relevant labels 2 based on form 4. I hope someone can help me. Greatings, Erwin.
Sharing an application
I have developed an application using the 3 user free subscription. I share the forms by inviting through Settings/Share. The user I am sharing with does not receive an invitation email. Is sharing available with the free version. What could be wrong?
How to create a two part contact database in Zoho Creator
Greetings, I'm new to Zoho and work in the field of education. I'm trying to create a two part faculty contact database. Part 1 needs to be a standard generic form that I send to each instructor to complete. I need to be able to email a link to each instructor to access the form and submit the form. This I have completed in Zoho Creator. My problem lies with Part 2 of the contact information. Once each instructor submits the form I need for it to be send back to me so I can add their ID numbers,
Publish of this application has been removed.
Hello I need some help. I have created a form and two sub form. When I fill all the information and submit the form then a new page will appear that will show all the information which I had filled before. In this page I have a button "Email for signature". When I click on the that button a email is send to the user with a download link of pdf. When user click on the link and open in a browser then a error is occurred "Publish of this application has been removed. " I have publish my all forms and
Deluge script corrupt/missing
Hi, I am relatively new to deluge scripting. Has anybody has experience as follows. 1. A script with 75 lines suddenly only had 24 lines.(!!) 2.Then the previous versions of this particular script were missing or partially missing 3. Zoho support had replicated this and are investigating. Does anyone else have comments on this? Is this a rare or unique occurence?
Unable to update main table basis sub-table values
Hi I have been trying various methods to do so for the last 2-3 days. Basically, I have the following structure: 1. Main table with fields: OrderID, customername, orderstatus 2. Sub-table with fields: ShopOrderID, shopname, shopstatus OrderID and ShopOrderID are bidirectional fields linked to each other. It is a one to many relationship with multiple rows for each main row I have managed to write a function that updates shopstatus basis update in orderstatus. I wish to update orderstatus if the shopstatus
Dynamich lookupfield
Hello, I have 4 forms: 1. Form with single line named: Label 1 2. Form with single line named: Label 2 3. Form with single line named: Label 3 4. Form with three look-upfields based on forms with Label 1, Label 2 and Label 3 5. Form with three look-upfields based on form 1, 2 and 3. Now I want to make the lookupfields in form 5 dynamic. So if in form 5 label 1 is chosen it only has to show the relevant labels 2 based on form 4. I hope someone can help me. Greatings, Erwin.
Dynamich lookupfield -
Hello, I have 4 forms: 1. Form with single line named: Label 1 2. Form with single line named: Label 2 3. Form with single line named: Label 3 4. Form with three look-upfields based on forms with Label 1, Label 2 and Label 3 5. Form with three look-upfields based on form 1, 2 and 3. Now I want to make the lookupfields in form 5 dynamic. So if in form 5 label 1 is chosen it only has to show the relevant labels 2 based on form 4. I hope someone can help me. Greatings, Erwin.
Updating parent row information basis values in child rows
Hi I have been trying to update a field in a parent row basis values that are edited in the child rows, but been unable to get it working. To elaborate: 1. Parent table has fields - OrderID (unique id), customer id, orderstatus 2. Child table has fields - ShopOrderID (bidirectional field linked to OrderID in parent table), Shop name, shopstatus Each parent row might have unlimited child rows linked to it basis the unique OrderID. I have managed to update shopstatus basis changes in orderstatus. However,
Open published form in iframe using recLinkID criteria
Hi clever people, I am trying to open a form using the recLinkID from another form which is embedded in an iframe and published (not requiring a user to be logged in). I have managed to get the form to open from a previous embedded form using: myURL = "https://creator.zohopublic.com/<username>/<appname>/form-perma/typesfrm/<encryptioncode>/recLinkID=" + thisID + "&viewLinkName=typesfrm_Report"; openUrl(myURL, "iframe", "formEmbed"); ...but the update button in the form does not work to update the
Pages editor: wysiwyg! Suggestions?
I have no experience in html coding, and do not know how to get around to make decent looking dashboards and reports using Pages in ZC. What would be realy helpfull is if it was some kind of external wysiwyg html tool. Perhaps I then could copy the code generated from this into ZC. Then replace some "placeholders" with the data I pick up via deluge? Happy for any suggestions on how I should start to be able to make some simple html page reports in ZC. (To get the data itself from ZC is not the
Action based on Lookup field value
Hi, I have form with a lookup field. Based on the item i select in Lookup value, i want to show/hide fields in that form. Ex: if i select lookup value1, then ct_field should be visible. If not it is hidden. Your help is appreciated.
Unwanted second notification email is sent with subject 'str str'
HI When a use fills in my form, it then sends out an automated notification email. That is fine. It then sends out a second notification email with the subject line 'str str' and the content seems to be a very old version (when I was testing it out). Does anyone have any ideas? I have tried creating new rules but this doesn't resolve it. Hope you can help Steve
Native App Signature Problem
Good day, Im trying to retrieve the url information of a signature field but I got some problems: Sometimes I capture the signature in native app and sometimes I capture in the browser way. In the On Sucess I have this part of code imagelnk = input.SignatureField; The problem is that when I submit the form in the native app this value takes in the On Sucess 1448464101903_Signature.jpg If I check the Url of the image signature is a png file. I try replacing the string extension to match the png file,
Dashboard page
Hi, I am looking for creating dashboard page with various Pivot charts. But I want the users to see charts based only on their user level. Even if i have to create multiple pages its fine. But how can i give permission levels in Pages. You help is kindly required.
Creator customer portal question
If I use the customer portal add-on in Creator, at what level can I set permissions to view records? I want to be able to only allow access to records the customer created in some forms, but in others I want them to be able to view only records created by others. Is this possible simply by using user groups?
Number of days in this month
How do you find out the number of days in the current month?
Emulating an editable grid in Forms
Hi I would like to show a row of fields similar to a spreadsheet that are editable and if possible hidden and shown depending on another field which says how many rows should be displayed. So if the user enters 5 in the other field, 5 editable rows of roughly 5 cells each should appear. I haven't seen any examples yet of this in my searches so far. Any help appreciated. Paraic
Form View not showing column
I have added a new date field to my form, and even though it is showing in the Column Properties edit columns, it doesn't actually show up in the view itself. I have tried deleting it, and re-adding it from the right hand "store" of columns, but it's still not showing.
Help with date validation
I am trying to make a validation alert when a user is entering a delivery date which is before the order date, I do however have the issue that I get the alert regardless if which date the user puts in. Any ideas what is going wrong? if (input.Delivery_date < input.Order_date) { } alert("Invalid Delivery Date"); Thanks.
Map ZC data to Adobe Acrobat PDF form fields
Any ideas on how this could be done? Can a Acrobat form be embedded somehow into a Record Summary? Maybe Zapier could do this?
Invalid json for View Records API
Hi, I am using the View records api to get a list of report. I ask for json response, while sending the get api. But in the reponse I get an invalid json. Please let me know what should be done to resolve this error. Below is the code for ref $service_url = "https://creator.zoho.com/api/json/*************/view/Images_Report?authtoken=*************************&zc_ownername=*********&scope=creatorapi"; $curl = curl_init(); $headers = array( 'Content-Type: application/json', 'Accept: application/json'
Integrate ZOHO people into ZOHO Apps
Hello, I would like to integrate Zoho people into Zoho Apps, I want to integrate only time attendance section of Zoho people into Zoho Apps
How to disable Radio Button choices/values
Hello, I am working on a registration form which has a set of 3 radio buttons for class selections Radio_set1: Class 1 Class 2 Class 3 I would like to disable Class 1, Class 2 and Class 3 individually when certain requirements are met. I do not wish to disable the whole Radio_set1. May I know if there is a way to do this? Thank you very much.
Combining a date with text
Hi, I am creating bookings and I want to give them a title of 'service type' followed by date and time, for example Cycle Training - 12-Nov-2015 13:00:00 This will enable me to have a clear name going forward as I assign other tasks to it. What is the code for this? Thanks Ben
How do extract email address from subform
I am trying to include the email address from a subform in an sendemail?
Changing default orientation of record summary to landscape
Hi, Is it possible to change the page orientation of a record summary to landscape? Also, if I try and print a record summary, the zc orientation paramater does not work with this url: zoho.appuri/record-print/View_Invoice_History/ID Regards, Shaheed
For update Android app after design changes
When I work on my application in the web browser everything works and looks as expected. Now when I look at the Android version of my app, it often does not use the most recent version of the design. For instance, it shows a field I already deleted. Is there a way to force the synchronisation of the new design to be used in Android?
Next Page