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
export data as XL
hello, is it possible to generate an export of data in Excel with script deluge ? I would like reproduce the process of click on gear -> Export -> Spreeadsheet thansk 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
Existing Relation
When I drag a lookup filed on a form, the "Create Lookup Relation" dialog pops-up to allow me to select the lookup parameters. With this dialog, I can create a "New Relation" or choose an "Existing Relation": the problem is that the "Existing Relation" list is always empty even if I already created other relationship. Where am I doing wrong?
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,
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
Next Page